Looking Up Values On Different Sheets

[cassy01]

is it possible to look up values from different sheets ???

*for example: *

i have created a page called *print-out* and this is where i want th
findings to be put. i need something that will look up all values tha
say *10.00am* and copy columns A-D onto the printout sheet. But thes
are all on differnt sheets.

Sheet 1 Sheet 2 Sheet 3 Sheet 4
10.00am 10.20am 10.00am 10.00am
10.20am 10.40am 10.40am 10.20am
10.40am

do you understand ????

this if for a tournament scheduler where i need to print out al
fixtures starting at 10.00 for the stewards that are looking after eac
pitch

many thanks
Ben

 

[Dave Peterson]

If I were doing this, I'd apply data|filter|autofilter to each sheet.

Then filter each sheet to show only 10:00. Then insert a new sheet and
copy|paste the visible cells from each sheet to that new sheet.

If you need a macro, you could try recording one when you did it manually.

If you get stuck, post back.

(This might even work--if those 10:00's are all in the same column!)