Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 2
Default Link a column not cell by cell

I have a workbook with over 50 columns and have a report on a weekly basis
that I only need to show 7 of the columns for. I don't want to have to hide
and unhide the other columns every week. There is constantly more rows being
added to this workbook so just doing a drag on the cells will mean that I
will have to do the drag every time to catch the new rows. I would prefer to
just link the whole column but am having difficulty.

I have named the columns so I can use them as ranges (Column A is now named
DOI. (I clicked on the A column to highlight the whole thing and changed the
name in the box to the left of the fx entry.) but when I go to my new
workbook, highlight the column by clicking at the top and indicate =DOI in
the box to the left of the fx entry, it just jumps back to the old workbook.
If I put the =DOI in A1, It just copies A1.

Can someone help me out with this?
  #2   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 473
Default Link a column not cell by cell

I would suggest creating a macro to hide the unwanted columns, print
the sheet and then unhide the columns. Simpler than trying to maintain
a copy.

But if you want to make the formula version work, select the entire
column and array-enter (using Ctrl+Shift+Enter): =DOI
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
link data in a column to one cell Brian M Excel Discussion (Misc queries) 3 October 29th 08 12:18 PM
Cell Paste using cell link option Half works MardiT Excel Worksheet Functions 4 July 28th 08 06:51 PM
Can Excel 2003 cell link carry with it the source cell format? tom Excel Discussion (Misc queries) 2 July 14th 06 06:14 AM
Cell only shows link in text, not contents of reference cell Jay Mac New Users to Excel 4 August 23rd 05 08:36 PM
Using paste link infromation in cell to hyperlink to source cell? Wayne Excel Worksheet Functions 7 February 27th 05 08:38 PM


All times are GMT +1. The time now is 06:10 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"