| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chnaging Cell reference through macro
Let Cell B1 in your sheet2 be your "input cell";
In Cell B2 enter: =INDEX(Sheet1!$B$2:$D$5,MATCH(Sheet2!A2,Sheet1!$A$ 2:$A$5,0),MATCH(Sheet2!B$1,Sheet1!$B$1:$D$1,0)) <<watch wrapping here,, and copy down to B5. HTH "ashish128" wrote: 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
