Ron,

I got button to work...Looks great.

I don't blame you for not understanding what I meant regarding the
second part....I screwed up.

I want to get the data that is copied to Sheet2, in a row instead of a
column. Basically, copy to Row 1, then Row 2, then Row 3...etc. Not
coping it to Column A vertically, copy it to Row 1 Horizontally...Does
this make sense?


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