Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to write value
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to write value
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Write to csv | Excel Discussion (Misc queries) | |||
How do I write X^2? | New Users to Excel | |||
How do you write a T with a bar on it? | Excel Discussion (Misc queries) | |||
is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
How to I write a UDF? | Excel Discussion (Misc queries) |