Prev: How to use the "shell" command?
Next: Excel Spreadsheets formulas don't update
From: GEdwards on 20 Apr 2010 21:49
I am using Excel 2003.

Worksheet1 contains columns
(A) Invoice
(B) Name
(C) Address
(D) P.O.# ... and others.

I need to perform a search of column A using an invoice number and if it IS
FOUND, then replace the entire row with new data.

If the invoice number IS NOT FOUND, then I need to add a new row.

Is there a simple way to do this?
From: Jacob Skaria on 21 Apr 2010 03:20
Check your other post..



"GEdwards" wrote:

> I am using Excel 2003.
>
> Worksheet1 contains columns
> (A) Invoice
> (B) Name
> (C) Address
> (D) P.O.# ... and others.
>
> I need to perform a search of column A using an invoice number and if it IS
> FOUND, then replace the entire row with new data.
>
> If the invoice number IS NOT FOUND, then I need to add a new row.
>
> Is there a simple way to do this?
 | 
Pages: 1
Prev: How to use the "shell" command?
Next: Excel Spreadsheets formulas don't update