Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
which one to use: Macros / Formula's / Lookup
I have created an Employees Roster have got 15 sheets each Titled as a Site
Location. Then I have got another 15 sheets, each with the name of a single employee. What I would like to do is have the employees Roster Sheets automatically search all the Site Sheets for the data entered. Thus, what ever is entered into the site sheets it automatically enters the data into the corresponding employee. If this is possible, can anyone help with a formula or macro to do this? Aussiegirlone Data entered here Sheet Name: ParkPatrols Name Start Finish Sun Mon Tue Wed Thu Fri Sat Total Hours ???? 12:00 pm 16:00 pm yes 4 Goes automatically here Sheet Name: Employee (1) ???? Lic Number 1234567 Day Date Start Time End Time Site Total Hours |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup, vlookup and macros | Excel Discussion (Misc queries) | |||
formula's | Excel Discussion (Misc queries) | |||
Formula's | Excel Worksheet Functions | |||
IF formula's | Excel Discussion (Misc queries) | |||
Need Help w/Formula's | Excel Worksheet Functions |