Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Updating varibales in a worksheet
I have a list of items that are done on a four week basis.
When my spreadsheet opens, it asks the user which week the items is for (1, 2, 3 or 4) via a INPUTBOX. Within each cell on the worksheet, there is a list of tasks which look similar to the following example: 1) Update MAFGHI for Week( ) 2) Print updates for Week( ) I would like to automatically insert the varible from the macro into Week( ), so that it automatically updates it to Week(4) without having to type it manually through the document. The above example would look like this, after the user has input which weeek: 1) Update MAFGHI for Week(4) 2) Print updates for Week(4) I understand how to set a cell value from a variable, but how do I update just one character from a variable within a cell that contains mutiple characters? Thanks, GLT |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic updating of a rollup worksheet when a new worksheet is a | Excel Worksheet Functions | |||
Updating links from one worksheet to another worksheet | Excel Worksheet Functions | |||
Updating different worksheet with value on current worksheet | Excel Worksheet Functions | |||
Updating 1 worksheet with result from another worksheet | Excel Discussion (Misc queries) | |||
When updating a worksheet, how do I create a link updating the sa. | Excel Worksheet Functions |