Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Moving data

0

Hi Can someone please answer the following:

I want to move an entire line from one worksheet to another but only when another cell on the same line shows for example dead or sold

Eg:

Sheet 1 shows

=IF(AND(N3<>""),"ACTIVE",IF(AND(P3<>"",O3=""),"SOLD",IF(AND(O3<>"",P3=""),"DEAD")))

I want the entire line which contains full details of the animal in question to be placed in another sheet only when the formula above is entered to activate which category the animal falls under rather then just the formula above

The entire line shows

Animal ID - Breed- Sex- DOB- Active- Dead- Sold- Status. The formula above relates to Status.

                             
excel
MS Office Version: 2016
posted by: johnpiriana (rep: 2) on Mon Jul 25, 2016 at 10:40 am
Answer
Discuss

Answers

0
Selected Answer

Dead or Sold, sounds so creepy lol - change to Heaven or Home :P.

Anyway, you just need to link cells. Here is a tutorial on linking cells in Excel

Basically:

  1. Go to the first cell where you want the data to "import" and type =if( 
  2. Then go to the worksheet with the data and select the cell that will say Dead or Sold and then type ="DEAD" and then type a comma.
  3. Click the cell that you want to show if that one cell equals Dead.
  4. Type a comma.
  5. type if( and then repeat the last 4 steps (go to the worksheet that has the Dead or Sold cell and then click that and type ="SOLD" and then type a comma and then select the cell that has the data that you want to show if that value equals sold.
  6. Then, type a comma and input "" so nothing will apear if the value is not Dead or Sold.

Something like this:

=IF(Sheet1!F1="DEAD",Sheet1!A1,IF(Sheet1!F1="SOLD",Sheet1!A1,""))
posted by: don (rep: 1989) on Mon Jul 25, 2016 at 2:08 pm
Discuss
0

=IF(Sheet1!F1="DEAD",Sheet1!A1

posted by: johnpiriana (rep: 2) on Thu Jul 28, 2016 at 3:33 pm
Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login