I have >1,000 rows of data that looks like this:
A B C
1 420 499
6 418 499
8 425 495
I 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:
A B
420 499
My "6" tab has this:
A B
418 499
And my "8" tab this:
A B
425 495
And 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?