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 |
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 |
All times are GMT +1. The time now is 08:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com