s

n Sheet 1 - I have this Data:

Alex 20

Derek 30

Lisa 25

Kobe 60

In Sheet 2 I have these 3 columns:

10-30, 30-50, 50-70

I want to extract data from Sheet 1 and place in Sheet 2 under the category they belong in

So in Sheet 2, under 10-30, I want it to list Alex and Lisa, Under 30-50 I want it list Derek and under 50-70 I want it to list Kobe. How do I extract data from Sheet 1 and place in Sheet 2 under the category where it belongs?

Does anyone have any idea on what I am doing wrong with this code:

Sub movedata()

    Dim i As Long

    Dim LastRow As Long

    LastRow = Range("B" & Rows.Count).End(xlUp).Row

    For i = 1 To LastRow

        If Worksheets("Sheet1").Cells(i, i).Value >= 10 And Worksheets("Sheet1").Cells(i, i).Value <= 30 Then

        Worksheets("Sheet2").Range("A2") = Worksheets("Sheet1").Cells(i, i).Offset(-1, 0)

        ElseIf Worksheets("Sheet1").Cells(i, i).Value >= 30 And Worksheets("Sheet1").Cells(i, i).Value <= 50 Then

            Worksheets("Sheet2").Range("B2") = Worksheets("Sheet1").Cells(i, i).Offset(-1, 0)

        Else

          Worksheets("Sheet2").Range("C2") = Worksheets("Sheet1").Cells(i, i).Offset(-1, 0)

          Worksheets("Sheet2").Range("C2") = Worksheets("Sheet1").Cells(i, i).Offset(-1, 0)

End If

Next i

End Sub

In Sheet 1 - I have this Data:

Alex 20

Derek 30

Lisa 25

Kobe 60

In Sheet 2 I have these 3 columns:

10-30, 30-50, 50-70

I want to extract data from Sheet 1 and place in Sheet 2 under the category they belong in

So in Sheet 2, under 10-30, I want it to list Alex and Lisa, Under 30-50 I want it list Derek and under 50-70 I want it to list Kobe. How do I extract data from Sheet 1 and place in Sheet 2 under the category where it belongs?

Does anyone have any idea on what I am doing wrong with this code:

Sub movedata()

    Dim i As Long

    Dim LastRow As Long

    LastRow = Range("B" & Rows.Count).End(xlUp).Row

    For i = 1 To LastRow

        If Worksheets("Sheet1").Cells(i, i).Value >= 10 And Worksheets("Sheet1").Cells(i, i).Value <= 30 Then

        Worksheets("Sheet2").Range("A2") = Worksheets("Sheet1").Cells(i, i).Offset(-1, 0)

        ElseIf Worksheets("Sheet1").Cells(i, i).Value >= 30 And Worksheets("Sheet1").Cells(i, i).Value <= 50 Then

            Worksheets("Sheet2").Range("B2") = Worksheets("Sheet1").Cells(i, i).Offset(-1, 0)

        Else

          Worksheets("Sheet2").Range("C2") = Worksheets("Sheet1").Cells(i, i).Offset(-1, 0)

          Worksheets("Sheet2").Range("C2") = Worksheets("Sheet1").Cells(i, i).Offset(-1, 0)

End If

Next i

End Sub

Why are only certain medications such as Digoxin or Vancomycin and other antibiotics weight based while others are not. Also Why is Ideal Body Weight used in a patient to determine dosing, why is their actual real weight not used. And in obese patients, why is the adjusted body weight used and not their real weight or IBW? How does extra fat affect the drug anyways in the body. I have tried to research these topics but unable to come up with a clear answer. Thanks

I had a question that I am unable to comprehend on Blood Pressure Regulation that I hope you could answer. When patients are in shock such as sepsis shock, they are give vasopressin. So from my research, it causes PERIPHERAL VASOCONSTRICTION. So according to the lecture, that will move unstressed volume to stressed volume. But a person who is in shock needs more blood to important organs such as heart, and brain, correct ? so then would drugs such as vasopressin and epinephrine cause Coronary Artery DILATION to get more blood to those areas. But then I think, if it causes coronary artery dilation, then that would make it easy for blood to flow arteriole side to venous side to unstressed volume, which will not supply blood to the heart more or vital organs and that will decrease BP even more. I am just confused on what exactly is happening when drugs such as vasopressin, norepeniphrine, epinephrine are given, is more blood going to heart and being taken away from skin and other peripheral parts and which arteries are constricting to increase the BP ? Thank You.

I am confused on neurotransmitter signaling. what does the excitatory postsynaptic potential mean? It says it meet thresold, is there one neuron on the postsyanaptic or there are millions of neurons? It said one postsynapticneuron can receive signals from thousands of presynaptic neurons, so does that mean one postsynaptic neuron can have multiple receptors for same thing or are are different neurotransmitters coming in all at one time?

I dont understand, please explain, is there one neuron or millions of neurons on postynaptic side?

Is a neurotransmitter always have to be released for something to happen such as move a muscle. Or can a spinal cord communicate through nerve impulses, which leads to my question What is the difference between the two? Can someone please clear this up for me and give me an example. When is a neurotransmitter released?

What are human body cavities? It says fluid filled space and what fluid does it have, and what does it contain? And then membranes surround body cavities, how do epithelial tissues play into that? I am just trying to understand relationship between them, Can someone please explain this to me in simple terms? Thank you.

]hi guys,

so this not hw or anything. i am just trying to understand the information and am confused in these two problems.

1. for this problem , picture below. When you draw short circuit between a and b, the teacher solved for vs which was 20, and then he said short circuit was 20/4 = 5? How is this current the same as current flowing from a to b? And the equivalent resistance is only 5, why is the 5 shorted out?

Q1: http://www.flickr.com/photos/60320275@N02/55045973...

2. For this problem, I have no idea where to start. It is an example in the book and answer is given The question is to find thevenin and norton equivalent?? Can someone please show me how to do it?

Q2: http://www.flickr.com/photos/60320275@N02/55040098...

Please I need to understand this, thank you for your help.

hi guys,

so this not hw or anything. i am just trying to understand the information and am confused in these two problems.

1. for this problem , picture below. When you draw short circuit between a and b, the teacher solved for vs which was 20, and then he said short circuit was 20/4 = 5? How is this current the same as current flowing from a to b?

Q1: http://www.flickr.com/photos/60320275@N02/55045973...

2. For this problem, I have no idea where to start. It is an example in the book and answer is given The question is to find thevenin and norton equivalent?? Can someone please show me how to do it?

Q2: http://www.flickr.com/photos/60320275@N02/55040098...

Please I need to understand this, thank you for your help.

hi guys,

so this not hw or anything. i am just trying to understand the information and am confused in these two problems.

1. for this problem , picture below. When you draw short circuit between a and b, the teacher solved for vs which was 20, and then he said short circuit was 20/4 = 5? How is this current the same as current flowing from a to b?

https://mail.google.com/mail/?ui=2&ik=128ff68a0e&v...

2. For this problem, I have no idea where to start. It is an example in the book and answer is given The question is to find thevenin and norton equivalent?? Can someone please show me how to do it?

https://mail.google.com/mail/?ui=2&ik=128ff68a0e&v...

Please help me to understand, thank you.

Hi I am a senior in college and this my last semester. I have always had an interest in health field but I did not want to major in just chemistry or biology. So I chose Industrial Engineering, and hopefully will graduate this year with an Engineering degree. But I also took pre-requisites for pharmacy school. I have already applied to pharmacy schools and have gotten accepted into 3 schools. I currently also work in a pharmacy. Now I am kind of stuck in thinking whether Pharmacy will have a bright future since so many schools are opening and the prediction that there will be less jobs for pharmacists, as well as their salaries will decrease significantly. Do you think that I should try to find an engineering job or go on to Pharmacy School? Which field do you think holds a brighter future?

How to solve for n in the following question?

how do you solve for n in this ?

(130)*(0.07)^n = (100) * (0.08637)^n

Can someone show step by step please?

its suppose to be 1.249, how do you get that?

how do you solve for n in this ?

(130)*(0.07)^n = (100) * (0.08637)^n

Can someone show step by step please?

I have read the definitions but I still don't understand. For ex. how is a steam expanding in a turbine steady flow? If something is closed on one side, and gas is in there, is that unsteady flow, Basically, HOW DO YOU TELL. PLEASE GIVE EXAMPLES

A. NaAlCl4

B. NH3

C. HF

D. BF3

Why is the answer given as D?

I though Lewis acid is an electron acceptor, HF is a good acid it will accept the electrons from whoever is going to take its H (proton). The explanation says lewis acids are electron pair acceptors that usually contain either B or Al with 3 bonds. WHAT??? I dont understand that how would that make that an acid, that would make it a base if they have lone pairs

Find the limit as x approaches 1 of x^3-x^2 / (1-x^3)

I cant figure how to simplify this? apparently the answer is -1/3 can someone please write step by step? thanks

How to convert 1.005 KJ/Kg*Celsius to

KJ/Kg*Kelvin

J/g*Celsius,

Kcal/Kg*Celsius

Btu/lbm*Fahreneight ?

A. C4H11N

B. C4H9NO

C. C4H7F3

D. C4H8O2

apparently the answers is C, I do not understand why at all because i thought hydrogen bonding could occur between Hydrogen- Fluorine, Nitrogen, or Oxygen? there is fluorine in C, also why not H-CL-- why is that not hydrogen bonding?

A. C4H11N

B. C4H9NO

C. C4H7F3

D. C4H8O2

apparently the answers is C, I do not understand why at all because i thought hydrogen bonding could occur between Hydrogen- Fluorine, Nitrogen, or Oxygen? there is fluorine in C, also why not H-CL-- why is that not hydrogen bonding?

1. At what points do y=square root of (2x) and X^2+Y^2 = 8 intersect? please explain how to do questions like this in general

2. For what values is the graph concave down in y= -x^2+2x+1?

Apparently, the answer is for all values because 2nd derivative is -2 which is less than 0. But IF THE SECOND DERIVATIVE WAS like lets say -2x then how would you find which values CAN you give an example and explain this? thanks