Hi,
My first post here and I need some help and am hoping this is not too hard to do, but I am lost on how to do this.
I have a worksheet with 13 columns and many rows. The columns contain numbers, people names, city names, state abbreviations and email addresses, etc. I have an online form that the user enters this information into and the form then sends the form to me. I can configure the form to send the info any way I wish and I have been inserting a new row in the worksheet and then manually filling in each of the 13 cells. I would like to be able to just do a copy and paste of the complete row all at once. Sometimes one or two of the cells will be blank such as a people name with no spouse and that cell will need to remain blank. What code do I need to use to separate the info to go into the 13 cells?
Example:
Member # (code?) Name (code?) Spouse Name (code?) City (code) State (code?) etc, etc.
I can configure the form to send me the complete line to paste including automatically inserting the user data into the code line so then all I would have to do is paste it into the worksheet manually as one row.
Hope that explains what I want to do and appreciate any help I can get with this. I am using Excel 2002
Thanks, Gene
Bookmarks