Multiple spreadsheets

[Karen]

Hi there. I have multiple worksheets that I have to work with and manipulate
data. I only need certain columns of the data from the 6 different
worksheets. I would like to have it all merged into 1 spreadsheet but the
issue is when the reports were created by IT not all headings are the same
across all 6 reports. What is the easiest way (and less time intensive) to
get all data into 1 spreadsheet? Is there a macro that could work? The
cut/paste method is tedious and the consolidate data doesn't work as it's
text/numeric combined. Any insight is appreciated. Thanks in advance.

 

[JP]

Hello,
Can you give some more detail, maybe I could assist.

Are the reports always in the same format? i.e. same headers, always
in same column, etc? If so, you could write a small routine to create
a new workbook, then pull the columns into it.

Hope this helps,
JP

 

[Karen]

Hi JP.

The reports vary and the header with data may not always be in the same
column as the other worksheets. The report also has header name
discrepancies (i.e. Account vs. acct#). Am I stuck doing it manual or is
there a way? Our IT dept. does not move very fast and this manual thing is
killing me.

Thanks for your input!