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?