lewisjohnson13
New Member
- Joined
- Sep 1, 2016
- Messages
- 1
Hi
I'm having a few issues with copy and pasting a formula into the adjacent columns, but being able to over ride the cells it picks up on another sett for every 3rd column. for example I have the formula
'2a Substructure'!$S$8+'2a Substructure'!S9+SUM('2a Substructure'!S150*2%)
I need the the letters to change to "P" in the adjacent column, then to column "M" and so on, all with the formula staying the same, just picking up the differing columns.
Any assistance really would be appreciated!
Thanks in advance,
Lewis
I'm having a few issues with copy and pasting a formula into the adjacent columns, but being able to over ride the cells it picks up on another sett for every 3rd column. for example I have the formula
'2a Substructure'!$S$8+'2a Substructure'!S9+SUM('2a Substructure'!S150*2%)
I need the the letters to change to "P" in the adjacent column, then to column "M" and so on, all with the formula staying the same, just picking up the differing columns.
Any assistance really would be appreciated!
Thanks in advance,
Lewis
