I have watched a few excel videos about it this morning but they are more focused on merging similar records.
From: Steve Jones Sent: Saturday, December 18, 2021 10:30 AM To: AnimalFarm Microwave Users Group Subject: Re: [AFMUG] OT Merging Data I've done this stuff before. Takes a lot of google foo and formatting of each file. And the first time you achieve your goal, it will visually present the way you want then randomly revert. Once it's done you'll never retain the knowlege and have to start the google foo again next time. But yes, its doable, it's easily doable for excel nerds, but they wont tell you how directly. On Sat, Dec 18, 2021, 11:03 AM Chuck McCown via AF <[email protected]> wrote: I have at least three files I need to merge. Spreadsheets. Say one has names and addresses One has addresses and phone numbers One has phone numbers and email addresses They are not the same length of file so certain records are missing in all three files. There is something common to allow one file to be merged into at least one of the other files. I really don’t want to write code to parse and search. I am hopeful there is some kind of feature in excel that could do this. Or I guess I might be able to fire up a database and make it happen. Any suggestions? -- AF mailing list [email protected] http://af.afmug.com/mailman/listinfo/af_af.afmug.com -------------------------------------------------------------------------------- -- AF mailing list [email protected] http://af.afmug.com/mailman/listinfo/af_af.afmug.com
-- AF mailing list [email protected] http://af.afmug.com/mailman/listinfo/af_af.afmug.com
