Dear Experts
I need ur help here
I want copy the range of cell value (E11:M33) from closed workbook paste into same set of range of cells with pastespecial values into master file
I have set of range in closedworkbook called(COPYWB.XLS) ,in particular location C:\Users\aruna\Desktop\CTOP\COPYWB.XLS(sheet name is DASHBOARD)
for copy the range of cell (E11:M33) from this workbook and paste (E11:M33) same range into MASTER WORKBOOK(DASHBOARD SHEET) (E11:M33)With pastespecialvalues..
I add two command button in MASTERWB..one button pull data , another button clear the data on range ,,keep empty
find the attachment... COPYWB IS value copy from this wb,MASTER is value paste into this wb...
thanks
Bookmarks