software

Need some help with this,,
I am creating an estimation template wher I have a parts list in one sheet.
If I go to that sheet and enter 1 or grater in the qty colum, automatically
that row is presented in another sheet as my Invoice etc..
Any help, thanks in advance,

You could modify the technique shown he

www.contextures.com/excelfiles.html

Under Functions, look for 'Dynamic List'

Instead of Status in column H, enter the quantity. Then, modify the
formula in column A:

=IF(H2gt;0,MAX($A$1:$A1) 1,quot;quot;)

On the Completed sheet, VLookup formulas return the data for the
numbered items.Richard P wrote:
gt; Need some help with this,,
gt; I am creating an estimation template wher I have a parts list in one sheet.
gt; If I go to that sheet and enter 1 or grater in the qty colum, automatically
gt; that row is presented in another sheet as my Invoice etc..
gt; Any help, thanks in advance,--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.htmlThanks Debra, that works! thanks again for your help.

quot;Debra Dalgleishquot; wrote:

gt; You could modify the technique shown he
gt;
gt; www.contextures.com/excelfiles.html
gt;
gt; Under Functions, look for 'Dynamic List'
gt;
gt; Instead of Status in column H, enter the quantity. Then, modify the
gt; formula in column A:
gt;
gt; =IF(H2gt;0,MAX($A$1:$A1) 1,quot;quot;)
gt;
gt; On the Completed sheet, VLookup formulas return the data for the
gt; numbered items.
gt;
gt;
gt; Richard P wrote:
gt; gt; Need some help with this,,
gt; gt; I am creating an estimation template wher I have a parts list in one sheet.
gt; gt; If I go to that sheet and enter 1 or grater in the qty colum, automatically
gt; gt; that row is presented in another sheet as my Invoice etc..
gt; gt; Any help, thanks in advance,
gt;
gt;
gt; --
gt; Debra Dalgleish
gt; Contextures
gt; www.contextures.com/tiptech.html
gt;
gt;