Raw data into a pre-defined template

[Red2003XLT]

HEllo,

I recieve a extract on a daily from an Access MDB. The extract is in the
form of an excel spreadsheet.

Depending on the day, The spreadsheet may contain 5 different categories of
information. Each category may or may not caintain any data.

Heres the question, How do I load/append/cut-n-paste this data into separate
pre-defined section of an excel spreadsheet(template?). I'm doing everything
I can to automated the process.

 

[Jon Peltier]

You could start by recording a macro while you populate your template
manually. Then go through and fix up the code to make it work for all
general cases.

- Jon

 

[Red2003XLT]

I thought about using the vlookup however variable amounts of data that stops
me.

 

[Jon Peltier]

How would you use VLookup? You can use a dynamic range as the lookup range.

- Jon

 

[Red2003XLT]

How do I use the dynamic range? Am I over thinking? Other then format(numbers
of columns and their order) I expect my data to fluctuate

 

[Jon Peltier]

You can define a name that includes the lookup range, which expands or
shrinks as the lookup range changes size. Similar to the defined names used
for dynamic charts:

http://peltiertech.com/Excel/Charts/Dynamics.html

Use the Name in the VLookup function.

=VLOOKUP(A1,MyRange,2)

- Jon