View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Vanessa Simmonds Vanessa Simmonds is offline
external usenet poster
 
Posts: 17
Default 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