Simple Excel time tracking - VBA macro
$30-250 USD
Paid on delivery
I have created a simple Excel form (attached) for users to enter information weekly re the number of hours they spend on certain activities. They will email their individual worksheet to an administrator who will copy/move their sheets into a central workbook. I need Freelancer to develop a macro for the administrator’s wokbook that pulls data from each of these copied/moved sheets into a single sheet in Excel that is in database form. The administrator should be able to click a button in the master wb and the macro will determine the number of user sheets then copy all relevant info from each one into the db, then delete each one automatically. This db data will then be used for reporting, graphics, etc (not part of this scope).
A few other notes:
-The template rows will not change, but the columns may – both the number of columns and the names of the columns. The macro must be smart enough to match the column name to an existing column name in the name in the db or create a new one (for instance, in the form ‘EPA’ is a column – in the future, that might go away in the template and be replaced by something else in the form – the macro would need to create a new field in db)
-Also, the number of columns in the form is currently 7, but this may be contracted or expanded. Again, macro should be smart enough to pull from as many columns as are present.
-Date field in template should be auto-populated with current date if user has not supplied a date
Please note, I am not planning to pay more than $75 for what I consider a relatively simple assignment. I will accept the most qualified bidder at that price or below.
Project ID: #6028113
About the project
11 freelancers are bidding on average $140 for this job
Hi there. I have done a very similar task in Excel before. I would be able to write a VBA macro for extracting user data (with variable number of columns). The only condition would be that all the user files would have More
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality ou More
Hi, I am interested in your project, You can count on me for a 100% quality job done. Feel free to check my profile and see my past similar projects. Thanks & Regards, Peter
Dear Sir, I can do this job for you. I have more than 10 years experience in excel macro and automation. If considered, I can give the results in 2 days at most. Kind Regards, Mohammad
Hello Sir, I would like to work for you on this project. I have exp with this work before, pls check my profile. Pls contact and give more information about the work and others. Looking forward for your reply.
I can complete this task as per your expectations and withing the deadline. Please confirm me that are you going to provide me the format of users worksheet and central workbook. Please write me about your deadline.
Hello, I do not understand if the data sent by the user each time they are deleted and replaced by the new or you want to keep a record of the administrator in Excel. For the historian is required additional work. Can More
