Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
working with data in the same workbook?
I have a database table which imports data from the web. This is OK,
however I need to be able to extract certain entries and copy them to a different worksheet. The advanced filter cannot do it. Pivot tables dont allow me to "copy down formulas in adjacent cells" - which is a must I would like to use the Import External Data function (this does everything I want) except it links to a data source on my C:/ drive. I just want it to link to a worksheet in the same workbook, this way it is portable since I dont have a shared drive. Have I missed something simple? -- Thanks Andrew |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
working with data in the same workbook?
Hard to tell without seeing but a macro can be created to do what is
desired. -- Don Guillett SalesAid Software "Andrew" wrote in message ... I have a database table which imports data from the web. This is OK, however I need to be able to extract certain entries and copy them to a different worksheet. The advanced filter cannot do it. Pivot tables dont allow me to "copy down formulas in adjacent cells" - which is a must I would like to use the Import External Data function (this does everything I want) except it links to a data source on my C:/ drive. I just want it to link to a worksheet in the same workbook, this way it is portable since I dont have a shared drive. Have I missed something simple? -- Thanks Andrew |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
working with data in the same workbook?
Don, I am a real novice with writing code. I can record macros but thats
about it. I tried doing this but ran into real problems with relative cell references when I want to copy adjecent formulas - and the length of database keeps changing. Ideally I was looking for a way to change the SQL "FROM `C:\Documents and Settings\andrew\Desktop\excel expected invoice`.dbase dbase" so instead of looking for c:\ it would just look in the current workbook for the range. is that possible? -- Thanks Andrew "Don Guillett" wrote: Hard to tell without seeing but a macro can be created to do what is desired. -- Don Guillett SalesAid Software "Andrew" wrote in message ... I have a database table which imports data from the web. This is OK, however I need to be able to extract certain entries and copy them to a different worksheet. The advanced filter cannot do it. Pivot tables dont allow me to "copy down formulas in adjacent cells" - which is a must I would like to use the Import External Data function (this does everything I want) except it links to a data source on my C:/ drive. I just want it to link to a worksheet in the same workbook, this way it is portable since I dont have a shared drive. Have I missed something simple? -- Thanks Andrew |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
workbook linking cells not working within a workbook | Excel Discussion (Misc queries) | |||
Calling another workbook not working | Excel Worksheet Functions | |||
Links w/in same workbook not working | Excel Discussion (Misc queries) | |||
Often-Used Code not working in a new Workbook | Excel Discussion (Misc queries) | |||
Formulas not working after transfering to new workbook | Excel Worksheet Functions |