boxsterman
Active Member
- Joined
- Apr 16, 2002
- Messages
- 285
I have data on one sheet in row 1 through 5. I would like to link to this data in 5 separate rows on another sheet. The other sheet where I would like to set up the link from, the data is not in consecutive rows. i.e. row 1, 6, 12, 16 etc. When I copy and paste the reference link it automically assumes that I want to pull data 5 rows down (row 1 to row 6). Is there are way to reference a cell above plus one row down.