I've browsed/searched here and have found similar topics, but I'm not
following the implementation of them so well...

I have 5 or 6 workbooks that I'd like to be combining the contents of
into one master workbook. They're all exactly the same, and each
workbook is made up of 9 worksheets. 5 of the sheets in each book are
time sheets where employees hours are listed, and 1 of the sheets is a
page where employees data is entered. The info entered into that page
propogates the other 5 hour pages in columns on the left side so that
on the time sheets all that can be entered is hour totals for the
week.

To get it all into a master workbook, I just need to copy the same data
ranges from each workbook per worksheet. I'm certain it's possible, and
I can customize it if I have a decent template; I'm just having trouble
getting started.

More info: The employee data range is up to almost 200 rows, but data
within those may only be, say, the first five rows. Is there a way to
return/copy/paste only the rows that have data in them, allowing maybe
two spaces (empty rows) between each workbook copied into the master
workbook?

It seems like a tall order, but I'm sure it can be done and I'm hoping
to do it!

Thanks :)


--
JHongTurney
------------------------------------------------------------------------
JHongTurney's Profile: http://www.excelforum.com/member.php...o&userid=29369
View this thread: http://www.excelforum.com/showthread...hreadid=490814