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!

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!

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