Hello Everyone!
In my attached sheet, I want a macro which will copy the data from multiple sheet (i.e. suppose export here) with dynamic range into blank row existed sheet (i.e. Data). The macro will also refresh the pivot table automatically without doing manual work (present on sheet "Pivot").
Advance thanks
You want the Data to be added in existing sheet or want to delete the previous data and add the new one.?
Try Below
Please Login or Register to view this content.
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks