1

I am new to scripting VBA from scratch. I have been using formulas to complete the task, but it is requested that I use a VBA to eliminate the excess spacing needed for my formulas to work properly. I have multiple worksheets that I want to the data from to populate my form(s). If column A represents the selection of the item by entering the quantity or no charge(NC). example of my worksheet is:

enter image description here

I have the selected data in if isblank = false formulas that combines the selected line into one string for the order form. Then I use the left, right, and mid formulas to separate the string into the columns needed for my check list form. What I want to do is eliminate using the one text string, and use the if isblank = false to populate my check list form.

Jaumzera
  • 2,305
  • 1
  • 30
  • 44
Anwahs
  • 11
  • 3
  • Welcome to SO. Please read [How to Ask](http://stackoverflow.com/help/how-to-ask) to receive the most effective help here. As your quesiton is written you will likely receive little help and have the question closed. You'll need examples of your problem and the code you have already tried. – Scott Holtzman Jun 06 '16 at 16:51
  • @newguy i was being sarcastic. not having a great day. – Anwahs Jun 06 '16 at 16:59
  • @Jaumzera thank you for taking time to assist me. appreciate it. – Anwahs Jun 06 '16 at 17:06

0 Answers0