Hi all,
please refer to attachment.
i need some help. I want to create a macro to populate all the "OPEN" status based on column C (Status) on from multiple sheets(i will have 17 multiple sheets ie.A to Q), and into a separate sheet, in this case, sheet 1 (ALL). Thanks in advance guys.
Have you considered using Power Query instead of VBA?
Power Query is a free add-in from Microsoft for Excel 2010 and 2013 and built into Excel 2016 as Get and Transform.
Ken Puls has a great blog post about how to do what you describe.
because of security purposes, my work laptop doesn't allow me to download these programs. It would be much easier if i could
something like this
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks