I have a daily report that is published every morning - we'll call it "Capital Programs Report". From this report there are 380+ columns of data that is ever changing. Also, columns are sometimes added/taken away. I need to create my own Tracker to consolidate this data down to about 30 columns that I care about, so I can work off of this information. How do I do this??? The data in the ROWS will be everchanging - the column TITLES are going to be the headings (for example "site name", "project code", etc) that stay consistent, even the though column location (ie, "Site Name" might be column B one day, Column C the next) might change. The daily "Capital Programs Report" is an emailed Excel workbook to me everyday. I can save this workbook every morning in the same spot with the same name, etc, if needed.
Let me know if you need any more information.