If Qty is 1 copy cell and adjust Qty in Mac Excel 2011

Microsoft Excel for mac 2011 - macintosh
January 23, 2015 at 05:12:49
Specs: Macintosh OSX 10.10.1
I have a spreadsheet starting at A1. I just copy and paste the data into the spreadsheet but I have to copy and paste and adjust the Qty on anything over the Qty of 1 so I would like to find a way to have excel automate this step.
I need excel to copy and paste the row to equal the Qty amount. If Qty is 0, do nothing. The first example is how it is now - the second example is what I want Mac Excel 2011 to do.
Thank you, Deb

Item Qty Product Price
27 1 PHOTO PAPER 2.01
30 1 Markers 1.00
31 1 Led Sign 1.00
113 4 Oil Lamps 1.00
114 1 DVD 1.00

Item Qty Product Price
27 1 PHOTO PAPER 2.01
30 1 Markers 1.00
31 1 Led Sign 1.00
113 1 Oil Lamps 1.00
113 1 Oil Lamps 1.00
113 1 Oil Lamps 1.00
113 1 Oil Lamps 1.00
114 1 DVD 1.00


See More: If Qty is 1 copy cell and adjust Qty in Mac Excel 2011

Report •


#1
January 27, 2015 at 08:20:55
The easiest way to accomplish what you want is with a Macro,
unfortunately my Macro skills are just above nil.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question