Copying selected rows from several sheets into one sheet

**ASHMANT** · 03-12-2012, 12:19 PM

Hello, I am seriously stuck finishing a job for a friend. I have uploaded the file. My problem is that I want a button in Sheet 1 that will search through all of the other sheets (in column E) and copy any rows that have a number above 0 in row E to the section in Sheet 1, so it effectively works as a report. I have made 1 button and created a Macro for it in Sheet 2 as a test but that wont work either, if someone could help me with the problem I have I would be seriously appreciative.

**Richard Buttrey** · 03-12-2012, 01:29 PM

Hi,

One way

Please Login or Register  to view this content.

**Kelshaer** · 03-12-2012, 01:32 PM

Please find the attached file.
here is the code as well:

Please Login or Register  to view this content.

**ASHMANT** · 03-12-2012, 02:16 PM

Thank you for the code you have sent over it works wonders. Many Thanks Ash

**ASHMANT** · 03-12-2012, 02:57 PM

Hi I know it's cheeky but would you happen to have Macro coding that I can add to a button so it resets the form, so all numbers in the quantity column go back to 0?

Ash