Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strange conditional copying of spread sheet??
Dear all. I have written a conditional to formula which copies a work sheet
(cell by cell) based on which work sheet is currently selected in a drop down menu in another work sheet (plan). Either data from work sheet st1, st2 or st3 is copied into the cell. =IF(LOOKUP(TODAY(),plan!$B$2:$G$2,plan!$B$3:$G$3)= "st1",st1!A1:C10,IF(LOOKUP(TODAY(),plan!$B$2:$G$2, plan!$B$3:$G$3)="st2",st2!A1:C10,IF(LOOKUP(TODAY() ,plan!$B$2:$G$2,plan!$B$3:$G$3)="st3",st3!A1:C10," "))) This code works, however you may notice that the cell reference to copy to the single cell is a range of 9 cells if the conditional function 'IF' is satisfied. I am a bit confused since it is some time since i wrote this code and did not notice. Now when I try to change the [value if true] from any of the IF functions to a single cell instead of a rang eof nine cells it does not work.... Does anyone have an idea what I may have done?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying spread sheet | Excel Discussion (Misc queries) | |||
Copying conditional formatting to entire sheet | Excel Discussion (Misc queries) | |||
Conditional Formatting Precidence when copying to new sheet in 200 | Excel Discussion (Misc queries) | |||
how do i enter a bull call spread into the options spread sheet ? | Excel Worksheet Functions | |||
Strange request Automaticaly send spread sheet as an e-mail | Excel Programming |