Listing random lines from different Tabs onto 1 Tab
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.
I don't believe that there is any "command" to do this easily. To me this is something that will have to be done by a macro.
Is this a viable solution alternative?
Thank God there is someone there.
Thanks for your reply.
I have been trying to do this on and off for about two months and if you tell me that a macro is the only way, then so be it. If you told me I had to jump through a hoop while singing Jingle-Bells I would think that was a little strange but so be it.
Can you help me with the macro?
Is there any chance that the "Blue tab" sheets can be modified so that they have consistent headings / columns? At the moment, there are some differences.
Anything you want
Well thatís a surprise. They were meant to be the same. Yes go ahead. Change it any way you want.
You have just moved up to be my favourate person in the whole world.
My email address is email@example.com
Many thanks in advance for your help.
PS: what country do you come from.
I've just sent you a copy of the file. It would pay to remove your email address from the general view area. Too many ways to attract SPAM.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1