DarinM
05-27-2015, 05:51 AM
Hi again forum!
I have a bunch of different tracking spreadsheets that I want to combine into one spreadsheet and have different tabs. Sounds like a good idea...
However, I would like it to be a tiny bit more automated/up to date WITHOUT closing the excel document.
I have a bunch of IF statements and conditional formatting, some are based on =TODAY() 's formula for dates. However I have noticed that I need to close and re-open the excel for the =TODAY() to refresh to today's true date, then the IF statements etc are up to date and correct.
So my hopeful solution for this would be two parts.
Part 1; Have a "REFRESH" button on each tab that would refresh a certain column that would have all the =TODAY() dates in them, so that they are truly TODAY's date. I would want each button on each tab to refresh all tabs (so whichever I leave open I can click on one, knowing it will refresh all).
Part 2; After clicking that "REFRESH" button, I would like a macro to search through all tabs and let me know when I need to do something, based on the existing IF & conditional formatting forumals.
For example : I have a formula that compares =TODAY() column with a "ship on this date" column, if the two match, it makes another column say "SHIP TODAY". So I would like that refresh button to go through and refresh the TODAY's dates, then if the dates match, have a Pop-up with what my one column says "SHIP TODAY".
Is this possible?
I can attach a spreadsheet if required to see more what I mean, I have some code in 1 tracker, none in another, so I'm hoping this is a one size fits all type code.
Thanks all,
I have a bunch of different tracking spreadsheets that I want to combine into one spreadsheet and have different tabs. Sounds like a good idea...
However, I would like it to be a tiny bit more automated/up to date WITHOUT closing the excel document.
I have a bunch of IF statements and conditional formatting, some are based on =TODAY() 's formula for dates. However I have noticed that I need to close and re-open the excel for the =TODAY() to refresh to today's true date, then the IF statements etc are up to date and correct.
So my hopeful solution for this would be two parts.
Part 1; Have a "REFRESH" button on each tab that would refresh a certain column that would have all the =TODAY() dates in them, so that they are truly TODAY's date. I would want each button on each tab to refresh all tabs (so whichever I leave open I can click on one, knowing it will refresh all).
Part 2; After clicking that "REFRESH" button, I would like a macro to search through all tabs and let me know when I need to do something, based on the existing IF & conditional formatting forumals.
For example : I have a formula that compares =TODAY() column with a "ship on this date" column, if the two match, it makes another column say "SHIP TODAY". So I would like that refresh button to go through and refresh the TODAY's dates, then if the dates match, have a Pop-up with what my one column says "SHIP TODAY".
Is this possible?
I can attach a spreadsheet if required to see more what I mean, I have some code in 1 tracker, none in another, so I'm hoping this is a one size fits all type code.
Thanks all,