Hi Pete,

We are not technical people here and are looking for a low maintenance work
book. The layout for the three employees is identical. It contains 6
columns. 5 of those columns will contain dates only. The first column is
called Projects. The employess will go into this workbook on a basis of
obtaining a new project and filling on the blanks across the row 6 colums
across. This will be done for each project each employee obtains. I wish to
have the 1 row - 6 colums of information to be automatically input into the
cover page for the bosses review. He will have an idea of what project the
employees are working on, when he needs to set time aside to review the
drawings as per the expected finish date. Once the project has been
completed and a bill has been submitted, I will remove that project from the
list.

I hope this information I provided helps. It is a simple task I wish to
complete. It helps us this way with little room for error and it keeps tabs
on everyone.

example columns a

project/consent date/ start date/ approx. completion date/actual completion
date/Engineer Review Date

"Pete_UK" wrote:

You haven't described what data you have or how you want this to
appear in the main sheet. Is the layout of the three employee sheets
the same? How many columns and rows of data are used in these? Do you
want all this data to appear on the main sheet, or do you want to
summarise it? Do you want the data to appear as a block from
employee_1, then as another block for employee_2, or do you want some
other layout?

I can't give much help unless you provide some details of what data
you have, how it is laid out, and what you want to do with it.

Pete

On May 26, 8:28 pm, MelissaParkinson
wrote:
Hi Pete,

All the information is contained in one workbook with 4 tabs, front page for
the boss, and the three employees that need to submit information to him. We
are an engineering firm and these employees on a daily, weekly basis need to
provide information about the projects they are working on. This helps the
boss keep tabs on everyone and also allows him to be prepared on specific
days he needs to review drawings. I want it set up this way so each employee
uses their own individual tab (worksheet), and that info just gets transfered
as this could be a busy process at times!

Thanks!



"Pete_UK" wrote:
What do you want your main page to look like? How will that relate to
the individual tabs that you have? Are all the sheets in one workbook,
or do individuals complete their (one-sheet) workbook and then submit
it to you?

More details please.

Pete

On May 26, 7:26 pm, MelissaParkinson
wrote:
Good Afternoon, I am in the process of constructing a workbook for multiple
employees. I have completed everything I can at this point and have run into
a problem. I need to have the information that the employees will input
under their tab automatically transfer over to a "main page" for the boss to
review. I am aware of using the = equals sign and taking it box for box
over, but I will require more information than that and need something
quicker.
Any assistance would be greatly appreciated. Melissa- Hide quoted text -

- Show quoted text -