Ok, here is a beauty.
Please look at the attached file for more info.
I have four Blue Tabs and six Red Tabs on a spreadsheet.
The project is simple. The Blue Tabs are the source data and the Red Tabs are the result areas.
Each Blue Tab has a column called "Supplier" ($C$).
Each Red Tab is dedicated to a "Supplier" which includes all the relavent information
All I want to know is what is the command to all the information from each line of a supplier (from all the blue tabs) to list into their respective red supplier tab.
IE: On the 5 Blue Tabs there will be many lines for a Supplier called Purax. I need all those lines relating to Purax on the 5 Blue Tabs to re-display on the one Red Purax Tab.
Bookmarks