
Excel VBA Macro
- or -
Post a project like this3177
$$$
- Posted:
- Proposals: 21
- Remote
- #1139482
- Awarded
105071235276012014911606191953971228028123738311776081154541116810112357071023446




Description
Experience Level: Expert
Estimated project duration: 1 day or less
General information for the business: Services Organization
Description of requirements/functionality: Macro that will convert the grid style time cards to a database layout for import into a payroll system
Macro that will cycle through every file saved at a specified path and perform the below steps.
All workbooks will be the exact same format
1. Open file 1
2. Copy and paste values from range 'Work Order Setup'!H6:H115 to range B1:B110 of active spreadsheet
3. Copy and paste values from range 'Work Order Setup'!I6:I115 to range C1:C110 of active spreadsheet
4. Paste value Employee ID from range 'Crew Setup'!I6 to range A1:A110 of active spreadsheet
5. Paste value Date from range Monday!B2 to range D1:D110 of active spreadsheet
6. Paste value, transpose Reg Hours from range Monday!G7:R7,T7:AG7,AJ7:AW7,AZ7:BM7,BP7:CC7,CF7:CS7,CV7:DI7,DL7:DY7 to range E1:E110 of active spreadsheet, eliminate blanks between
7. Add “1” in range F1:F110 of active spreadsheet
8. Paste value, transpose Employee Class from range Monday!G11:R11,T11:AG11,AJ11:AW11,AZ11:BM11,BP11:CC11,CF11:CS11,CV11:DI11,DL11:DY11 to range G1:G110 of active spreadsheet, eliminate blanks between
9. Delete rows of active spreadsheet where column E is blank or equal to 0
10. Repeat steps 2-9 above with below adjustments
a. Range in step 6 is row 8
b. Step 7 should be 2 instead of 1
c. Range to paste data to in active workbook changes and should append data to next open row in active workbook
11. Repeat steps 2-9 above with below adjustments
a. Range in step 6 is row 9
b. Step 7 should be 3 instead of 1
c. Range to paste data to in active workbook changes and should append data to next open row in active workbook
12. Repeat steps 2-9 above with below adjustments
a. Range in step 6 is row 10
b. Step 7 should be 7 instead of 1
c. Range to paste data to in active workbook changes and should append data to next open row in active workbook
13. Repeat steps 2-12 for next employee and all additional employees on Monday! Tab, changes ranges as appropriate
14. Repeat steps 1-13 for next day tab (Tuesday) and all additional days (through Sunday)
15. Close file and move file to Archive folder at specified path
16. Open next file and repeat steps 1-15 for the new file and all additional files
OS requirements: Windows
Extra notes:
Description of requirements/functionality: Macro that will convert the grid style time cards to a database layout for import into a payroll system
Macro that will cycle through every file saved at a specified path and perform the below steps.
All workbooks will be the exact same format
1. Open file 1
2. Copy and paste values from range 'Work Order Setup'!H6:H115 to range B1:B110 of active spreadsheet
3. Copy and paste values from range 'Work Order Setup'!I6:I115 to range C1:C110 of active spreadsheet
4. Paste value Employee ID from range 'Crew Setup'!I6 to range A1:A110 of active spreadsheet
5. Paste value Date from range Monday!B2 to range D1:D110 of active spreadsheet
6. Paste value, transpose Reg Hours from range Monday!G7:R7,T7:AG7,AJ7:AW7,AZ7:BM7,BP7:CC7,CF7:CS7,CV7:DI7,DL7:DY7 to range E1:E110 of active spreadsheet, eliminate blanks between
7. Add “1” in range F1:F110 of active spreadsheet
8. Paste value, transpose Employee Class from range Monday!G11:R11,T11:AG11,AJ11:AW11,AZ11:BM11,BP11:CC11,CF11:CS11,CV11:DI11,DL11:DY11 to range G1:G110 of active spreadsheet, eliminate blanks between
9. Delete rows of active spreadsheet where column E is blank or equal to 0
10. Repeat steps 2-9 above with below adjustments
a. Range in step 6 is row 8
b. Step 7 should be 2 instead of 1
c. Range to paste data to in active workbook changes and should append data to next open row in active workbook
11. Repeat steps 2-9 above with below adjustments
a. Range in step 6 is row 9
b. Step 7 should be 3 instead of 1
c. Range to paste data to in active workbook changes and should append data to next open row in active workbook
12. Repeat steps 2-9 above with below adjustments
a. Range in step 6 is row 10
b. Step 7 should be 7 instead of 1
c. Range to paste data to in active workbook changes and should append data to next open row in active workbook
13. Repeat steps 2-12 for next employee and all additional employees on Monday! Tab, changes ranges as appropriate
14. Repeat steps 1-13 for next day tab (Tuesday) and all additional days (through Sunday)
15. Close file and move file to Archive folder at specified path
16. Open next file and repeat steps 1-15 for the new file and all additional files
OS requirements: Windows
Extra notes:

Keith G.
100% (2)Projects Completed
1
Freelancers worked with
2
Projects awarded
100%
Last project
31 May 2016
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies