Excel Help Please

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gimme - 12 Dec 2005 07:44 GMT

Could anyone tell me if it is possable to copy names from one book to another
book.
ie. I have berwick,bastille ,challange ect in one work book in seperate rows
and these will keep coming up again in the same workbook and I want to copy
information about them into another workbook so that I know the sum total of
each one without haveing to copy and paste each time.
bastile 200
berwick 200
bastile 150
challange 200
berwick 500
this is simlar to what I will be doing but with
dates and wk No's
and I want a total for each one in a seperate workbook.
any help please

Reply to this Message

Pete - 12 Dec 2005 10:42 GMT

You can use File | Save as in your original workbook (assume this is
called Book_1) to save it with a different name, eg Book_2. In Book_2
you can then enter different data and your named ranges will be
preserved. In your summary file you can then refer to each named range
in each file by using square brackets around the file name, eg.

=[Book_1.xls]bastile

if Book_1 is open at the same time - if not, you need to include the
complete path.

Hope this helps,

Pete

Reply to this Message

fascal - 12 Dec 2005 15:53 GMT

Hi,

You should try the copy>paste special function>paste link. That way, you
have true reference cells in the original. Hope this helps.

> Could anyone tell me if it is possable to copy names from one book to another
> book.
[quoted text clipped - 11 lines]
> and I want a total for each one in a seperate workbook.
> any help please

Reply to this Message