how can i link sheet1 and sheet2 of book1

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
 
S

Stefi

You got an answer in earlier thread "save as command in macro".
Stefi

„exploringmacro†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
macro for calculate and compare 0
Search and Link across worksheets 2
how can I copy/paste a formula that skips 27 rows? 0
Automatic populate Sheet2 with data from Sheet1 based on criteria. 2
Matching Rows with Multiple Columns in Two Worksheets 0
Match Copy/Paste Macro almost there 0
How to use vlookup in an array formula 2

Top