Hello everyone I’m new to VBA so apologies in advance for any obvious mistakes. I have multiple named ranges in sheet 1 that multiplies to diffrent columns in sheet 2. I need to see the changes in sheet 2 for changes I make in sheet 1. I want to know if it is possilble to have a macro that will save the output(sheet 2) everytime I hit save in to a new sheet. Thanks so much and please feel free to guide me to where I can learn how to do this. Thanks!!!!!