Hi! I have a vacation tracker workbook with a worksheet for each employee (we only have 10 employees so it's not too bad) and the first worksheet is a summary sheet (used to do the month end vacation accrual). On the Summary sheet, there is a cell named SmryDate where I put the month ending date for the accrual and there is a table below it that lists each employee and the number of vacation hours (done by referencing named ranges on each employee's ws). On each of the employee's worksheets, cell G4 (named AsOfDate for all worksheets) is the date the worksheet uses to calculate the hours as of that date. What I want to have is a command button next to the SmryDate cell that changes the AsOfDate on all sheets to the SmryDate. I tried the simple Range("AsOfDate").value = Range("SmryDate").value but that didn't do anything...I'm assuming because the name is the same on all tabs and it doesn't understand (I searched 3D range and saw a post where someone said VBA can't handle those). The sheet names are the employee names so those will not always be the same.
Also, I need to be able to change the AsOfDate on individual tabs so simply putting a formula in those cells to say =SmryDate will not work. I'm guessing the answer is something along the lines of selecting all sheets but the first and setting cell G4 (that will always be the same) to SmryDate, but I'm not that versed in VBA code so I don't know how to write that code. Any help would be greatly appreciated!!
Bookmarks