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!

Auto-Update - Help Plz.
 

A little help plz... :S





"Dash" wrote:

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!

Auto-Update - Help Plz.
 

Maybe looking at Debra Dalgleish's site will offer some suggestions:

http://contextures.com/xlForm03.html
http://contextures.com/xlForm02.html

Dash wrote:

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!

--

Dave Peterson