From: vincent on
Dear Sir/Madam

i want to write entire row value while typing value in general sheet. in
the general sheet i have three column name, id, and location. and i have
three other sheet London, Newyork, Seattle. while i am entering value in
general sheet like name id and location, if the location cell value is same
as in the other sheet name london or newyork or seatlle, it should write the
value in specific sheet if London it should write the value in London sheet
Ryan 1811

is it possible in excel

help me


thanks and regards
vincent
From: Gary Keramidas on
yes, select all of the relevant sheets, for example, click the sheet1 tab,
hold the shift key and click the sheet3 tab.
now go to the cell and enter the value you want.

it will appear in all 3 sheets.

--


Gary Keramidas
Excel 2003


"vincent" <vincent(a)discussions.microsoft.com> wrote in message
news:87526CDD-BE0D-455B-B7CC-6962FEEFC7BF(a)microsoft.com...
> Dear Sir/Madam
>
> i want to write entire row value while typing value in general sheet. in
> the general sheet i have three column name, id, and location. and i have
> three other sheet London, Newyork, Seattle. while i am entering value in
> general sheet like name id and location, if the location cell value is
> same
> as in the other sheet name london or newyork or seatlle, it should write
> the
> value in specific sheet if London it should write the value in London
> sheet
> Ryan 1811
>
> is it possible in excel
>
> help me
>
>
> thanks and regards
> vincent