please help I have been trying to do this for some time and I am lost.
I have a worksheet with a list of 500+ companies and their symbols.
I have another worksheet with 7000+ companies that have b/w 10-20 columns of data. The companies in the 500 list are all in the 7000 list, but I need to narrow down/filter out the data that I do not need from the 7000 company list.
Basically I want to use either the company name or symbol from the 500 company list as a reference to retrieve the data from the 7000+ company list, how can I do this??
(The symbol from above will be best b/c there is no variation in spelling or issue -case sensitive)
Please help me I am lost and this would be of great help to me.
I have a worksheet with a list of 500+ companies and their symbols.
I have another worksheet with 7000+ companies that have b/w 10-20 columns of data. The companies in the 500 list are all in the 7000 list, but I need to narrow down/filter out the data that I do not need from the 7000 company list.
Basically I want to use either the company name or symbol from the 500 company list as a reference to retrieve the data from the 7000+ company list, how can I do this??
(The symbol from above will be best b/c there is no variation in spelling or issue -case sensitive)
Please help me I am lost and this would be of great help to me.