I require some assistance please

[MelissaParkinson]

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

 

[Pete_UK]

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

 

[MelissaParkinson]

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]

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

 

[MelissaParkinson]

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 are:

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

 

[MelissaParkinson]

Okay....I figured out a simple way to do it, highlight two boxes and drag
down the amount of rows I need. So that step is complete.

Here is another one for you. How can I make tab 1 (workbook 1) the bosses
review page a "read only"? Is that possbile?

 

[Pete_UK]

Hi Melissa,

you can apply protection to a worksheet to prevent changes to
formulae, layout etc (accidentally or deliberately), and this
protection can have a password (or not) to restrict it further. The
password can be easily broken by a determined hacker, but this does
not seem to be the case in your company from what you have described.

There are two aspects to it - cells themselves need to be locked for
the protection to apply to them, so highlight all the cells, click on
Format | Cells | Protection tab, and ensure that Locked is checked.

Then click on Tools | Protection | Protect Sheet. You will be
presented with some options, including whether to use a password or
not (write it down somewhere if you do).

Hope this helps.

Pete