I have 4-6 separate commission reports that are all either CSV for excel files. They all have multiple columns of information but I only need 7 or so columns from each spreadsheet. Each column is named differently and in different orders between the reports. I need to extract the 7 columns that I need from each report and combine them into one master report. The 4-6 commission reports will be a new file every month. I need the information to stack on top of each other in the master report. For example, if commission report #1 has 3 sales that information will be in lines 2-4. If commission report #2 has 5 sales that information will be in lines 5-9. And so on. I need someone to create a formula or VBR or something else so I can simply choose the 4-6 separate commission reports to use in the formula and click a button.
All you Excel experts out there, is this possible?
53 freelancere byder i gennemsnit $124 på dette job
Dear Employer, Yes its very much possible. I understand most of the things in your job. Please message me. I will do the job for you. Thanks and Regards, Ash
Hi there, I’ve checked the project details and I can do this perfectly. I have huge experience in working with these projects. Waiting for your quick reply. Look forward to hearing from you soon. Best Regards
The better solution is on Access database. You could link the sheets and merge & generate the report like you want. Then, export this to Excel file. Please, contact me and we could make a little test to show you.
Hello I saw your project and I understand and I can do this because I have good experience about this and if you give me your project then I will give your good quality work
I can do this. please review my profile and inbox me. I have good command over MS Excel especially povit table, charts, advance formulas, formatting, macro etc. thanks
i can share you the required values within 2 hour i will use excel formulas for this purpose will charge you minimum amount Looking forward to hear from you. Thanks Faisal
Hello Sir, I'm an experienced and highly professional excel expert. I can assure you about top quality work on your project. Your project is what I'm specialized in. Can we discuss sir? Thanks