I have two open workbooks. I need to select data from one workbook (active worksheet) once i selected, that need to be pasted in another workbook opened, the parent workbook is having multiple sheet so its should be pasted on active worksheet. Before pasting on the parent workbook the active worksheet all rows to be deleted. Doing this manually taking more time. if some one help me for VBA code . it will be helpful.
Bookmarks