Hi ..Im only a novice here & about to ppost my own issue up.

Sounds like a simple select case statement needs to be run.

If cell x =John Brown...open "this worksheet" else next case
...within each case simply reference the data to be transferre
fromto.

...as I said only a novice...but if you know VBA...Im sure you`l
understand where Im coming from.;

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