Dear Friends
CONSOLIDATE DATA in one sheet
I am using excel in Google share drive. My team and branch is updating the data in branch wise sheet. Branch – 1,2,3,4,5,6,7 total branches. Now I need to Consolidated Data on Consolidated sheet. I attached excel sample sheet also please check and give me one solution
Hi,
You can use something like this
Please Login or Register to view this content.
Cheers!
Deep Dave
Dear Deep Dave,
thanks for your repley. this code is working but i am getting duplicate. that means Branch - 1 i update the data its getting CONSOLIDATE data sheet but second time i click the button CONSOLIDATE all in that branch 1 sheet getting data again in CONSOLIDATE DATA sheet?
Dear friend
same issue form me toooooo!!!!!!!!!!!
Hi,Originally Posted by sudbhavan
I don't think you have linked the New Macro to the Orange button.
Right Click on the Orange Button > Assign Macro > assign the Macro named ConsolidateData
Dear.macros code is working fine but i am getting duplicate entry in CONSOLIDATE DATA sheet
Last edited by sudbhavani; 01-28-2020 at 12:23 AM.
Hi,
Are you using the exact same file attached in the Post above..
I have tried it and it works fine at my end..
Hi Dave Gud morning please see the post1 same format. My team and branch will enter the data daily bases
Last edited by sudbhavani; 01-28-2020 at 01:23 AM.
Hi,
See the file attached..
Thanks Dave its working fine
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks