Hello,
I am new to the board but have been reading it for a couple of weeks as I build my spreadsheet. So far, the info I have found has been extremely helpful but I have run into a bit of a roadblock.
I was hoping someone could help me create a macro to add and remove lines within a spreadsheet my office uses. Thanks for your help in advance!
To help illustrate my request, I have included a google doc link of a portion of the spreadsheet that can be used as ref.
Essentially, for each section of budget items on "sheet2" I would like to be able to add/delete rows either below a selected row/cell in that section or if no row/cell in that section is selected a new row would be added at the bottom of that section. I would like the the new row to have all of the formulas and formats of the selected row but no data
For example, on "sheet2" If I want to add a row below 'row 7' I would select 'row 7' or a cell in that row (ie: 7A) and press the "+" button, if I wanted to add a row at the bottom of this section (under 'row 9') I would select a cell or row outside of this section (Section A is considered rows 4:12) and press the "+' button.
For removing a row, i would like to select the row I desire to remove and click the "-" button to remove that row.
In addition to this, the row added or removed on "sheet2" would need to be reflected on another sheet ("sheet1"). The rows/columns are not the same as they are in Sheet2 though. For example if I add a row on "Sheet2" under "row 7" it would then need to show up on "Sheet1" as appearing under "row 4".
Sorry for the long winded explanation but I wanted to try and make my request as clear as possible. Thanks in advance for your help!
Greg
https://docs.google.com/spreadsheet/ccc?key=0AtQCcBUHMBoNdHVrQWlGTmhXWnh4cVFpRTZFSDFaeVE&hl=en_US
I am new to the board but have been reading it for a couple of weeks as I build my spreadsheet. So far, the info I have found has been extremely helpful but I have run into a bit of a roadblock.
I was hoping someone could help me create a macro to add and remove lines within a spreadsheet my office uses. Thanks for your help in advance!
To help illustrate my request, I have included a google doc link of a portion of the spreadsheet that can be used as ref.
Essentially, for each section of budget items on "sheet2" I would like to be able to add/delete rows either below a selected row/cell in that section or if no row/cell in that section is selected a new row would be added at the bottom of that section. I would like the the new row to have all of the formulas and formats of the selected row but no data
For example, on "sheet2" If I want to add a row below 'row 7' I would select 'row 7' or a cell in that row (ie: 7A) and press the "+" button, if I wanted to add a row at the bottom of this section (under 'row 9') I would select a cell or row outside of this section (Section A is considered rows 4:12) and press the "+' button.
For removing a row, i would like to select the row I desire to remove and click the "-" button to remove that row.
In addition to this, the row added or removed on "sheet2" would need to be reflected on another sheet ("sheet1"). The rows/columns are not the same as they are in Sheet2 though. For example if I add a row on "Sheet2" under "row 7" it would then need to show up on "Sheet1" as appearing under "row 4".
Sorry for the long winded explanation but I wanted to try and make my request as clear as possible. Thanks in advance for your help!
Greg
https://docs.google.com/spreadsheet/ccc?key=0AtQCcBUHMBoNdHVrQWlGTmhXWnh4cVFpRTZFSDFaeVE&hl=en_US
