how can i link sheet1 and sheet2 of book1

  • Thread starter Thread starter exploringmacro
  • Start date Start date
E

exploringmacro

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
 
You got an answer in earlier thread "save as command in macro".
Stefi

„exploringmacro†ezt írta:
 
Back
Top