I am looking for a way to automatically copy data from one spreadsheet to
another spreadsheet.
Main Spreadsheet has a 1st column with phone number followed by several more
columns of user information.
2nd spread sheet has a different list of the same data formatted in the same
way.
I want to combine the two spread sheets.
If the number exists on the main sheet it will copy the data row by row and
paste next to the correct number (by matching column A) and paste it next to
it, offsetting the data to start at the correct column.
2nd issue is if the number does not exist in the main spread sheet that the
macro will insert a row and add the information and the number in the first
column.
I have a third spread sheet that will also need to find, match and paste on
the same row offset a few columns more
Is this possible?
--
Chuck