How to set up an excel formula to copy cells to another worksheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Hi SLN,

It seems to me a formula will not handle all your constraints ...
A macro will be the solution ...

Carim
 
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.
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel VBA 1
Excel Highlighting duplicates 0
Copy formula from one worksheet to another to get value in 2nd wks 1
Automatic Cell Copy to other worksheets 1
Worksheet formula incorrect after copying to another worksheet 2
Worksheet relative reference 3
How to copy & paste a worksheet but change 1 bit of the formula? 1

Back
Top