Mattster2020
03-17-2009, 03:30 AM
Good Morning All,
I wish to copy the below formula into multiple cells with one column, say column E for example:
='S:\Property Insight\PIO GROUP FOLDER\Main Performance Data\Productivity\[Data_File_W1 - Do Not Use.xls]Monday'!C$3
when the formula is copied down I want the third last chararcter from the end (C) to auto increment (C,D,E,F,G etc) I have tried dragging the formula down but for some reason the value of the alphanumerical character does not increment.
Could anyone help with this and point me in the right direction?
Regards,
Mattster
I wish to copy the below formula into multiple cells with one column, say column E for example:
='S:\Property Insight\PIO GROUP FOLDER\Main Performance Data\Productivity\[Data_File_W1 - Do Not Use.xls]Monday'!C$3
when the formula is copied down I want the third last chararcter from the end (C) to auto increment (C,D,E,F,G etc) I have tried dragging the formula down but for some reason the value of the alphanumerical character does not increment.
Could anyone help with this and point me in the right direction?
Regards,
Mattster