Need macro help please

genestoy

New Member
Joined
Jul 30, 2010
Messages
5
I really need someones help with a macro I need. There are two of us that need this macro. I am using Excel 2002 and the other person is using Excel 2007 so either need a macro that will work for both or two separate macros. The string that is sent by the registration form is below that we use will be copied and then pasted (by the macro I hope) into the worksheet. I need the copied string to be placed in each respective cell and if the form user leaves a item blank then the cell will also need to be left blank (such as the last cell they don't all have children)


A17; Bill Smith; Mary Smith; Phoenix; AZ; Bigfoot; 21; 2003; 8 ; 15; 19; justme@mysite.com ; Joey

Apparently I can't attach a copy of the workbook? There are 13 columns total and the rows are added and removed. The macro can be run from a button or Ctrl+whatever key
 
Last edited:

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Watch MrExcel Video

Forum statistics

Threads
1,133,163
Messages
5,657,172
Members
418,363
Latest member
Debating_Earth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top