Importing data - then clearing it on exit

hi

this is what i need to do if possible

I need to import data into a worksheet from another 'live' excel document that is constatly updating and i need to reflect those updates in my excel sheet..

but i need that data to clear on exit and reload on startup - but then populate only certain areas in the worksheet and in the name defined areas (so that the validation drop downs still work)


its this poosible or i am expecting to much from excel and should move to access??

Record all these actions with the Macrorecorder, and then split it up in two sub's for reload and clearing. Get the sub for reload in the 'Workbook_Open()' event and the sub for clearing data in the 'Workbook_BeforeClose' event.