Step 1 – Setup is a cinch, and we knock it all out on lines 14-18. Let’s review the code using the 4-step VBA process as our guide: Here’s a link to the code above so you can review it side-by-side with the walk through below. Here’s the scoop y’all - our It’s Always Sunny sales data can be combined with this macro: Phew! Now we can get back to the task at hand… combining data! Check the box next to the “Microsoft Scripting Runtime”.Scroll down until you find “Microsoft Scripting Runtime”.Select “References” from within the Tools menu.This 13-second gif walks you through the steps, but in case it is not working here is a quick step-by-step guide: This is how to add the Microsoft Scripting Runtime Reference
0 Comments
Leave a Reply. |