Here is what I understand:

Export from Access to Excel

Main Report
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
(number of rows will vary)

Sub Report
xxxxxxxxxxxxxxx
xxxxxxxxxxxxxxx

Questions
1. Where do you want to go (e.g. first line sub report?)
2. Where is the data that you want to cut and paste? (sub report?)
3. You want to cut and paste the data 4 rows south of sub report?

Dave
http://www.buyeranalytics.com
http://www.purchasingblogs.co

--
BuyerAnalytic
-----------------------------------------------------------------------
BuyerAnalytics's Profile: http://www.excelforum.com/member.php...fo&userid=2378
View this thread: http://www.excelforum.com/showthread.php?threadid=37443