“ITAA” is a folder with, 4 Excel’s workbooks:
1. Master
2. Worker
3. CRU
4. TFS
The first two workbooks, TFS and CRU, are given by me (attached). They are two similar reports generated by two different informatics systems, updated manualy.
I need a freelancer, to create the third workbook, I have attached just a mock-up of it:
1. Master
1.1. WorkSheet Home
1.1.1. Range Input
1.1.1.1. Macro Data_Job
1.1.1.2. Macro Salva_Job
1.1.1.3. Macro Find_Job
1.1.2. Range View
1.1.2.1. Macro Load_Job
1.1.3. Range Commands
1.1.3.1. Macro Import_TFS
1.1.3.2. Macro Import_CRU
1.1.3.3. Macro Report_mattina
1.1.3.4. Macro Report_mattina
1.1.3.5. Macro Open_Email
1.1.3.6. Macro Consolidate_Configurations
1.1.3.7. Macro Create_Worker
1.2. Worksheet Report
1.2.1. Pivot Job Totali
1.2.2. Pivot WI chiusi non lavorati
1.2.3. Pivot WI non segnalati all’assistenza
1.2.4. Pivot WI chiusi con ticket nel CRU
1.2.5. Pivot ticket WI TFS diverso ticket WI del CRU
1.3. Worksheet Log
1.3.1. Table Totali
1.4. Worksheet Data_Job
1.4.1. Table Tbl_Jobs
1.5. Worksheet Configuration
1.5.1. Table States
1.5.2. Table Types
1.5.3. Table Workers
The freelancer will implement the macro 1.1.3.7 from ITAA-Master-Home-Create_Worker, to create a new workbook of the Worker type in the same folder. The fourth workbook “Worker” is just a smaller and simpler copy of the Workbook-Master.
I need the “ITAA” project done in two/three days from when I will give you the full specification of the macros, range, tables and pivot above. Thank you for your attention, Federico.
Greetings for the Day!!!
i have 5 years of experience in Data entry and typing , Excel macro, VB script and VB application creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases.
hope if awarded with this project i can make it best and better with maximum 100% accuracy and satisfaction.
please award me this project and contact me for further details
Thanks
Prabakar M
$40 USD in 2 days
5.0 (56 reviews)
4.8
4.8
6 freelancers are bidding on average $54 USD for this job
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas and macros. Check my reviews and chat with me. Greetings
Hello Federico,
I read through the requirement and also saw the spreadsheet you shared. I can work on creating the worker macro as desired. To be able to work on the macro, I will need more details on how the final output should look like and also what are the input data points. If you could share this information, we could get started right away.
Look forward to hear from you.
Thanks and Regards,
Shikha
(Automyze Consulting)