Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas
ok I have info. on sheet 2 that I want to insert into sheet 1. Therefore
formula would look like this. I hate to use the IF word, but.. How do I transpose the info. from cell D3 Sheet 2, into D3 sheet 1,and if D3 sheet 2 is selected then data in F3 and F4 sheet 2 is automatically transposed into F4 and F5 on sheet 1 In other words if (cell D3 sheet 2) is selected the the data would be entered onto (sheet 1 cell D3) and the coresponding data in F3 and F4 would folow to sheet 1 F4 F5. -- not old enough! only 57 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |