Hello, I am new to the macro writing world so any assistance would be much appreciated. I have two worksheets in excel. The first is a summary worksheet that has formulas that average some totals on the other worksheet, which happens to be a template that is unpopulated with data. I need a macro that will automatically update the average formula's on the summary sheet every time a new blank template worksheet is created. I initially tried this by recording the macro, however it didn't work and I don't know a thing about visual basic.
I have copied and pasted the macro that I am try to tweak below. The macro creates a new worksheet, however everytime I execute the macro, it doesn't add the figures from my new templated worksheet to the cells in my summary sheet. Please help?
Bookmarks