I gang

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

Færdigheder: Excel, Visual Basic

Se mere: visual graphics freelancer, vba freelancer excel, simple reporting, master excel freelancer, freelancer worksheet, freelancer tracking, freelancer excel sheets, freelancer excel workbook, freelancer date time, excel visual basic freelancer, excel form enter data, epa data, master excel, freelancer activities, visual basic form excel, vba freelancer, time sheet, simple macro, simple excel, need freelancer excel macro, macro vba, freelancer vba, freelancer excel vba, freelancer excel sheet, excel vba macro

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

Projekt-ID: #6028113

Tildelt til:

adim

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 Mere

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

12 freelancere byder i gennemsnit $134 for dette job

maverick44000

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 Mere

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

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)
5.9
avinav606lx

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 Mere

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

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: 1.Real Estate (video demonstration) 2.Orders (video demonstrat Mere

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

***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 Mere

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

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)
3.4
vanluatbk

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)
1.6
shuchi266

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 Mere

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

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)
0.0
maurobattiato

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 Mere

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

A proposal has not yet been provided

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