Im looking for some help in looking up data in an excel report that posts all data in 2 columns under headings in column A. I have attached an example. If you look in the report 1 tab, take the following notes:
1) domestic equity, these listings like all other headings will change each month and have a different number of securities underneath.
2) i need to caputure both the security names and the %'s
In summary i need to grab the data in reports 1,2,3 and they go into various reports (named sample) for upload to a website, these 'sample' reports must maintain they're current formatting.