How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Aitizaz Your Own Question

Aitizaz
Aitizaz, Software Engineer
Category: Programming
Satisfied Customers: 1289
Experience:  2 Years of experience with VC#,VC++,C,C++
17531195
Type Your Programming Question Here...
Aitizaz is online now
A new question is answered every 9 seconds

I want a macro that will open multiple Excel files, combine

Customer Question

I want a macro that will open multiple Excel files, combine the contents of the files in a form of a report.
Submitted: 1 year ago.
Category: Programming
Expert:  Aitizaz replied 1 year ago.

Hello and welcome to Just Answer! I am Aitizaz and i will help you today.

Do you intend to combine different columns in a single report?how much time do we have for this?

Customer: replied 1 year ago.
Necessarily. I just want the fields to line up in the same columns and rows. I have not seen any codes yet.
Customer: replied 1 year ago.
Sorry I meant Not necessarily.
Expert:  Aitizaz replied 1 year ago.

Okay. Please provide me the excel files and also the format in which you want the report. Also let me know the deadline for this. Thank you

Customer: replied 1 year ago.
I have attached 3 files. I was looking for the files, hence the delay. Thanks,
Expert:  Aitizaz replied 1 year ago.

Which fields you want to include in the report and when do u need this?

Customer: replied 1 year ago.
Nope. I don't want to call. I can always give you the best rating if my request is met.
Expert:  Aitizaz replied 1 year ago.

Sure. Please let me know the time limot and also the format of the report i.e. the fields you want to include in the report from these three sheets

Customer: replied 1 year ago.
You can send me an email tomorrow. These fields will be fine: CREDIT, DEBIT, BALANCE.
Customer: replied 1 year ago.
I will check my email tomorrow. Thanks for your help.
Expert:  Aitizaz replied 1 year ago.

OK!

Customer: replied 1 year ago.
Where is my answer. I don't see any code or reply.
Expert:  Aitizaz replied 1 year ago.

I still have few hours to go. I will get back to you very soon.

Expert:  Aitizaz replied 1 year ago.

The two sheet SUZ_AMOR.xls and Garnish.xlsx do not have Debit and Credits as headings. Can you elaborate on this? please identify the column names i.e. A, B ,C ,D of a specific sheet and also let me know how do you want to combine them from the three sheets. thank you

Expert:  Aitizaz replied 1 year ago.

please manually create an example final sheet and upload it here