I need to duplicate colums a,b,c,d,e,f,g,h,i,j,k when ever colum l is
greater then 700..
for example say:
The first customer is getting a total quantity of 800, so the final
worksheet would create two rows: The first with a quantity of 700 and a
second row with a quantity of 100.
Another example:
1: Customer,Address,City,State,Zip,1550
Becomes:
1: Customer,Address,City,State,Zip,700
2: Customer,Address,City,State,Zip,700
3: Customer,Address,City,State,Zip,150
*d,e,* *2013 FINAL DISTRO* Kendra Peters 30 Kendra Peters
120 Teresa Pfaff 400 Megan Kehl 400 Kim Veen 450 Ed
Leto 450 Katrina Topalian 450 Brooke Gould 500
Rendon
Bradford 500 Raquel Petzinger 500 Stephanie Collins
500 Erica Bair 550 Tom Deeb 550 Heather Brandt 550
Ritchie Sauceda 550 Michael Matthews 550 Robert Beavers
600 Rhiannon Ducharme 600 Harris Hummel 600 Kaitlyn
Schneider 650 Jose Cortes 650 Kurt Miller 700
Marcia
Gates 700 Melinda Boyette 700 Tracy Rios 700 Samuel
LeBron 700 Nelson Martinez Berrios 750 Donna Stoneman
750 Melissa Whitted 800 Kaitlyn DeAngelis 800 John Gracie
800 Drew Haskell 800 Steven Hartman 800 Aaron Mcneeley
800 Holly Chrisman 850 Lars Bee 850 Nick Guererri
850
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.
