Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,646
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2!A1+ Dany Excel Discussion (Misc queries) 5 April 16th 07 03:27 AM
[=Sheet1!A1] - if i use Column A1 ('Sheet1') / A2 ('Sheet2') Lawrence C H Tan Excel Worksheet Functions 0 January 19th 07 09:29 PM
How to reference C5, D5, E5 from sheet2 in A1, A2, A3 of sheet1? Mark Excel Worksheet Functions 1 October 11th 06 09:46 AM
Referencing sheet1 from sheet2 Les Excel Worksheet Functions 5 April 20th 06 12:32 PM
Moving from 1 row sheet1 to sheet2 tomc112 Excel Worksheet Functions 5 November 24th 04 10:46 PM


All times are GMT +1. The time now is 02:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"