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