Hi !!
I Have a a validation list that it will helps me to copy and paste som
particular columns from a workbook to another.
Being more specific.

I have a workbook A.
I have under the column B row 4 (B4) a list that contains e.g. th
words one, two, three etc.

What I want is.
When i choose the list item 'two' i want to be connected with a macr
that it will do the following:

It will go to the already open workbook B, it will copy the column'
range A4:A800 and then to paste special to the column B4:B800 of th
workbook A.

If i choose the list item 'one' i want to be connected with a macr
that it will do the following:
It will go to the already open workbook B, it will copy the column'
range G4:G800 and then to paste special to the column B4:B800 of th
workbook A.

Thanks in advance

Stathi

--
Message posted from http://www.ExcelForum.com