Simple Excel time tracking - VBA macro

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.

Evner: Excel, Visual Basic

Se mere: visual graphics freelancer, vba freelancer excel, simple reporting, master of excel freelancer, freelancer worksheet, freelancer tracking, freelancer other names, freelancer in visual basic, freelancer in excel sheets, freelancer for excel macro, freelancer excel workbook, freelancer date and time, excel visual basic freelancer, excel vba db, excel form to enter data, epa data, central freelancer, master excel, freelancer activities, visual basic form excel, vba freelancer, time-tracking, time sheet, simple macro, simple excel

Om arbejdsgiveren:
( 10 bedømmelser ) Nashua, United States

Projekt ID: #6028113

Tildelt til:


Hello there, I'm a software engineer with more than 15 years experience in Excel, Access, VBA, VB6, .NET, SQL. I'm waiting for detailed project description. I am Top 1% in VBA on Freelancer and lot of experience Flere

$77 USD in 3 dage
(14 bedømmelser)

12 freelancere byder i gennemsnit $134 på dette 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 Flere

$180 USD in 2 dage
(48 bedømmelser)

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

$150 USD in 3 dage
(40 bedømmelser)

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 Flere

$136 USD in 2 dage
(49 bedømmelser)

Excel and VBA expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please check my portfolio for: [login to view URL] Estate (video demonstration) [login to view URL] (video demonstrat Flere

$149 USD in 7 dage
(24 bedømmelser)

***Similar Projects I've done a lot. Please check IOHL, hotel management samples in my Portfolio********* Good Day!....I'm an Expert in Excel VBA Automation. Having 7 yrs of Exp. Have developed & designed various E Flere

$70 USD på 1 dag
(17 bedømmelser)

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

$111 USD in 3 dage
(9 bedømmelser)

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.

$130 USD in 3 dage
(4 bedømmelser)

Skills- ASP.NET,C#,VB.net,Microsoft SQL Server Created Purchase Manageent system,Cylinder Management System,Job Search Website,Database Backup Modules,Report Management System. Automation Testing(QTP),Manual Testing Flere

$155 USD in 10 dage
(1 bedømmelse)

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.

$188 USD in 5 dage
(0 bedømmelser)

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 Flere

$111 USD in 6 dage
(0 bedømmelser)

A proposal has not yet been provided

$155 USD in 3 dage
(0 bedømmelser)