Auto-Update - Help Plz.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all.

I have 2 excel sheets, one with information within a template, and another
in a database-method.

I would like to when saving/printing or something similar, some information
from sheet 1 would be copyed to sheet 2, BUT doing it in a search routin
basis.

For instance:

Sheet1 - B11 is value 10253

Search Sheet2 - Column A for the value in Sheet1 - B11

If "x" line in Sheet2 column A have the same value has Sheet1 - B11, then

Update Sheet2 column G line "x" and column H line "x" (line where the value
is).

Thanks in advance!
 
Back
Top