Consolidating multiple workbooks into one?
I have three large spreadsheets that need to have all of their information
consolidated into one workbook. The spreadsheets share Column Headings and
some similar information but some information will be unique only to its
spreadsheet. What I want to do is have all three spreadsheets merged into
one. Keep all of the column heading that aren't repeated from workbook to
workbook as well as the information contained within.
|