create an Excel Spreadsheet Macro

Cancelled Posted 6 years ago Paid on delivery
Cancelled

We are scanning packages from random vendors and freight carriers into an excel spreadsheet, this works well. We also want to insert the date and time the package was scanned. What I’m trying to do is to create a macro that will populate a cell with the date and another cell with the time. This will be based on the scan field being populated. Such as “if A1 >0, then insert current date into A2 and insert current time into A3”. It’s been too long since I used macros. I should say I’m not married to a macro, if there is a more efficient way to accomplish this, I open to anything that gets the job done efficiently.

Coding

Project ID: #14195314

About the project

7 proposals Remote project Active 6 years ago

7 freelancers are bidding on average $20/hour for this job

jaylancer43

Hello Sir, My name is Jay and I am #1 Excel VBA programming expert on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-st More

$25 USD / hour
(14 Reviews)
4.8
zdesign77

Hey, how is it going today? My name is Michael, I'm a web designer/developer from Boston. I've had a look at your project description and feel that my skills match your requirements perfectly. In fact, I did a very sim More

$22 USD / hour
(0 Reviews)
0.0
cerfani

Your description makes the task seem fairly simple. I don't think it would take much time. If it literally takes me no time, I will do it for a review ;)

$15 USD / hour
(0 Reviews)
0.0
saown666

hello having rich interest on this project, im interested to have a little chit chat to go into deep. i will gladly response to your attention. thank you

$20 USD / hour
(0 Reviews)
0.0