| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chnaging Cell reference through macro
Hi Everyone, I have two sheets in my excel file. First Sheet goes like
this 1/1/2006 1/2/2006 1/3/2006 Bill 10 30 50 Harry 20 40 60 Sam 30 50 70 Joshua 40 60 80 Second Sheet has formating like Day <user will give input here in form of date OR the macro will ask Bill <value of bill for that date Harry <value of Harry for that date Sam <value of Sam for that date Joshua <value of Joshua for that date Is there any formula or macro which will ask me for a date and will insert the required values in sheet 2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing Cell Reference in a macro on global base | Excel Discussion (Misc queries) | |||
| Row Expansion | Excel Worksheet Functions | |||
| Closing File Error | Excel Discussion (Misc queries) | |||
| copying cell names | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Threaded Mode
