Each Month I receive a CD with an excel spreadsheet( call it Input
Spreadsheet). Each row contains certain fields that I need to use to build a
spreadsheet( call it Load Spreadsheet) that I will use to import/export
into Access. However, there is a different number of rows each month. For
example one month may have 500 records/rows and the next month may have 600
records/rows.
When I create a Macro I turn on the recorder and make the moves of columns
from input spreadsheet to load spreadsheet. However the next month may have
more or less records/rows and the macro does not work. It moves the
identical number of rows that was recorded.
Does anyone have a fairly simple/straight forward solution to this
situation??

Greg