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.

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.

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.

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.

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.

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


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