Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 12th 05, 08:44 AM posted to microsoft.public.excel.worksheet.functions
Gimme
 
Posts: n/a
Default Excel Help Please

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

  #2   Report Post  
Old December 12th 05, 11:42 AM posted to microsoft.public.excel.worksheet.functions
Pete
 
Posts: n/a
Default Excel Help Please

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

  #3   Report Post  
Old December 12th 05, 04:53 PM posted to microsoft.public.excel.worksheet.functions
fascal
 
Posts: n/a
Default Excel Help Please

Hi,

You should try the copypaste special functionpaste link. That way, you
have true reference cells in the original. Hope this helps.

"Gimme" wrote:

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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) Alain79 Excel Discussion (Misc queries) 4 June 14th 05 07:34 AM
Stop Excel Rounding Dates leinad512 Excel Discussion (Misc queries) 1 April 20th 05 04:19 PM
Hints And Tips For New Posters In The Excel Newsgroups Gary Brown Excel Worksheet Functions 0 April 15th 05 05:47 PM
Excel error - Startup (and Acrobat PDFMaker) gxdata Setting up and Configuration of Excel 0 February 4th 05 04:44 AM
Excel 2002 and 2000 co-install. Control Which Starts ? cnuk Excel Discussion (Misc queries) 2 January 17th 05 09:07 PM


All times are GMT +1. The time now is 07:56 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017