Merging several Excel spreadsheets together
Discussion
Any tips for merging spreadsheet data together.
I have several with customers details to be used for mailshots etc, I need to remove duplicates and make sure one person is on one row only. titles such as busines name, email and so on are all in the right places using the newest data as priority.
I am sure there is probably some simple techniques but I am not an Excel guru and google so far has resulted in too much guff.
Probably around 3000 people, and trying to avoid doing manually!
Many thanks.
I have several with customers details to be used for mailshots etc, I need to remove duplicates and make sure one person is on one row only. titles such as busines name, email and so on are all in the right places using the newest data as priority.
I am sure there is probably some simple techniques but I am not an Excel guru and google so far has resulted in too much guff.
Probably around 3000 people, and trying to avoid doing manually!
Many thanks.
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff