Hi guys,
I am attaching a sample file with instructions for your ease.
I will really appreciate if you can help me out with this.
Hi guys,
I am attaching a sample file with instructions for your ease.
I will really appreciate if you can help me out with this.
Hi,
One way with the following macro
Note your Master sheet has VBA codename Sheet3. Change if necessary for your actual workbook.
![]()
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thanks a lot,
I quickly tried it in a new datasheet with new sets of data, and it is working well.
I will give it more thorough testing later, but thanks a lot.
@ Hello23
Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.
Hi, the code is working very well, but there is one issue.
Each time I make a change to a sheet named @____ the master sheet
adds a second set of data from all the sheets. So basically I have to
clear the contents of the master sheet, and then run the code again,
then the data doesn't appear twice, but just once with the changes made
on the @____ sheets.
Is there a better way so that the master sheet automatically updates the
data correctly without me having to clear contents, and then run the code again.
Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks