I have never written a macro, but I think I can figure it out with a little help.
What I need to do is I have an area set up in my spreadsheet that has calculations (about 130 rows worth) They can all be dragged manually out to the right to fill in how large I need it. They are broked down by month (i.e. my column headers are months) I want a macro to autofill to the right based on how many years I input into G10. So if I entered 10 I want it to copy (i believe a loop is what its called?) the formulas I have in cells J11 through J130 across to the right for 10 years (120 months). Any help is appreciated. Or if I am being too vague let me know.
What I need to do is I have an area set up in my spreadsheet that has calculations (about 130 rows worth) They can all be dragged manually out to the right to fill in how large I need it. They are broked down by month (i.e. my column headers are months) I want a macro to autofill to the right based on how many years I input into G10. So if I entered 10 I want it to copy (i believe a loop is what its called?) the formulas I have in cells J11 through J130 across to the right for 10 years (120 months). Any help is appreciated. Or if I am being too vague let me know.