macro to copy data from work book a and paste to workbook b
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\wor
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
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\wor
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
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER