| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula from various sheets
Hi, I have seen similar queries but still can't seem to get it correct as
perhaps i need more basic details. i have 20 sheets. each named according to a staff name: Peter, john, david etc I then have a summary sheet. i would like column A1 to read the staff name on the worksheet tab (is this possible?) Secondly, Column B needs to read overtime for staff. Appears on cell H10 on EACH sheet. So B1: would show overtime for peter. B2, overtime for David etc Column C would then read another cell from each of the staff sheets, so that i would have 1 x summarised sheet, reading all the values from their individual sheets. Please can you assist. Thanks, and apologies if i have asked a few individual for help, as i replied to previous postings. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Data From Different Sheets Via Formula/ae | Excel Discussion (Misc queries) | |||
| IF formula over multiple sheets | Excel Discussion (Misc queries) | |||
| formula to add up on multiple sheets | Excel Worksheet Functions | |||
| Help! Formula between the sheets | Excel Worksheet Functions | |||
| Referencing Sheets in a Formula | Excel Discussion (Misc queries) | |||
Threaded Mode
