Create new record if >0

[thart21]

I have a workbook that contains the following columns - Ordered_Qty and Not_Ordered_Qty. I need to write some VBA that, if both Ordered_Qty and Not_Ordered_Qty" are >0, create a new record on the same worksheet and move that qty into the new record in the same field, replacing the previous value in the original record with 0. I'm using Excel 2007.

I've only been able to find VBA samples for parsing out comma separated values in the same column.

Row ETA_Date Ordered_Qty Not_Ordered_Qty
1 4/15/2011 145 0
2 5/16/2011 25 56
3 4/15/2011 75 114

Need it to be:

Row ETA_Date Ordered_Qty Not_Ordered_Qty
1 4/15/2011 145 0
2 5/16/2011 25 0
3 0/00/0000 56
4 4/15/2011 75 0
5 0/00/0000 114

The idea is that they don't want to see an ETA Date for something that hasn't even been ordered yet.

I will try to modify one of the other modules I found pertaining to parsing out comma separated fields in the meantime, thanks for any help.

Toni

 

[Glory]

Split method? Or are values separated by spaces in separate columns?

Edit: The forum scrapped your formatting, didn't it? You can paste excel tables directly across if you want to.

 

[thart21]

Yes, my formatting got messed up. Not sure if "split" is the correct word, I just need an extra record created below the original to move that Not_Ordered_Qty to.

I'll repost in a few. Thanks for the reply

 

[thart21]

Excel Workbook
	A	B	C
1	ETA Date	Ordered Qty	Not Ordered Qty
2	4/15/2011	145	0
3	5/16/2011	25	56
4	4/15/2011	75	114
5
6	To go to:
7	ETA Date	Ordered Qty	Not Ordered Qty
8	4/15/2011	145	0
9	5/16/2011	25	0
10	0/00/0000	0	56
11	4/15/2011	75	0
12	0/00/0000	0	114
Sheet1

Excel 2007