Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining several workbooks
I lhave 6 workbooks all the same column labels that contain from 100 to 30
records of various clients. There are a number of duplicates due to inexperience of entering data and managing files. I have all of in one file folder and have made each on a "shared" file. I get an error message when trying to merge the sheets in order to remove duplicates. What is the way out of this mess? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining several workbooks
I would think probably copy and paste from book 1 to the end of records on
book 2, then repeat to book 3, til all on one sheet in one book. Then, you can either do a pivot table or just import the data into an Access Database and run a query that groups by all values... "rwaldsmith" wrote: I lhave 6 workbooks all the same column labels that contain from 100 to 30 records of various clients. There are a number of duplicates due to inexperience of entering data and managing files. I have all of in one file folder and have made each on a "shared" file. I get an error message when trying to merge the sheets in order to remove duplicates. What is the way out of this mess? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining Workbooks | Charts and Charting in Excel | |||
combining 2 workbooks | Excel Discussion (Misc queries) | |||
combining many different workbooks | Excel Discussion (Misc queries) | |||
combining workbooks | Excel Worksheet Functions | |||
Combining workbooks | Excel Discussion (Misc queries) |