Can someone see if this could be done??

[spuds]

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

[Widemonk]

Would it not be easier to make one large list of 8250 rows instead of 55 x
150 rows ??

Even if you created a 9th column that described the product type (formerly
the sheet name), it would make your data much more accessible and easier to
extract info.

From that, you could use a much easier LOOKUP or depending what you want,
use the autofilter (??)

"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
>
>
>

[exceluserforeman]

Hello,
If you can send me a sample of the project, or the real stuff, I can create
a userform to show details of your needs.

I have some demo utilities that do different things at my excel site.

http://www.geocities.com/excelmarksway


Any information received is not shared with any persons, living or presumed
dead.

- - Mark




"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
>
>
>