| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
excel spreadsheet
there are 3 sheets in an excel spreadsheet say the names are 1,2 AND3
layouts ar ethere for all 3 sheets. the first sheet is used as input and based on certain fields , columns in the first sheet i need to populate entries in the second and 3 rd sheet. teh main purpose is taht based on the first sheet the 2 and 3 sheet should be automatically filled. wat kind of formula / macro should i be using .. im new to this and jsut know to create macro. CAn anybody help |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
excel spreadsheet
It is easy to pull values from one worksheet into another. Let's say that in
Sheet1 cell A100 we have data we want to use in Sheet3 cell Z100. In Sheet3 cell Z100 enter: =Sheet1!A100 Whenever the value in Sheet1 is changed, the value in Sheet3 will follow suite automatically. -- Gary''s Student - gsnu200763 "deepika" wrote: there are 3 sheets in an excel spreadsheet say the names are 1,2 AND3 layouts ar ethere for all 3 sheets. the first sheet is used as input and based on certain fields , columns in the first sheet i need to populate entries in the second and 3 rd sheet. teh main purpose is taht based on the first sheet the 2 and 3 sheet should be automatically filled. wat kind of formula / macro should i be using .. im new to this and jsut know to create macro. CAn anybody help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import excel spreadsheet into an excel spreadsheet | Excel Worksheet Functions | |||
| In Excel I want to copy text from spreadsheet to spreadsheet | Excel Worksheet Functions | |||
| convert ms works spreadsheet to excel spreadsheet on pda | Excel Discussion (Misc queries) | |||
| conversion of MS Works Spreadsheet to Excel 2002 Spreadsheet | Excel Discussion (Misc queries) | |||
| Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
Hybrid Mode
