Alright, I am not sure if I should be utilizing a macro, a formula or what.
Here is my situation. I work in an office that is consistantly using excel.
Commonly I need to copy data from sheet1 and paste to sheet2. Here's the
kicker--what is on row 1 in sheet1 may be on row 999 on sheet2. I am looking
for a way to save me tons of time. What I would like to be able to do is
create a formula/macro that allows me to copy data from sheet1 and paste to
sheet2 using a common identifier that exists in a row. Therefore, the data
lines up where appropriate without me having to copy and paste.

I know there must be a way to do this. I need very 'dumbed' down directions
if somebody is willing to adopt this task. I will be watching for any
activity. Thank you

Okay lets say Sheet1 is set up like the following
A1 = Name
A2 = Bill
A3 = Ryan
B1 = Number
B2 = 1
B3 = 2
Lets Say Sheet 2 is set up like the following.
A100 = Name
A101 = Bill
A102 = Ryan
B100 = Number
To get the values from Sheet1 into the appropriate cells in Sheet2 type the
following formula into cells B101 of Sheet2.
=VLOOKUP(B101,Sheet1!$A$2:$B$3,2,FALSE)
Then copy the formla down into cell B102. It should like the following
=VLOOKUP(B102,Sheet1!$A$2:$B$3,2,FALSE)

This should pull the correct value from Sheet1.

Hope this helps.

Bill Horton

"RyanFC" wrote:

Alright, I am not sure if I should be utilizing a macro, a formula or what.
Here is my situation. I work in an office that is consistantly using excel.
Commonly I need to copy data from sheet1 and paste to sheet2. Here's the
kicker--what is on row 1 in sheet1 may be on row 999 on sheet2. I am looking
for a way to save me tons of time. What I would like to be able to do is
create a formula/macro that allows me to copy data from sheet1 and paste to
sheet2 using a common identifier that exists in a row. Therefore, the data
lines up where appropriate without me having to copy and paste.

I know there must be a way to do this. I need very 'dumbed' down directions
if somebody is willing to adopt this task. I will be watching for any
activity. Thank you

The formula seems good on paper but when plugged into the appropriate cell,
Excel states there is a circular reference. Is there a chance that the
formula is incorrect?

"William Horton" wrote:

Okay lets say Sheet1 is set up like the following
A1 = Name
A2 = Bill
A3 = Ryan
B1 = Number
B2 = 1
B3 = 2
Lets Say Sheet 2 is set up like the following.
A100 = Name
A101 = Bill
A102 = Ryan
B100 = Number
To get the values from Sheet1 into the appropriate cells in Sheet2 type the
following formula into cells B101 of Sheet2.
=VLOOKUP(B101,Sheet1!$A$2:$B$3,2,FALSE)
Then copy the formla down into cell B102. It should like the following
=VLOOKUP(B102,Sheet1!$A$2:$B$3,2,FALSE)

This should pull the correct value from Sheet1.

Hope this helps.

Bill Horton

"RyanFC" wrote:

Alright, I am not sure if I should be utilizing a macro, a formula or what.
Here is my situation. I work in an office that is consistantly using excel.
Commonly I need to copy data from sheet1 and paste to sheet2. Here's the
kicker--what is on row 1 in sheet1 may be on row 999 on sheet2. I am looking
for a way to save me tons of time. What I would like to be able to do is
create a formula/macro that allows me to copy data from sheet1 and paste to
sheet2 using a common identifier that exists in a row. Therefore, the data
lines up where appropriate without me having to copy and paste.

I know there must be a way to do this. I need very 'dumbed' down directions
if somebody is willing to adopt this task. I will be watching for any
activity. Thank you

It worked on my machine. Ensure that you are putting the formulas in Sheet2
since they are referencing Sheet1. If you put them in Sheet1 by mistake you
will get a circular reference because they are looking at themselves for
values.

"RyanFC" wrote:

The formula seems good on paper but when plugged into the appropriate cell,
Excel states there is a circular reference. Is there a chance that the
formula is incorrect?

"William Horton" wrote:

Okay lets say Sheet1 is set up like the following
A1 = Name
A2 = Bill
A3 = Ryan
B1 = Number
B2 = 1
B3 = 2
Lets Say Sheet 2 is set up like the following.
A100 = Name
A101 = Bill
A102 = Ryan
B100 = Number
To get the values from Sheet1 into the appropriate cells in Sheet2 type the
following formula into cells B101 of Sheet2.
=VLOOKUP(B101,Sheet1!$A$2:$B$3,2,FALSE)
Then copy the formla down into cell B102. It should like the following
=VLOOKUP(B102,Sheet1!$A$2:$B$3,2,FALSE)

This should pull the correct value from Sheet1.

Hope this helps.

Bill Horton

"RyanFC" wrote:

Alright, I am not sure if I should be utilizing a macro, a formula or what.
Here is my situation. I work in an office that is consistantly using excel.
Commonly I need to copy data from sheet1 and paste to sheet2. Here's the
kicker--what is on row 1 in sheet1 may be on row 999 on sheet2. I am looking
for a way to save me tons of time. What I would like to be able to do is
create a formula/macro that allows me to copy data from sheet1 and paste to
sheet2 using a common identifier that exists in a row. Therefore, the data
lines up where appropriate without me having to copy and paste.

I know there must be a way to do this. I need very 'dumbed' down directions
if somebody is willing to adopt this task. I will be watching for any
activity. Thank you