Abhilash Mathew
New Member
- Joined
- May 5, 2010
- Messages
- 5
Hi all,
I need help on how to go about copying data from one sheet to another based on a certain condition, specifically industry or sector. This is to keep track of daily trades, etc that are changed daily. I have one sheet labeled Today's Events and then a few sheets divided by sectors such as Financial, Energy, Pharmaceutics, etc.
Here is some info and closely related example of some of the data
A B C D E
A1 Country Company Code Sale Amt Industry
Denmrk Oreal STM FP (£1.20) Financial
Sweden Nabisco FGR FP (£ 3.5) TMT
France Chinxl ELI1V FH SEK (3.6) Energy
I would like this data to be copied, for example there is a financial sector,and I would like for the financial sheet to automatically copy row B based on industry, and so forth. How would i do this? Is there a VBA code I can use or any other way? Please and any help is appreciated. Thanks!
I need help on how to go about copying data from one sheet to another based on a certain condition, specifically industry or sector. This is to keep track of daily trades, etc that are changed daily. I have one sheet labeled Today's Events and then a few sheets divided by sectors such as Financial, Energy, Pharmaceutics, etc.
Here is some info and closely related example of some of the data
A B C D E
A1 Country Company Code Sale Amt Industry
Denmrk Oreal STM FP (£1.20) Financial
Sweden Nabisco FGR FP (£ 3.5) TMT
France Chinxl ELI1V FH SEK (3.6) Energy
I would like this data to be copied, for example there is a financial sector,and I would like for the financial sheet to automatically copy row B based on industry, and so forth. How would i do this? Is there a VBA code I can use or any other way? Please and any help is appreciated. Thanks!