Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import Data into a Formula
Dear All,
working in Office 2003 on XP workstations, we have a user who would like to have a process automated. Currently after running an export routine from an Access database, she can open an Excel worksheet that has the required data. She selects two ranges, sums them, inserts a page break, and does some cosmetic changes. I can create macros that would allow her to slect the various ranges and do what needs to be done. I am wondering, however, if it is possible to create a template that has all the formatting and formulas in place, and to import the data (into the formlae) so that the entire process is automated. In my limited testing, I find that any "import" seems to automatically create new colums, pushing the cells with the formulas aside. I've done a fair amount of work with VBA in Word and we have control over the Access output (doesn't need to be a spreadsheet). I'd appreiciate it, if this seems do-able, if someone could point me in the right general direction to make it possible?? Sincerely, Ridge (in New Joisey) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
import XML data...Is there a size limit on the import? | Excel Discussion (Misc queries) | |||
How to Start Excel in Text Import Wizard for data import | Setting up and Configuration of Excel | |||
Formula and Data Lookup/Import Help Please! | Excel Discussion (Misc queries) | |||
PLEASE!! How can I un-grey the 'Data-Import External Data-Import Data' option ??? | Excel Programming | |||
ENTER A FORMULA IN A CELL TO UTILIZE THE IMPORT DATA FUNCTIONS? | Excel Worksheet Functions |