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
|