Hi Sarah

Two suggestions.
1. Just hide columns D,F,G,H before letting others see your worksheet

2. Hold down Control as you click on the sheet tab and drag to the right.
This will create a copy of your worksheet.
Delete columns D,F,G,H.

Next time, delete this Worksheet and repeat procedure to create copy of main
worksheet with your changes.
This can be recorded as a macro to automate the process.

Alternatively, for making the copy, right click sheet tabMove or
CopyCreate CopyChoose new Workbook

--
Regards
Roger Govier

"Sarah" wrote in message
...
Thanks for the help Steve. It's just that I have over 1000 rows x 4
columns
of data, which is constantly being added to and ammended, was hoping to
avoid
having a formula in each cell. Appreciate the help.
--
Regards,
Sarah
BB


"AltaEgo" wrote:

I take it you tried:

Click in a cell is the sheet to be updated
Press =
Navigate to the data sheet
Click a cell and press [Enter]

If this is not working for you, try the following formula:

=INDIRECT("Sheet1!" & ADDRESS(ROW(),COLUMN()))

Modify Sheet1 to the name of the sheet you wish to obtain values from.

Drag or copy/paste the formula to all required cells.

--
Steve

"Sarah" wrote in message
...
Hi,
I have a main worksheet, columns A to H (8 columns), about 1000 rows
and
growing. I insert rows and change data regularly and I want to update
another worksheet, which has only columns A to C plus E (4 columns, as
some
of the other info is not for everybody to see). Would a macro work?
Would
this be easy, or is there something else that would be better? Thanks.
--
Regards,
BB