With close to 40+ cells of information to be pulled from one sheet and transferred to the next day manually going in and changing this 1240+ times to set up one month would be too much. How do I get the new sheet to pull the corrected cell formulas without going in and correcting them manually. =+'sheet 3'!A1 when making the next sheet. I would like for the formula in cell A2 to automatically update itself to: Rename the new tab as "sheet 4"īy doing the above method of making a new worksheet, the formulas come out the same as the previous sheet and will pull information from the same (sheet 2) place.Ĭell A1 is user entered number and the number transfers over as the same as the copied sheet.Ĭell A3 is copied as the normal "=A1-A2" calculation that is calculated from cells within the same sheet. I right click on the tab, select move or copy, create a copy. Now to easily make 31 days worth with multiple columns of numbers. Use: Today's Runtime - simple calculation of the values from cell Sheet 3 - A1 minus Sheet 3~A2 "the above cells on the same sheet"- 24 Use: Hours from end of previous day- (value pulled from Sheet 2 - Cell A1 - 124 Use: Today's Total Hours - (value entered at the end of the day by user- 148 The next day will be set up as follows: Sheet 3#- Day 2Ĭell formula: No formula -User entered number for end of the day hours Use: Today's Runtime -simple calculation of the values from cell Sheet 2 ~A1 subtracted from cell Sheet 2~A2 "the above cells"- 24 Use: Hours from end of previous day - (value pulled from Sheet 1 ~~~~Cell A1- 100 Use: Today's Total Hours -value entered at the end of the day by user- 125 One column example: Sheet 1# - End of Previous Month Summary SheetĬell formula: no formula -User entered number for end of the month hours 100Ĭell formula: no formula -User entered number for end of the day hours All the user would have to do is enter the start hours on the first sheet then every day enter the end of the day total for the various equipment. I would like the workbook to be set up and ready to use without user manipulation of the formulas involved. It will be unaffected even if the number of days in the month vary. The last worksheet will basically contain the information for the end of the day for the last day of the month in order to copy and paste special values only for the start of the next months start summary. The next 31 worksheets are 1 through 31 for each day of the month The first worksheet will be a start summary of the hours for the previous month. The order of the worksheets in the file are as follows: I want to make a file with 31 days of worksheets in the workbook for the complete month so the files can be organized by date.
My goal on this is to keep track of equipment hours and have a daily report to reflect total hours and run time.
0 kommentar(er)
