Solarguy here. In Excel 2010 [not 2003] I have created a very long master list of inventory items over the years in Excel. Columns list name, quantity, marked up cost, my cost, part number and price. This worksheet totals all prices, figures in sales tax, labor, travel fee and other items and moves those totals to another worksheet in a printable format.
Now I want to take from the master list only items from those rows that display a number in the "Qty" column and move most of the data to yet another wworksheet to create a purchase order. I only want the specific column item from rows with a quantity entered and not, for instance, my cost.
I suspect that the formula will include "concatenate" and "IF" but playing around with the formulas has not worked even close.
Any help provided would be appreciated.
Bookmarks