I have >1,000 rows of data that looks like this:
A B CI need a way to update the data in other tabs labeled "1", "2", etc. based on the data in A, such that my "1" tab should have this in it:
1 420 499
6 418 499
8 425 495
A BMy "6" tab has this:
420 499
A BAnd my "8" tab this:
418 499
A BAnd I need all the data updated on the fly, and the rows will almost never be sorted based on any column. The data contained in tabs "1" through "10" is used to create mapping information, and it has to be separate from the data in the "Main" tab. Is there a formula I can add to my "Main" tab that will parse down through all the rows and update the remaining tabs with new data?
425 495
Bookmarks