Auto-Update - Help Plz.
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!
|