Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 10th 10, 06:21 AM posted to microsoft.public.excel.links
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2010
Posts: 6
Default Link All cells of Sheet1 to All Cells of Sheet2

I am using Excel 2000

I have data on sheet1, more than 300 rows and about 9 columns.

As per requirement that I want link the sheet1 all the cells to sheet2 all
the cells, because on the sheet2, the autofilter option will be used by user
to view sorted data.

I tried to copy all cell and paste link, but it produces error. I know to
link sheet1 cells indiviually to sheet2 cells, but when the rows are
added/more data posted, it does will not update the another sheet.

Please advice me a solution, so that I can link one sheet to another sheet
on complete basis, so that if the data changes, it will update another sheet.
Or if row/ column added, it should automatically add on the other sheet also.

Thanking you all in advance.

Regards
Irshad




  #2   Report Post  
Old January 10th 10, 08:37 AM posted to microsoft.public.excel.links
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 473
Default Link All cells of Sheet1 to All Cells of Sheet2

In my opinion there is no good way to achieve what you are asking.

I suggest you consider the following options:
- 1) don't keep a separate sheet showing all the data; just remove the
filter from the filtered sheet when you want to see all the data
or 2) use a macro to copy Sheet2's contents to Sheet1 when you activate
Sheet1 or when you change Sheet2, whichever is the less frequent
occurrence
or 3) [which I don't like] use a formula on Sheet1:
=IF(ISBLANK(Sheet2!A1),"",Sheet2!A1)
copied across as many columns as will be needed and down as many rows
as will be needed.



Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup



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
Populate growing range of cells from Sheet1 to Sheet2 Brad New Users to Excel 10 July 23rd 09 08:32 AM
copy data from sheet2 to sheet1 when sheet2 has variable # of rows Anne Excel Discussion (Misc queries) 6 February 27th 09 09:48 PM
how can i link sheet1 and sheet2 of book1 exploringmacro Excel Discussion (Misc queries) 1 February 20th 09 01:02 PM
[=Sheet1!A1] - if i use Column A1 ('Sheet1') / A2 ('Sheet2') Lawrence C H Tan Excel Worksheet Functions 0 January 19th 07 08:29 PM
Checking the Cells in Sheet1 with Cells in Sheet2 and replace Checking the cells in Sheet1 with Sheet2 Excel Worksheet Functions 1 August 19th 06 09:29 AM


All times are GMT +1. The time now is 06:52 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017