How can i merge all the information into one ?

  • Thread starter Thread starter Santi
  • Start date Start date
S

Santi

I hace 3 worksheets that when first made were identical but since each
worksheet is managed by individual users they have changed it and made
ittheir own. What I want to do is merge all 3 worksheets and make a master
worsheet with info from all 3. What's the best way to do this?
 
I hace 3 worksheets that when first made were identical but since each
worksheet is managed by individual users they have changed it and made
ittheir own. What I want to do is merge all 3 worksheets and make a master
worsheet with info from all 3. What's the best way to do this?
Click to expand...

If the three worksheets that you want to merge have names "Sheet1",
"Sheet2", and "Sheet3", try this formula in cell A1 of a new sheet:

=Sheet1!A1&Sheet2!A1&Sheet3!A1

Copy cell A1 to the right and down as far as needed.

If this "merge" is not the type of merge you expect, then please
explain in more detail the data structure in the three changed
worksheets and what data structure you expect to have on the master
worksheet.

Lars-Åke
 
Back
Top