Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]() 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 | |
|
|
![]() |
||||
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 |