I have a workbook that I have over 50 worksheets in. One for each employee that lists their hours during each payperiod and calculates their total hours worked. I would like to compile this into a summary worksheet that has each employee in a list and have only their total hours listed next to their name. Each employee sheet is formatted exactly the same with their name in cell A1 and the sum of their total hours worked in cell C40. To create a formula that automattically transfers this information into the summary sheet, I would have to put "='Doe, John'!A1" in the employee column (A) and "='Doe, John'!C40" in the Total Hours Worked column (B). Is there anyway that I could simply copy the formula from the first cell in the column to the cells beneth and have excel automatically change the sheet name to the next sheet in the workbook. It would take forever to edit each cell. If I have to do that, I might as well just go in and type all the information myself from each worksheet. PLEASE HELP!!!!
Bookmarks