Copy cell values in other column with variable intervals

I need to copy value from cell B3 in cell C4:C5 and then value from cell B6 in C7:C14 and then value B15 in Cell C16:C19, etc. intervals are always variable. Is there any VBA code I can use to do this with just a few clicks?. Many thanks

is there a pattern?

1st column+1, row+1,row+2
2nd column+1, row+1-row+8
3rd column+1, row+1-row+4

with a pattern VBA is easy,

Hi rcm,
Yes everytime a get the report will be a pattern to follow, e.g

Acct USD "Copy data in this column" date
2-xxxx
12 "need acct # here" 1/01/2016
13 "need acct # here" 1/01/2016
87 "need acct # here" 1/01/2016
3 "need acct # here" 23/02/2016
3-xxxx
15 "need acct # here" 28/11/2015
16 "need acct # here" 9/12/2015
90 "need acct # here" 31/01/2016
6 "need acct # here" 31/12/2016
3 "need acct # here" 5/11/2015
18 "need acct # here" 16/11/2015
19 "need acct # here" 8/01/2016


It will go on for 2000 row but different intervals.

many thanks

Cheers

Please Login or Register  to view this content.

Hello ce169,

refering to the picture the Acc number to fill in column C...
BTW better is to post a sample file than a pic...

You can give a try to my solution:

Please Login or Register  to view this content.

Regards,
sysss