Conditional copy paste values to new sheet. (WB Attached)

**Mayweed** · 02-02-2011, 10:53 AM

Can someone help with this please? I need a macro to compile a statement consisting of details from multiple invoices.

Idea for method.
Find & copy 5 cell values from each sheet in the workbook that match two conditions, then paste them into the end sheet.

Full instructions included on attached workbook.

**mrice** · 02-02-2011, 05:23 PM

No attached workbook

**Mayweed** · 02-02-2011, 07:50 PM

Thanks for pointing that out, I've now attached the workbook.

**Mayweed** · 02-03-2011, 05:46 PM

Can anyone point me in the right direction?

**mrice** · 02-04-2011, 03:49 PM

Can you provide an updated example with some numbers in it on all the sheets so that the instructions can be correctly interpreted?

**Mayweed** · 02-04-2011, 05:07 PM

OK. New workbook uploaded (instructions inside).

**mrice** · 02-06-2011, 04:29 PM

This piece of macro code might do it...

Please Login or Register  to view this content.

Open up the VBA editor by hitting ALT F11

Insert a new module by hitting Insert - Module

Paste the macro into the empty sheet

Hit ALT F11 to get back to the worksheet.

Run the macro by going to tools-macro in Excel 2003 or the view ribbon in Excel 2007.

**Mayweed** · 02-06-2011, 09:32 PM

Thank you, that code works perfectly.
Two more questions.
I originaly asked for the values to be copied to the end sheet, on reflection I should have asked for them to be copied to a sheet that's always in position 4 (i.e. 4th. sheet from the left).

1. If this is possible could you please tell me what to change in the code that you supplied?

2. Would it also be possible to delete the blank cells between the last entry and the sub total row?

**mrice** · 02-07-2011, 01:15 PM

Try this...

Please Login or Register  to view this content.

**Mayweed** · 02-08-2011, 09:59 AM

Martin,
Thanks again for the code, it's working but I'm still having a problem getting it to work the way I want it to.
Would you mind taking a look at the workbook for me if I e-mail it to you?
Through my limited knowledge of VBA and this forum I've created a monster that I'm rapidly losing control over. I would upload it here, but I prefer not to let it loose in the wild just yet.