copy entire contents worksheet into new workbook, link but editabl

E

ellyk

I need to copy the entire contents of a worksheet which is used by several
collegues who need to see it looking the same always (headers in the same
order,etc). In the new worksheet (workbook) I will rearrange the data for
other purposes. However, I will need the data to be kept up-to-date as per
the source worksheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to copy table of contents to a new doc 0
Cannot copy worksheet to another file 2
Excel 2007 crashes on copying worksheet to new workbook 0
Auto deletion of cell entry in given circumstance 0
Linking worksheets, rearranging rows. 1
Linking worksheets in different workbooks 0
How to create absolue path link to another workbook (Excel 2003) 1
How to update a value from a linked worksheet back to the master worksheet? 0

Top