On Thu, 24 Nov 2005 15:52:02 GMT, "spuds"
wrote:

Hi
I have a very large price list in a spreadsheet, what i like to do is export
certain information from those spreadsheet into another spreadsheet ie:
Name Description price ?
what i tried to use was a lookup function but it went really bad it needs to
get info from there is 55 worksheets with each worksheet has a different
name and each sheet it has 8 colums and 150 rows but i only want a small
part of this, l hope i have asked it clearly enough for someone to help me.
Thankyou in Advance

rob

If I've understood you correctly, I'd suggest that you use an
AutoFilter on each sheet to filter the data you need and copy it to a
second workbook. Repeat for each of your 55 sheets copying underneath
the last set of data.

To speed the task up you could use a macro to do the whole thing if
you're comfortable with VBA.
Otherwise a half way house would be to record a macro to do the
autofiltering on one sheet, and play this back on each of your 55
sheets, doing the copying and pasting manually.

HTH



Richard Buttrey
__