Custom Order Template VBA or Macro

**RAH** · 03-11-2008, 12:36 PM

I am trying to write a formula whether it be in VBA or a Macro that will do the following.
In cell A7 and A10 there are validation boxes that drop down with a list of items that can be selected.
We want the user to be able to add multiple items under each month but keep the list to only what is needed. Therefor the function I am trying to get is once cell A7 has a selction or isnot blank or is greater than 0 we want to add a line directly below it with all the same functionality as line 7. Everything else will shift down and maintain the same functionality.

I have a attached a sample workbook... Can this be done

and if so any help would be greatly appriciated! Thanks RAH

**RAH** · 03-11-2008, 07:40 PM

Can anyone help me with the code on this one? I have bits and pieces but just cant seem to get it together. I would sincerely appriciate your help!
Thanks
RAH

**VBA Noob** · 03-11-2008, 07:46 PM

Please read forum rules below and add the link to the cross post

VBA Noob

**RAH** · 03-11-2008, 07:48 PM

I was just going to PM you. I need your help. Sorry I didnt mean to cross post.

**VBA Noob** · 03-11-2008, 07:52 PM

Still no sign of the link ??

Also need to add to the other forum otherwise it will be locked!!

VBA Noob

**RAH** · 03-11-2008, 07:58 PM

Sorry about the cross post. I didnt trully understand what I had done wrong until now. I can totally appriciate this rule. My cross post is at http://www.ozgrid.com/forum/showthread.php?t=86445

They wont let me post this link there until after 24 hours and I will do just that tomorow when I return.

Thanks VBA Noob for pointing that issue out.