Need help combining multiple sheets

[vivamonkey]

I've created a budget with several sheets, with each individual sheet a
seperate portion of a budget. I'd like to take all those sheets(7
total) and put them all on one sheet titled budget which will scroll
horizontally and not force the user to click on sheets for viewing. I
would rather have them simply scroll left and right to view all sheets.
Due the many formula's on the document, a simple copy/paste does not
work.

This must be easier done than said!!

thanks in advance!!

 

[Mike Middleton]

vivamonkey -

It's not clear to me exactly what you have or what you want, but you could
investigate (1) Edit Copy followed by Edit Paste Special Values or (2)
Consolidate (see Excel Help).

- Mike
www.mikemiddleton.com