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
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 cells with values 2 or less. I'll send y you the spreadsheet with the macro and then I can apply any suggestion you might have.
Let me know your comments.
$20 USD σε 0 ημέρα
5,0 (2 αξιολογήσεις)
1,0
1,0
7 freelancers δίνουν μια μέση προσφορά $37 USD για αυτή τη δουλειά
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,
I jave over 3 years in developing functions/macros and add-ins for excel. I can create a timer that starts eveytime cells O5-O45 is updated and there are 2 or more values less than or equal to 2 and when timer expires i update the cells.. I cam start immediately
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 immediately. Let me know.
Thanks