In Progress

Break summary Macro

I have several excel workbooks saved in various different folders. I want a macro which will be used to compile a summary of the other workbooks.

So the macro should:

1) look for a certain workbook names in a certain folders (wb name and folder path will be listed on a tab of the macro, called "File names"). It will tick off or highlight in some way workbooks its finds with match the name, and if some are missing it will skip and go to the next workbook

2) Then look for two certain words in column A and copy the row for cell A to AA for any any data between these two words (The words are "Cash Breaks" and "Misc Adj". Cash breaks will always be above misc adj. If these two names are not found on each tab it checks please flag according on "File names" tab on macro and skip to next tab on workbook.

3) The macro will ignore certain tabs on the workbooks, like any tabs starting with"_" or called "Raw Data" or "GL"

4) It will paste the data copied back into one tab on the macro on column C. And in Column A it will have the workbook name the data came from, and in column B it will have the tab name the data came from.

5) Macro will end by saving results in a folder and pop up a text box with a warning of either "All workbooks found and included in results" if all workbooks on list were found and the two names on each tab it looked in where present or "Some workbooks data were not found, please check "file list" for more details"

That's it, if you need some dummy data, I can gladly send you on a few workbooks to demonstrate what I mean etc, hopefully this will be a fairly straightforward project as I have lots of future work I need done which will be more complicated, all excel based.

Thanks,

Skills: Excel

See more: check into cash, summary, copy paste names in excel, break, compile excel file, excel macro match data, excel macro row, text box excel, excel 2013 macro, excel summary results, excel raw data work, raw paste data, macro match excel, vba macro summary day, copy cell cell excel macro, excel macro data list, project workbook excel, excel checks, match macro, raw data macro, copy paste cash, work dummy data, excel match data paste, match paste data, macro summary details

About the Employer:
( 3 reviews ) Dublin, Ireland

Project ID: #5113847

Awarded to:

microk

Dear Gerski, VBA expert here.. Please share the files and get it done within few hours... Please check some samples of my work here: 1. Countdown - [url removed, login to view] 2. Speedometer based on values- h More

€20 EUR in 3 days
(23 Reviews)
4.3

12 freelancers are bidding on average €26 for this job

deepbluetech

Hi Gerski, Would need some dummy files to test with and have a question regarding the folders. Could I assume the folders to be residing within a certain folder ? - The folder will be specified as input by the More

€35 EUR in 1 day
(77 Reviews)
5.4
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at my feedback to know more about me and my work. Waiting for more details along with posi More

€30 EUR in 3 days
(16 Reviews)
4.7
rengrish

Excel Expert freelancer here with over 10+ years of experience . I have done similar kind of project. I can go through this very easily. Please check my review and ratings. I can complete this within a day

€30 EUR in 2 days
(33 Reviews)
4.4
jaylancer43

Hello - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among n More

€29 EUR in 3 days
(22 Reviews)
4.2
zExcel

Hi, I will be happy to write that macro for you. Please send me the master file and a sample data file together with folder names and I will start on it right away

€44 EUR in 0 days
(12 Reviews)
4.1
satishkadam2000

Have 16+ years of experience in IT field. Well versed with Excel, Excel Macro Word. Data Entry. Will complete the job in time. Looking Forward to get this job. Have experience in writing Excel Macro. Thanks More

€24 EUR in 5 days
(0 Reviews)
0.0
ncristea

hello! i can do anything you need in excel . if you need faster then 2 days you must tell me and i can hurry up and delay my other projects. thank you

€24 EUR in 2 days
(0 Reviews)
0.0
akhilmsmsakhil

A proposal has not yet been provided

€23 EUR in 3 days
(0 Reviews)
0.0
mdishtiaque

A proposal has not yet been provided

€14 EUR in 3 days
(0 Reviews)
0.0
realovac

A proposal has not yet been provided

€23 EUR in 3 days
(0 Reviews)
0.0
mmp3396

Hello! I have great experience programming in VBA for Excel, Word and Access, so I can do this job for you with joy. Thank you.

€14 EUR in 5 days
(0 Reviews)
0.0