Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i link sheet1 and sheet2 of book1
Hi, I have 2 worksheet (sheet1 and sheet2), on my sheet1 i have 4 columns
(code,description,finding,remarks), on FINDINGS there is a specific answer of Y or N, then on my sheet2, i have 3 columns (code, description, remarks) the value of the 3 columns is actually from the sheet1. I want something like this, If column FINDING on sheet1 is Y then all the rows that have that value will automatically show in sheet2 column CODE, DESCRIPTION and remark. Do you think its possible? Please help. thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i link sheet1 and sheet2 of book1
You got an answer in earlier thread "save as command in macro".
Stefi €žexploringmacro€ť ezt Ă*rta: Hi, I have 2 worksheet (sheet1 and sheet2), on my sheet1 i have 4 columns (code,description,finding,remarks), on FINDINGS there is a specific answer of Y or N, then on my sheet2, i have 3 columns (code, description, remarks) the value of the 3 columns is actually from the sheet1. I want something like this, If column FINDING on sheet1 is Y then all the rows that have that value will automatically show in sheet2 column CODE, DESCRIPTION and remark. Do you think its possible? Please help. thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2!A1+ | Excel Discussion (Misc queries) | |||
[=Sheet1!A1] - if i use Column A1 ('Sheet1') / A2 ('Sheet2') | Excel Worksheet Functions | |||
How to reference C5, D5, E5 from sheet2 in A1, A2, A3 of sheet1? | Excel Worksheet Functions | |||
Referencing sheet1 from sheet2 | Excel Worksheet Functions | |||
Moving from 1 row sheet1 to sheet2 | Excel Worksheet Functions |