A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Link All cells of Sheet1 to All Cells of Sheet2



 
 
Thread Tools Display Modes
  #1  
Old January 10th, 2010, 07:21 AM posted to microsoft.public.excel.links
Irshad Alam
external usenet poster
 
Posts: 44
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  
Old January 10th, 2010, 09:37 AM posted to microsoft.public.excel.links
Bill Manville
external usenet poster
 
Posts: 258
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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


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


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