Automatic filtering and coping result to a seperate sheet
 

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,

Automatic filtering and coping result to a seperate sheet
 

You could modify the technique shown he

http://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(H20,MAX($A$1:$A1)+1,"")

On the Completed sheet, VLookup formulas return the data for the
numbered items.


Richard P wrote:
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,


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Automatic filtering and coping result to a seperate sheet
 

Thanks Debra, that works! thanks again for your help.

"Debra Dalgleish" wrote:

You could modify the technique shown he

http://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(H20,MAX($A$1:$A1)+1,"")

On the Completed sheet, VLookup formulas return the data for the
numbered items.


Richard P wrote:
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,


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html