Would like to "imply" two one-cell ranges by appending them to to the first
two columns an existing range, meant for import into Access.

Existing range: MyAccessRange, columns A thru J, rows changing all the time,
but for now say 10-100. Data exists only in columns C thru J.

The one-cell ranges 1id and 2id are necessary as Access key fields:
- 1id needs to be "implied" into column A, as many rows as required.
- 2id needs to be "implied" into column B, as many rows as required.
Both the above are only for import into Access, and should not affect
anything else.

I could physically construct another tab for this, but ...
a) This schema is required for multiple tabs.
b) It would be redundantly using large groups of data.
b) The workbook size would start to become prohibitive.

Any assistance would be greatly appreciated.
And please let me know if this needs clarification.
Regards,
- Mike