dangerousdaveeg
New Member
- Joined
- Mar 30, 2012
- Messages
- 8
- Office Version
- 2013
- Platform
- Windows
I have a spreadsheet with lots of data that is linked to other tabs in my spread sheet and I am looking for a way to copy a range of cells and then increase the reference in the pasted cells, so for example<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
<o
> </o
>
I have data In Range “C3:C5” with references like<o
></o
>
<o
> </o
>
C3 - “='Raw Data'!A$4”<o
></o
>
C4 - “='Raw Data'!A$17”<o
></o
>
C5 – “='Raw Data'!A$30”<o
></o
>
<o
> </o
>
I might be missing something really obvious here but when I copy these three cells and paste them three cells down the reference does not change to “B” <o
></o
>
<o
> </o
>
I want the pasted cells to have <o
></o
>
<o
> </o
>
C6 - “='Raw Data'!B$4”,<o
></o
>
C7 - “='Raw Data'!B$17”<o
></o
>
C8 – “='Raw Data'!B$30”<o
></o
>
<o
> </o
>
I have to do this for every work day in the year so would prefer a macro that may make my life a lot easier, I have several macro’s in my workbook but this one I can’t seem to find no matter how much searching and testing I have tried.<o
></o
>
<o
> </o
>
So basically what I need is to<o
></o
>
Select range C3:C5<o
></o
>
Copy<o
></o
>
Move 3 cells down (which I can do)<o
></o
>
Paste (but increase the cell reference letter up one but keep row the same)<o
></o
>




<o


I have data In Range “C3:C5” with references like<o


<o


C3 - “='Raw Data'!A$4”<o


C4 - “='Raw Data'!A$17”<o


C5 – “='Raw Data'!A$30”<o


<o


I might be missing something really obvious here but when I copy these three cells and paste them three cells down the reference does not change to “B” <o


<o


I want the pasted cells to have <o


<o


C6 - “='Raw Data'!B$4”,<o


C7 - “='Raw Data'!B$17”<o


C8 – “='Raw Data'!B$30”<o


<o


I have to do this for every work day in the year so would prefer a macro that may make my life a lot easier, I have several macro’s in my workbook but this one I can’t seem to find no matter how much searching and testing I have tried.<o


<o


So basically what I need is to<o


Select range C3:C5<o


Copy<o


Move 3 cells down (which I can do)<o


Paste (but increase the cell reference letter up one but keep row the same)<o

