Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |