Copy Paste multiple rows - incrementing issue [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I'm having a problem, I have 9 rows of data that contain formulas that pick up data from other worksheets. When I copy and paste to the next section all the formulas are off by 10 rows. (There is a blank row) between each set of data.

How do I make the formula in each row increment by 1 instead of 10? I have thousand of these to do it will take me hours to fix each formula by hand. Any help you can give would be much appreciated.



1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
post your formula

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!