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
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
Sorry it looks messy, here is file as picture
Query.jpg
It continues same pattern in column but different number of row, one account only need with 3 rows, next 145 rows, next 24 rows, etc
Last edited by ce169; 03-20-2016 at 07:30 AM.
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:
Regards,Please Login or Register to view this content.
sysss
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks