Hi i have an Excel Spreadsheet which refresh data from an ODBC link. So everytime it opens the data refreshes. At present i have 2 sheets with 2 queries from ODBC on the sheets.

I want to merge the sheet up everytime it opens is there a way of doing this. The titles are exactly the same. My last option is to copy and paste both sheets into 1 sheet .

Thanks

Hem