View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Is it possible to be able to merge say 60+ worksheets into 1 workbook?

hi swampysgirl

See my site for a few examples

will be sending it in to me probably once a week

See also
http://www.rondebruin.nl/mail/folder2/saveatt.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"swampysgirl via OfficeKB.com" <u32881@uwe wrote in message news:6fdcc0c8c7d5a@uwe...
Thanks Susan! Each person will have their own individual workbook, and they
will be sending it in to me probably once a week, then someone else will be
making phone calls based on the content of each sheet turned in, but we want
to minimize the 'merge' time...

Susan wrote:
is it one workbook that 60 people are working on? or do they have
their own individual workbooks?
if it's one single workbook, you've got it easy.
if it's 60, & especially if they're not all set up identically, then
you've got it a LOT harder. but it can still be done, i believe.

more info would help somebody figure it out (& i may not be that
somebody if you've got plan b going on!).
:)
susan

This is my story...I'm trying to help implement a program where over 60
people will be inputting information into a worksheet, which will keep year
to date figures, and calculate numbers on a qtrly basis as well. I'd like to
make this as automated as possible, so as to minimize the clerical time
necessary on this project. Does anyone have any suggestions?


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200703/1