| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selected Sheet will update cell.
Dear All,
I need help to write a code that can do this: Sheet 1 Sheet 2 Sheet 3 - Central IF sheet 1 is selected, then Sheet 3!A1 will equal to Sheet1!G1. IF sheet 2 is selected, then Sheet 3!A1 will change and equal to Sheet2! H1. .... and the process will continue, sheet 1 or sheet 2. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I sort Excel sheet by the color of the fill in selected cell | Excel Worksheet Functions | |||
| Specific cell selected when sheet opens...how??? | Excel Discussion (Misc queries) | |||
| print only selected cell contents without loosing spread sheet for | Excel Discussion (Misc queries) | |||
| how do i make it so that when a sheat is selected either via link or tab, that xlLastCell is selected. the last on the sheet. | Excel Worksheet Functions | |||
| Update forumla in same cell on each sheet | Excel Discussion (Misc queries) | |||
Threaded Mode
