| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy a value from one sheet if two cells match
Good Day, I am new to macros and have a bit of knowledge on excel. I woul
like to copy a Value from a cell if two fileds on different sheets math. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy a value from one sheet if two cells match
you dont ned a macro.You could have an if statement
=if(sheet1!A1=sheet2!a1,c5,"") this says.if cell a1 on sheet1 equals cell a1 on sheet2 then show me the value from cell c5(on whatever sheet you want to be on) otherwise be blank. -- paul remove nospam for email addy! "Fuzzbucket" wrote: Good Day, I am new to macros and have a bit of knowledge on excel. I woul like to copy a Value from a cell if two fileds on different sheets math. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy a value from one sheet if two cells match
Thanks paul, I think i miss-explained myself if there is such a word. The
data on sheet two won't alaways be the same cell. So i need to look at a column, then where a match is found return c5 "paul" wrote: you dont ned a macro.You could have an if statement =if(sheet1!A1=sheet2!a1,c5,"") this says.if cell a1 on sheet1 equals cell a1 on sheet2 then show me the value from cell c5(on whatever sheet you want to be on) otherwise be blank. -- paul remove nospam for email addy! "Fuzzbucket" wrote: Good Day, I am new to macros and have a bit of knowledge on excel. I woul like to copy a Value from a cell if two fileds on different sheets math. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy a value from one sheet if two cells match
I need to do something like this as well, have you ever figured out how? "Fuzzbucket" wrote: Thanks paul, I think i miss-explained myself if there is such a word. The data on sheet two won't alaways be the same cell. So i need to look at a column, then where a match is found return c5 "paul" wrote: you dont ned a macro.You could have an if statement =if(sheet1!A1=sheet2!a1,c5,"") this says.if cell a1 on sheet1 equals cell a1 on sheet2 then show me the value from cell c5(on whatever sheet you want to be on) otherwise be blank. -- paul remove nospam for email addy! "Fuzzbucket" wrote: Good Day, I am new to macros and have a bit of knowledge on excel. I woul like to copy a Value from a cell if two fileds on different sheets math. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: copy and paste only shown not hidden cells into new sheet | Excel Discussion (Misc queries) | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Copy an additional row based on another sheet | Excel Discussion (Misc queries) | |||
| Match function...random search? | Excel Worksheet Functions | |||
| Copy sheet 1 data to sheet 2 cells. | Excel Worksheet Functions | |||
Linear Mode
