Consolidation macro - specfic rows from multiple worksheets based on set criteria into a m

[jsbaker88]

Hi

New to the forum...hope you guys can help!!

I have 10 sheets (named "client 1","client 2" etc) and 1 master (named "breaks"). Each of the 10 sheets represents a set of activity from one particular client which is being compared against our bookings for the day for accuracy and completeness (a rec..).

In each sheet columns A to H are standard (beyond 1 is client data in irregular formats). In column C is a unique order ref which compares details against our booking (in sheet 12 "Daily Business"). If details match, our internal reference is added to column B. If there is a mismatch or something is missing, column B will flag "check" or "voice execution" for our staff to review..

Now, we are planning to have many more clients so it will be much easier having one master summary sheet which can use the same headings as A-H from client data sheets. I would like staff to open the sheet, enter in the raw data provided by each client on the revelant tabs (columns I onwards), which is standardised and reconciliatied in columns A-H. The macro will then populate the breaks sheet with rows on any client sheet flagged as "check" or "voice execution". Each sheet has a different number of rows populated.

One other thing is when importing some clients' exports some numerical fields are entered as text when pasting. I have to highlight the column and click the yellow warning error and convert to number. Is there a way to do this automatically; formatting to number through formatting options doesn't seem to work.

Praying someone can help as I'm a VBA virgin...I know what I want just no idea how to get it.

Thanks
James

[Pavan_Jack]

http://www.rondebruin.nl/copy2.htm

Check this out.. works like a charm

[jsbaker88]

thank you very much although this doesn't seem to be able to copy rows from my sheets based on cell values in column B.

If anyone would be so so kind to help I will love you forever more.

[JBeaucaire]

Click GO ADVANCED and use the paperclip icon to post up a smaller copy of your workbook. Make sure the workbook demonstrates your desired results if possible, or just highlight the cells you're trying to fix. Use BEFORE/AFTER sheets if that helps make it clearer.

[jsbaker88]

workbook attached...stripped down and basic version but should get the idea

Client1/ Client2/ Daily Activty - user goes in and dumps client data/ our data into the green area. This is reformatted into a standard which can be looked up in the light blue. User doesn't touch anything else on these tabs.

User goes to breaks tab, hits button at top, breaks are listed below for them to work off. Break population should include every line on any client sheet columns C-I (my actual sheet has 10-15 tabs and i expect more to be added in future) where column B states "check" (i may also add additional conditions e.g. "different system check oracle")

User then populates column H manually with their investigation outcome which is placed in column A of the respective client sheet for records.

Hope that's enough info and many thanks once again

[jsbaker88]

would really appreciate it if someone can help