How do I change +Sheet1!XY for each sheet? [Closed]

Report
Posts
2
Registration date
Thursday May 18, 2017
Status
Member
Last seen
May 18, 2017
-
Hi,

I've been using +Sheet1!XY to copy data from one sheet to another, from the same row in Sheet1 - row 8

On the next sheet I need to to copy the data from row 9, and so on. How do I easily do this change in the +Sheet1!XY formula without having to manually edit the row number?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!