jmac001
asked on
VBA Loop with multiple criteria
Hi Experts,
After recording what I would like to be done I realized it will only work on a loop and I am horrible with writing loops. I would like to populate columns B and C on the Parts Request tab when on Sheet 1 Column S has yes. If you look at the attachment on Sheet1 S6 is yes no I would like to see B6 the Item # populated to B15 on the Parts Request tab and then A11 (Sheet1) would be populated to C15 on the Parts Request.
Is it also possible to have this automatically populate on the Parts Request tab once "Yes" is selected (from Column s). The example has 37 items populated but the items that may require action can be less or greater.
EE-Help-Snag-2015.01.16.xls
After recording what I would like to be done I realized it will only work on a loop and I am horrible with writing loops. I would like to populate columns B and C on the Parts Request tab when on Sheet 1 Column S has yes. If you look at the attachment on Sheet1 S6 is yes no I would like to see B6 the Item # populated to B15 on the Parts Request tab and then A11 (Sheet1) would be populated to C15 on the Parts Request.
Is it also possible to have this automatically populate on the Parts Request tab once "Yes" is selected (from Column s). The example has 37 items populated but the items that may require action can be less or greater.
EE-Help-Snag-2015.01.16.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Look ma, no loops:)
Seriously, you're welcome and I'm glad I was able to help.
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2014
Seriously, you're welcome and I'm glad I was able to help.
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2014
I was just thinking about your workbook and I can think of two possible problems.
1) If the user changes his mind after selecting 'yes' and changes it to 'no' or 'n/a', the data will still be in the parts request sheet.
2) To take it a step further if he does yes then no and then yes again, the information will be there twice.
Would you like the code modified to handle those situations?
1) If the user changes his mind after selecting 'yes' and changes it to 'no' or 'n/a', the data will still be in the parts request sheet.
2) To take it a step further if he does yes then no and then yes again, the information will be there twice.
Would you like the code modified to handle those situations?
ASKER
Yes, please
Since I answered your original question would you consider opening a new one?
ASKER
New question opened https://www.experts-exchange.com/questions/28599593/Update-VBA-loop.html
ASKER