Completed

Create excel macros to generate report

Need to generate a report in a prescribed format in excel from three/four different sheets in excel. User will simply type in or scan a barcode (tracking number) and macro will search for that Tracking number in raw data sheets. If tracking number is found macro will fetch and print required data from one sheet to another. I have already mentioned column headings from where the data is required from raw data sheet. There may be more than one rows where data needs to be printed on final report. Macro should adapt to changes in excel sheet. Overtime there may be changes of column locations in raw data sheets - Also there may be changes in final reports as well. More details will be shared after commencement of work.

Skills: Data Processing, Excel, Excel Macros, Excel VBA, Visual Basic

See more: excel vba report generator, creating automated reports in excel, how to create report from excel data sheet with vba, generate report from excel spreadsheet, how to generate report in excel using vba, excel vba report example, generate reports from excel data, how to automate excel reports using macros, excel 2010 generate report, excel macros generate reports, compare excel sheets generate report based common fields, create excel pivot table report, excel generate report macro, excel 2007 macro generate report, excel macro generate report, excel script generate report, script generate report excel, generate report php excel, generate report excel vba macro, create module will generate report

About the Employer:
( 9 reviews ) Bharuch, India

Project ID: #17282098

Awarded to:

zealotmk

Hi I have 3+ years of experience in VBA. I will be able to do this in 0 days and also will meet all your [login to view URL] leave me a message if you wish to hire me

₹1150 INR in 0 days
(2 Reviews)
0.9

28 freelancers are bidding on average ₹1353 for this job

archanaoswal

I can write a macro to create automated reports. I can also make it flexible so that the columns changes can be taken care of. I have excellent command on MS Excel. I have completed complex projects in Excel before . F More

₹4000 INR in 1 day
(76 Reviews)
5.7
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fourteen excel vba projects in the past seventy days. Willing to take up your project. Thank you, Regards.

₹1500 INR in 1 day
(65 Reviews)
5.6
₹1500 INR in 1 day
(76 Reviews)
5.3
prabakarm23

Greetings for the Day!!! I have 8 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook, PDF& Text files, MS Access and SQL Ser More

₹3333 INR in 3 days
(57 Reviews)
4.7
brobb07

1. Excel expert with extensive vba programming experience. I can write you a macro to pull up the relevant RAW data info you need from within the workbook. I have written several similar macros. I can also have you More

₹1300 INR in 1 day
(1 Review)
3.8
cranius

Greetings, Based on the document you attached it is a pretty straightforward macro of iterating another sheet for a desired column and paste the contents elsewhere. I can certainly develop it in a day for you. I am More

₹1499 INR in 1 day
(11 Reviews)
3.8
rickygzz85

I have been programming in Excel for more than 20 years. Please let me know if you have any additional requirements or have any questions via chat. Satisfaction guaranteed.

₹1650 INR in 2 days
(11 Reviews)
3.3
₹950 INR in 1 day
(7 Reviews)
2.2
Dashboard001

Thanks for the project posting, having gone through the project description have a good idea of want is required to be done, rest on award and project commencement. Thanks

₹1300 INR in 1 day
(1 Review)
2.4
₹850 INR in 1 day
(0 Reviews)
0.0
₹1050 INR in 3 days
(0 Reviews)
0.0
diy2918

Based on your description, I've wrote macros as a solution. You can find a sample of that in my Portfolio. If you think these macros are exactly what you want, you can get the macros immediately. Or, if you find some d More

₹850 INR in 1 day
(0 Reviews)
0.0
serenekwan

I have various experiences in developing excel macro tools to generate reports for various users in my workplace. I believe my exposure in terms of communicating with the end users, delivering the product and eventuall More

₹1300 INR in 2 days
(0 Reviews)
0.0
₹1050 INR in 3 days
(0 Reviews)
0.0
bryanhossain

Excelente manejo de Excel con amplio conocimiento y experiencia en macros para automatizar procesos

₹1300 INR in 1 day
(0 Reviews)
0.0
₹1250 INR in 3 days
(0 Reviews)
0.0
hacacak

I am a computer engineer in Turkey. I work for an government company as software developer. I have very good experinces in this area. I am a freelancer in Turkey also. I do not know whether you know Turkish. neverthele More

₹1150 INR in 10 days
(0 Reviews)
0.0
₹1250 INR in 3 days
(0 Reviews)
0.0
KarOneTwo

i love marketing :) Let me know if you need my help in this job, or in other tasks around sale/marketing/analytics Karol

₹1300 INR in 1 day
(0 Reviews)
0.0
Netrut

Hi, I am a professional excel expert with more than 12 years of experience in Excel & Access. I strongly believe that I can compete you project in excel. It may any excel formula, data entry, Data analysis, excel autom More

₹1300 INR in 3 days
(0 Reviews)
0.0