 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / November 2006using range names between several spreadsheets
Excel 2002 SP3 Win XP HE SP1 how do i use a range name that is defined in 1 excel file with a formula i am writing in another excel file? i can't figure out how to just copy|paste the name, etc. tx! Here's something you could try to see the syntax: In the workbook that's getting the formula Type = in an empty cell The go to the workbook that has the name. If the name is local to a particular sheet, go to that sheet. Hit F3 to see the Paste Name dialog choose the name you want hit enter Look at how the formula was completed. > Excel 2002 SP3 > Win XP HE SP1 [quoted text clipped - 3 lines] > i can't figure out how to just copy|paste the name, etc. > tx!  SignatureDave Peterson that works. i had already done that but i guess i didn't notice it was actually working--pasting it inside the other (current) sheet in other file. however, it is not as good as having the actual name defined in the current sheet/file. i can define it in current sheet but it wd be so much simpler if i cd just take the name defined in 1 file and just copy paste as a name into current sheet/file....... > Here's something you could try to see the syntax: > [quoted text clipped - 18 lines] >> i can't figure out how to just copy|paste the name, etc. >> tx! I missed that in your original question. Debra Dalgleish shows a way (for a different purpose, though): http://contextures.com/xlDataVal05.html#Reference but it should answer your question. > that works. i had already done that but i guess i didn't notice it was > actually working--pasting it inside the other (current) sheet in other file. [quoted text clipped - 26 lines] > >> i can't figure out how to just copy|paste the name, etc. > >> tx! SignatureDave Peterson OK that's great peter, i'll look into it tx. > I missed that in your original question. > [quoted text clipped - 32 lines] >>>> i can't figure out how to just copy|paste the name, etc. >>>> tx!
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.