PDA

View Full Version : Sleeper: Copy Ranges from many sheets to one



Seppo62
03-03-2005, 02:44 PM
My first post here, would be nice to get help to this one:

I have a work-shift workbook.
3 worksheets have shifts (Week1, Week2,Week3). The fourth worksheet (name of the sheet: PL) shows shifts for one employee.
Using VLOOKUP to get data from Week1-3 to PL.

In PL worksheet I have a Range where different kind of hours are collected from PL. (overtime, evening etc. extras)

The PL worksheet is copied for each employee. Name of the worksheet is the name of the employee. (When we start working with the workbook we have worksheets Week1, Week2,Week3 and PL.)

I need to collect the data from these employee sheets ranges to one sheet.

Any help for this?

Jacob Hilderbrand
03-03-2005, 04:10 PM
Are you trying to do something like this KB Entry (http://www.vbaexpress.com/kb/getarticle.php?kb_id=151)?