Paste range of formulas to a sheet using Personal Macro Workbook

**Cheeseburger** · 06-16-2015, 12:12 AM

I have a spread sheet, and I have a range of formulas on that sheet. I recently made adjustments to the formulas but there are a ton of one off versions of that worksheet. I want to be able to open any one off version of that workbook, run the macro, and my updated range of formulas will be pasted into that old workbook. But I am using the Personal macro file so that I don't have to open up the new file every time.

So basically, my plan is to paste my new range of formulas onto my personal macro worksheet. Then create a code so that when I open up one of my old workbooks that have outdated formulas, I will run the macro and the new formulas that I have as a range in the personal macro sheet, will be copied and pasted into a specific sheet on the old workbook I have open.

How would I go about doing this?

EDIT*** To clarify, I know how to use the personal macro worksheet. My question is strictly about the code for the macro.

**banaanas** · 06-16-2015, 01:09 AM

Why don't you loop through all the excel files automatically?
Just put them all in a folder and use this code.

I allredy posted this another thread today, and he got it working.
Just change the folder where all you excel files is, and then change the Mymacro at the bottom to make the changes you need.
This code will then loop through all the files, make the changes and save them.

Please Login or Register  to view this content.

**Cheeseburger** · 06-16-2015, 06:06 PM

Unfortunately, I have to do it by the method that I described for several reasons. One of which is I have to decide which files I want to run the macro in, as sometimes I may want to use the old formulas. Also, I share my personal macro file with a colleague as we both use the same macros for our work.