Linking spreadsheet data across pages

[Janine Vienna]

How do I link data from a master list to sublist on subsequent pages in a spreadsheet so when I change the master list, the data changes on the sublists?

[JBeaucaire]

I use INDEX/MATCH for this kind of work almost exclusively. As long as there is a key piece of unique data on the sublist (UserID, ProductCode, etc...) that matches the same data from the master, all the rest of the fields of data can be pulled in real-time from the master using that unique value.

http://www.excelforum.com/excel-gene...ame-row.html#3
http://www.excelforum.com/attachment...tch-sample.xls

The sample document shown above uses a drop box validation list to make the pulling even easier.