View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dash[_3_] Dash[_3_] is offline
external usenet poster
 
Posts: 2
Default 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!