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?

On Sun, 28 Feb 2010 05:35:01 -0800, Santi
wrote:

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?


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