I have the following formula
=IF('Sheet1'!B6<>"",'Sheet1'!B6,"")
I need to copy it across roughly 200 rows but I need the cell reference row to increment by 4 each row.
End of result would be a series of rows that look like:
=IF('Sheet1'!B6<>"",'Sheet1'!B6,"")
=IF('Sheet1'!B10<>"",'Sheet1'!B10,"")
=IF('Sheet1'!B14<>"",'Sheet1'!B14,"")
=IF('Sheet1'!B18<>"",'Sheet1'!B18,"")
=IF('Sheet1'!B22<>"",'Sheet1'!B22,"")
Thoughts?
Im sure someone will have a better way, but in the mean time, change your reference to this...
INDIRECT("'Sheet1'!B"&ROW(A2)+ROW(A1)*3+1)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I didn't need elegant, I needed results. You sir, delivered! Thanks
Im happy it worked for you, thanks for the feedback
quick question, what did A2 and A1 signify in the indirect formula?
They are just starting points.
A2 is where you want to start adding from, and A1 is an increment to add multiples of 4 (3 +1) for each row you copy down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks