IF you use Microsoft Excel a lot, especially at work, it’s a huge pain to combine multiple worksheets into a single master worksheet. Good thing we can automate just about any Excel work with VBA (aka Excel Macro). In this Excel tutorial, I will be sharing a VBA automation script I use (as well as some of my clients) to combine any number of worksheets into a master table.
Buy Me a Coffee? Your support is much appreciated!
PayPal Me: https://www.paypal.me/jiejenn/5
Venmo: @Jie-Jenn
Source Code:
The code above looks very useful to me, however I only want the consolidation on 2 sheets within the workbook.
how can I amend the above code to allow this?
many thanks