ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to merge two worksheets in one. (https://www.excelbanter.com/excel-discussion-misc-queries/148134-how-merge-two-worksheets-one.html)

Vanessa Simmonds

How to merge two worksheets in one.
 
Hello,

I have three worksheets that look exactly the same. One picks up, using
Microsoft Query, the student data for 2005, the other one 2006 and the last
one 2007. I want to merge those worksheets into one worksheet but I don't
want to lose the queries as it will have to be often updated.
Is it a automatically way to do it so when I updated the original worksheets
and the merged one will update as well?

Thank you very much for your support.

Vanessa Simmonds



All times are GMT +1. The time now is 10:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com