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...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.