Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
i have some infomation (numbers) in other file (not excel) that file can't be copied. i would like to get those numbers into my excel file. eg: In that file: ganga orders 55 neworders 10 i created excel file to do a report using that file: ganga orders 55 neworders 10 I want those numbers come by itself... now i open both file enter them manually.. Thank you |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Have you tried Copy and Paste?
Pete On Apr 15, 5:19*pm, ganga wrote: Hi, i have some infomation (numbers) in other file (not excel) that file can't be copied. i would like to get those numbers into my excel file. eg: In *that file: * * * ganga * * orders * *55 * * * * * * * * * * neworders 10 i created excel file to do a report using that file: * * * ganga * * orders * *55 * * * * * * * * * * neworders 10 I want those numbers come by itself... now i open both file enter them manually.. Thank you |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
i can't copy that file.
"Pete_UK" wrote: Have you tried Copy and Paste? Pete On Apr 15, 5:19 pm, ganga wrote: Hi, i have some infomation (numbers) in other file (not excel) that file can't be copied. i would like to get those numbers into my excel file. eg: In that file: ganga orders 55 neworders 10 i created excel file to do a report using that file: ganga orders 55 neworders 10 I want those numbers come by itself... now i open both file enter them manually.. Thank you |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Who is buying all this "ganga" you're taking orders for? <g
Why don't you jusr create a "link" from one book to the other? See help on Linking Gord Dibben MS Excel MVP On Tue, 15 Apr 2008 09:19:01 -0700, ganga wrote: Hi, i have some infomation (numbers) in other file (not excel) that file can't be copied. i would like to get those numbers into my excel file. eg: In that file: ganga orders 55 neworders 10 i created excel file to do a report using that file: ganga orders 55 neworders 10 I want those numbers come by itself... now i open both file enter them manually.. Thank you |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You don't mention the file format. If it is a text file, try to open it
using the Excel Open command. You will get an assistant that will help you bring the data into Excel (from either delimited or fixed length). If it is not a text file, try Data, External Data, Import Data (or similar, I am use the French version so not sure of English command names). Good luck! "ganga" wrote: Hi, i have some infomation (numbers) in other file (not excel) that file can't be copied. i would like to get those numbers into my excel file. eg: In that file: ganga orders 55 neworders 10 i created excel file to do a report using that file: ganga orders 55 neworders 10 I want those numbers come by itself... now i open both file enter them manually.. Thank you |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thank you.. i change that files to an excel files.. but each file gives
different cell number each time so i don't know how to link the file now... eg: ganga orders 55 (sometimes c15 , sometimes C21 like that) neworders 10 (sometimes c16 , sometimes C22 like that) and sometimes same as one file... "Donna" wrote: You don't mention the file format. If it is a text file, try to open it using the Excel Open command. You will get an assistant that will help you bring the data into Excel (from either delimited or fixed length). If it is not a text file, try Data, External Data, Import Data (or similar, I am use the French version so not sure of English command names). Good luck! "ganga" wrote: Hi, i have some infomation (numbers) in other file (not excel) that file can't be copied. i would like to get those numbers into my excel file. eg: In that file: ganga orders 55 neworders 10 i created excel file to do a report using that file: ganga orders 55 neworders 10 I want those numbers come by itself... now i open both file enter them manually.. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
Changing sheet reference to cell reference | Excel Worksheet Functions | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
Macro to Reference Column Next to Current Reference | Excel Discussion (Misc queries) |