Hi Expert's excel 2007
I need a macro to copy data from work book a which will be open when running the macro...to copy and paste special all into work book b at file path :"\\hfhjyukkgt\gjutjkk\workbook b.xlsx
data range a1:gg15000 workbook a
and paste the data into sheet Master cell a1...then close work book b down..
then the next time work book a is open delete the existing data and replace with the new data from wrk a when macro is re run