Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 20th 09, 12:33 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2009
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  
Old February 20th 09, 01:02 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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 08: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 09:46 PM


All times are GMT +1. The time now is 12:21 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017