W Toku

Countdown Timer for Excel

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

Umiejętności: Visual Basic for Apps

Zobacz więcej: visual basic for applications, daily log count excel, count excel data, automatic letter count excel, vbscript count excel files folder recursive, cash count excel sheet, count excel words special characters, letter count excel, finding count excel, word count excel different word, word count excel, lost timer countdown software, excel spreadsheet stock details, excel 2007 lock cell data refresh, great plains cycle count excel, flash cs4 digital timer countdown, excel world contact details, as3 animated timer countdown, count excel, script count excel files folder, timer countdown visual basic, digital led timer countdown clock flash web, timer countdown virtuemart, lost timer countdown, iphone programming timer countdown

O pracodawcy:
( 6 ocen ) United Kingdom

Numer ID Projektu: #10900362

Przyznane użytkownikowi:

diorisaguilar

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 Więcej

$20 USD w ciągu 0 dni
(2 Ocen)
1.0

7 freelancerów złożyło ofertę na średnią kwotę w wysokości $37 do tego projektu.

$100 USD w ciągu 1 dnia
(12 Ocen)
4.1
surekash7096

I have the expertise in Excel and scripting in VBA to do the task of creating the Countdown Timer. Ready to start work immediately.

$35 USD w ciągu 1 dnia
(1 Ocena)
2.8
slenders13

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

$30 USD w ciągu 2 dni
(2 Ocen)
2.6
psprongs

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 expi Więcej

$25 USD w ciągu 1 dnia
(1 Ocena)
2.5
$25 USD w ciągu 1 dnia
(1 Ocena)
1.1
furqanshakoor

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 Więcej

$25 USD w ciągu 1 dnia
(0 Ocen)
0.0