Create excel macros to generate report

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

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.

Data Processing Excel Excel Macros Excel VBA Visual Basic

Project ID: #17282098

About the project

24 proposals Remote project Active 5 years ago

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
(7 Reviews)
3.2

24 freelancers are bidding on average ₹1418 for this job

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
(182 Reviews)
7.0
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
(95 Reviews)
6.2
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.8
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
(15 Reviews)
3.5
braineebeesdemo

Note: I am an expert in MS Office tools especially excel. I had created several flowcharts(refer attached excel). This is Vijay, a technical lead with 8 yrs of experience in Java, .NET, PHP, HTML, Angular JS and MyS More

₹600 INR in 1 day
(1 Review)
0.0
JesuAnton

Hi I can help you with this task. I am a new freelancer looking for opportunities. I took a look of your excel sheet. So when you give the tracking number, the macro should check the data in ebay,amz,WB worksheets and More

₹850 INR in 3 days
(0 Reviews)
0.4
aditi2614

am an engineer from National Institute of technology Rourkela. Then I worked in ZS Associates as business analyst. I worked mostly on excel, VBA, modelling, automation, dashboards, business strategy problems. Then I wo More

₹850 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)
1.2
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
bryanhossain

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

₹1300 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
ghoshtapabrata87

Being a data analyst with more than 6 years of experience in companies spanning HSBC, Dell etc. I have extensive experience working on excel macros. Have gone through the problem statement; should be fairly simple to s More

₹1450 INR in 1 day
(0 Reviews)
0.0