Can't you just copy to a scratch area, and pluck to your true
destination a la B1=Sheet1!A2 ? Alternatively: Is your recordsource an
Access table? Your recordset could be a query instead of a table, which
returns records with fields

UsefulField1
"Filler"
"Filler"
UsefulField2
UsefulField3
etc.

which orients correctly to your destination.

It's difficult to answer without knowing what your recordset is.

Recordset is an access table... I have a monthly ledger with data from every
day... The data is stored in an access table but the worksheet has columns
umungst the data...

Ernst.