|
|
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?
|
|
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
|
|
|