Thanks Bernie,

Have already been there. Not what I need to do. This is a 40 worksheet
document with graphs. Then automatically export to powerpoint with 40 shops
so automation has to come with it.

What you are suggesting is manual.

Thanks Anyway.

Perhaps someone els can help.

Trev

"Bernie Deitrick" wrote:

Trever,

Get rid of sheet "Selected", get rid of sheet "Choose", and use Data filters on sheet "Info".
Select the table, use Data / Filter / Autofilter, then select your 1 or 2 or whatever from the
dropdown at the top of column A on "Info" That's the best way to do what you want.

HTH,
Bernie
MS Excel MVP


"Trever B" wrote in message
...
Hi,

Have Worksheet = Info Contains Columns A to E

Have Worksheet Called Selected

Have Worksheet Call Choose

That I would like to do is:-

Change a1 on Choose to = "2"

Then Display on Selected Colums A to E from info where Column A = Choose A1

No of colums may very ie 1 = 3 rows, 2 = 10 rows etc

Hope you can help

Trev