previous sheet

Hi, I have a macro that enables me to move to the previous sheet. However when back at the start I would want it to loop back to the last sheet in the workbook. The current code is displayed below and it checks for any hidden sheets and it misses out the first sheet which is the home sheet. Any...

I create a new sheet every weekday and use the date as the name of the sheet. I have a formula in one column that counts the "days at site" that tracks the number of days a trailer has been parked. It's a simple SUMIF that finds if a trailer was on the previous sheet, and if so, returns the...

I have a spreadsheet that displays the weekly sales of my employees. I have a table that displays the weekly sales and then one below it on the same sheet that displays the year to date sales which are calculated by adding the current week sales to the previous weeks (which are displayed on the...

Greetings, I used a "user defined function" to reference a cell on the previous worksheet regardless of the worksheet's name. The function works fine and updates automatically until I open a new workbook; at which point the original worksheet (with the UDF) reads the cells from the newly...