Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to set up an excel formula to copy cells to another worksheet?
I need to know how to set up formula that If a conditional formula is true,
then it will copy certain required data into a new worksheet in the same workbook in a certain order. Is this even possible? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to set up an excel formula to copy cells to another worksheet?
Hi SLN,
It seems to me a formula will not handle all your constraints ... A macro will be the solution ... Carim |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to set up an excel formula to copy cells to another worksheet?
A formula can only PULL data into the cells that the formula itself resides
in. It cannot PUSH data into another cell, so if you want to get data from A to B, then B needs to contain a formula along with copnditional logic, such that when the conditions are satisfied, it will pull the values from A. If you give us more details then we may be able to help you set this up correctly such that you don't need code, but we do need details. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------- It's easier to beg forgiveness than ask permission :-) "SLN" wrote: I need to know how to set up formula that If a conditional formula is true, then it will copy certain required data into a new worksheet in the same workbook in a certain order. Is this even possible? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to set up an excel formula to copy cells to another worksh
That makes sense.
For example, I have a cell that contains a conditional formula. If cell A is greater than cell B, this is bad or an "Oops" as we call it. I then copy certain pieces of the info in that worksheet to another worksheet so we can have all of the different "oops" cells in a list. Does this make any sense? "Ken Wright" wrote: A formula can only PULL data into the cells that the formula itself resides in. It cannot PUSH data into another cell, so if you want to get data from A to B, then B needs to contain a formula along with copnditional logic, such that when the conditions are satisfied, it will pull the values from A. If you give us more details then we may be able to help you set this up correctly such that you don't need code, but we do need details. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------- It's easier to beg forgiveness than ask permission :-) "SLN" wrote: I need to know how to set up formula that If a conditional formula is true, then it will copy certain required data into a new worksheet in the same workbook in a certain order. Is this even possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cells referenced in formula bar not highlighted in worksheet | Excel Discussion (Misc queries) | |||
Prevent changing size when copy&paste into another Excel Worksheet | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
how Excel can copy the data in a row of worksheet to other? | Excel Worksheet Functions | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel |