copy data from 1 cell to another.

M

Mike Reed

I am looking to copy data from one cell to another depending on another cell.

Basically like this

a b c d
1 name1 item1 status1 type1
2 name2 item2 status2 type2

So if in cell g4 which is the same type as a1, has the same name, like name1, then copy cell c1 to i4.

Hopefully that makes sense. Thanks
 
M

Mike Reed

I should have mentioned that I am hoping that you can specify a range of cells to look at. Like A1:A200, and if there is a match, then copy the corresponding C# to G#.

Thanks
 
S

Spiky

Glad you added this, because that is completely different. First, you
shouldn't think of it as "copying" the data. If you use formulas, you
are asking Excel to calculate or lookup something else. Copying is
something YOU do, probably with the mouse.

Question:
Can the Name1 be repeated in column A, or is there only ever one
instance of each name?
 

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

Automatically sending multiple parts of text from one word doc to another - is possible. 0
Find a number in a column then return a value from another cell 2
Sum Values from different column 1
Copy 2 cells to 1 cell 1
Receive data in column with pull down 2
select max value from row of data and column containing max value 2
Macro to copy data X number of times into a column 0
Copy entire row from another sheet onto first sheet if a unique text matches 1

Top