offset, multiple sheets

ice1980

New Member
Joined
Apr 2, 2009
Messages
7
I have two worksheets. The second worksheet (sheet2) contains three sets of data, organized by rows. The first worksheet (sheet1) refers to that data, with each set organized by columns. For example, in sheet1, the first cell is something like, "=sheet2!b2", which comes from the first set of data. The second set of data is to be displayed the next column over in sheet1, so, if I were to type manually, "=sheet2!b6". This could be very time consuming. Is there a way (in sheet1) to say that my second set of data is the same as the first set of data, offset by some number of rows? Here's a link to the workbook. Thanks for the help!
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
I have actually included more conditions for this case. The updated spreadsheet is here. Again, even though all the "objects" in "set a" have no spatial relationships, "set b" will essentially follow the same 'pattern', separated by a fixed amount of rows. Thanks again.
 
Upvote 0

Forum statistics

Threads
1,223,370
Messages
6,171,686
Members
452,418
Latest member
kennettz

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top