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" wrote:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Red2003XLT" wrote in message
...
I thought about using the vlookup however variable amounts of data that
stops
me.

"Jon Peltier" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Red2003XLT" wrote in message
...
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.