I have a tab that has 15 columns that I use for tracking purposes. One
column in particular is used for 'notes' and so it is multiple lines long.
What I'd like is for some way to have another tab be an exact copy of this
tab, but with that one column missing. The think is, I want any changes made
on the first tab to be reflected in the 2nd. One direction only, as the 2nd
tab is kind of a 'summary' or report so no editing will occur in it.

Is there a way to do this?

Thanks for any help.

this coppies columns A through X to sheet "Summary Sheet" and pasts it in
range A through X. You can modify the columns/sheet name to fit your needs.

Sub CopyWS()

Range("A:X").Copy Destination:=Sheets("Summary Sheet").Range("A:X")

End Sub



"SteveF" wrote:

> I have a tab that has 15 columns that I use for tracking purposes. One
> column in particular is used for 'notes' and so it is multiple lines long.
> What I'd like is for some way to have another tab be an exact copy of this
> tab, but with that one column missing. The think is, I want any changes made
> on the first tab to be reflected in the 2nd. One direction only, as the 2nd
> tab is kind of a 'summary' or report so no editing will occur in it.
>
> Is there a way to do this?
>
> Thanks for any help.

Nice.

Thanks for the help!



"StumpedAgain" wrote:

> this coppies columns A through X to sheet "Summary Sheet" and pasts it in
> range A through X. You can modify the columns/sheet name to fit your needs.
>
> Sub CopyWS()
>
> Range("A:X").Copy Destination:=Sheets("Summary Sheet").Range("A:X")
>
> End Sub
>
>
>
> "SteveF" wrote:
>
> > I have a tab that has 15 columns that I use for tracking purposes. One
> > column in particular is used for 'notes' and so it is multiple lines long.
> > What I'd like is for some way to have another tab be an exact copy of this
> > tab, but with that one column missing. The think is, I want any changes made
> > on the first tab to be reflected in the 2nd. One direction only, as the 2nd
> > tab is kind of a 'summary' or report so no editing will occur in it.
> >
> > Is there a way to do this?
> >
> > Thanks for any help.

This is kind of Draconian but you can do something like this:
If you are working with Sheet1 and Sheet2 and you want Sheet2 to be the
summary sheet to reflect what is on Sheet1 but not the other way then on
sheet2, Range("A1") put the following:

=Sheet1!a1

Then click and hold on the handle of the highlight and drag it across the 15
columns, then drag it down for as many rows as required. You will now have
a formula in all of the cells in that selection that will clone whatever is
entered on sheet1.

"SteveF" wrote:

> I have a tab that has 15 columns that I use for tracking purposes. One
> column in particular is used for 'notes' and so it is multiple lines long.
> What I'd like is for some way to have another tab be an exact copy of this
> tab, but with that one column missing. The think is, I want any changes made
> on the first tab to be reflected in the 2nd. One direction only, as the 2nd
> tab is kind of a 'summary' or report so no editing will occur in it.
>
> Is there a way to do this?
>
> Thanks for any help.