OK so I have a sheet that has a list of grants and basic info on those grants (Tab Info). On another sheet (Tab Financial) I have Expenditures, Revenue, and Match in column A and Months across 9. I'm trying to have a new row inserted for each section for each grant. I want to be able to run a macro that will add 3 new row for each Type (Expenditure, Revenue, etc.) at the end of sheet for the new grant added.
Essentially the Macro would say (i think): Find last row on Info tab in Column A and on tab Financial Insert 3 rows, in new rows in Column A say Expenditure, row 2 Revenue, row 3 Match and in Column B say New Grant number.
I hope that makes sense...I thought this would be simple but i'm spinning my wheels here.
ON Info Tab:
Grant 1
Grant 2
ON Financial Tab:
Expenditure Grant 1
Revenue Grant 1
Match Grant 1
Expenditure Grant 2
Revenue Grant 2
Match Grant 2
Expenditure NEW GRANT
Revenue NEW GRANT
Match NEW GRANT
Essentially the Macro would say (i think): Find last row on Info tab in Column A and on tab Financial Insert 3 rows, in new rows in Column A say Expenditure, row 2 Revenue, row 3 Match and in Column B say New Grant number.
I hope that makes sense...I thought this would be simple but i'm spinning my wheels here.
ON Info Tab:
Grant 1
Grant 2
ON Financial Tab:
Expenditure Grant 1
Revenue Grant 1
Match Grant 1
Expenditure Grant 2
Revenue Grant 2
Match Grant 2
Expenditure NEW GRANT
Revenue NEW GRANT
Match NEW GRANT
Last edited: