Countdown Timer for Excel
$10-30 USD
Paid on delivery
Hi,
I have a spreadsheet (attached) that populates data 5 times per second from an external source using COM.
Data is populated in various places but the relevant part is range O5-O45 on sheet W1. I want a timer to start automatically at 3 seconds and run down each time two or more values in that range are equal to or less than 2, ignoring blank cells.
Some more details:
1. if on a subsequent refresh of the data two or more values are again equal to or less than 2 the countdown should restart at 3, even if the previous countdown has not reached 0;
2. on reaching 0 the cell should return to empty;
3. the timer should appear in cell AF5 of sheet W1;
4. there is other code in the spreadsheet and it will need to run alongside that without conflict. It will also need to run alongside other spreadsheets containing VBA without conflict;
Thanks
Project ID: #10900362
About the project
Awarded to:
Hi, I am a software developer and I just downloaded the attached spreadsheet. I added the counter checking changes in the mentioned cell range. This counter will start when it detects a change and there are 2 or more c More
7 freelancers are bidding on average $37 for this job
I have the expertise in Excel and scripting in VBA to do the task of creating the Countdown Timer. Ready to start work immediately.
Dear client, I have a lot of experience with VBA and Excel. Send me a message for more information. Looking forward to work with u. Kind regards, SlenDATA
Hi Please have a look at my profile, I am expert in macros and timers. Done a similar project with excel timer and with the windows scheduler also. I am rated 5 out of 5 for my project done here. Can start immedi More