zljordan
11-20-2014, 10:32 AM
Hi All,
I am in need of some help formulating a macro that will allow me to copy data from one sheet to another based upon the a specific criteria. Basically, I have a workbook with the sheets "CopyFrom" and "CopyTo". On the sheet "CopyFrom", I have my data organized the following columns:
A ----> "Ticker"
B ----> "Description"
C ----> "Asset Class"
D ----> "Manager Style"
On the sheet "CopyTo" I have filtered and transposed all of the individual manager styles found in Column D on the "CopyFrom" worksheet. From here I would like to copy all of the ticker symbols ("CopyFrom" ColA) that correspond to the criteria (Manager Style) set fourth in R1 of the "CopyTo" worksheet.
I have attached a sample workbook with an example of how I would like the end result to turn out.
Thank you in advance for your help. It is greatly appreciated.
I am in need of some help formulating a macro that will allow me to copy data from one sheet to another based upon the a specific criteria. Basically, I have a workbook with the sheets "CopyFrom" and "CopyTo". On the sheet "CopyFrom", I have my data organized the following columns:
A ----> "Ticker"
B ----> "Description"
C ----> "Asset Class"
D ----> "Manager Style"
On the sheet "CopyTo" I have filtered and transposed all of the individual manager styles found in Column D on the "CopyFrom" worksheet. From here I would like to copy all of the ticker symbols ("CopyFrom" ColA) that correspond to the criteria (Manager Style) set fourth in R1 of the "CopyTo" worksheet.
I have attached a sample workbook with an example of how I would like the end result to turn out.
Thank you in advance for your help. It is greatly appreciated.