Thread: Picking up entries from multiple work sheets

Hi guys,

I hope I've posted this in the correct place, Apologies if I haven't.

We've got a 'booking diary' spreadsheet which we put the vehicles/haulier/customer coming in and out of our site, If a particular customer asks for their movements we just use the autofilter function and pick their name from the drop down then cut and paste them into a seperate sheet. This can be time consuming if there are many entries and over a week it can take quite some time.

Is it possible I can set up a macro or something which will collate for example customer 'Speedibake' from all the work sheets and put them into another weeksheet ?

I've attached the spreadsheet for last week, It is column H 'Customer' and the rows associated with the search entry such as 'Speedibake'.

I've also had to delete off my reports worksheet and Saturday and Sunday so it falls under the correct size so I could attach it.

Your help is very much appreciated if anyone can assist me.

Hi guys, I've just tried recording a macro to auto filter then cut and paste but unfortunatly it's not always a static 4 rows, it could be 1 or 200 so the macro idea doesn't work.