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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|