Paula Courtemanche
New Member
- Joined
- Feb 23, 2007
- Messages
- 2
Good Morning;
I have 2 large excel documents; approximately 3,000 rows each; they are similar, but not exact duplicates. (1 is from corporate; 1 is from a branch); I need to create 1 file with both sets of data in it; and there are multiple duplicates. Compare and Merge can't do this because they are not shared workbooks. When I share them I get an error message stating that there hasn't been enough history to compare and merge. Import is messy; and I like the idea of creating an Access database, however this is something that needs to be merged and updated monthly; and personnel will not know how to pull this information from Access.
Any suggestions?
P.S. I know basic Visual Basic;
Thank you.
Paula
I have 2 large excel documents; approximately 3,000 rows each; they are similar, but not exact duplicates. (1 is from corporate; 1 is from a branch); I need to create 1 file with both sets of data in it; and there are multiple duplicates. Compare and Merge can't do this because they are not shared workbooks. When I share them I get an error message stating that there hasn't been enough history to compare and merge. Import is messy; and I like the idea of creating an Access database, however this is something that needs to be merged and updated monthly; and personnel will not know how to pull this information from Access.
Any suggestions?
P.S. I know basic Visual Basic;
Thank you.
Paula