Hello;
Thank you in advance for any help that you may have to offer. I don't
typically work with any VB so my knowledge is limited.
I have a worksheet that I would like to add rows to. Say rows 10 through 20
are static. I would like to have a button that will add the rows at the
bottom of the rows. There are functions within some of the row column
intersections. They are basic functions based on a data validation list used
to qualify the vlookup formulas and the 4 data entry points to calculate
dimensions.
I have seen a lot of posts here that have buttons that appear to do just
that. My situation is that I have 2 worksheets that this needs to be
accomplished on. That is that when I insert a new row between 19 and 20, I
need the button to complete this on sheet1 and sheet2.
Sheet 2 has very basic functions as well. Columns A-F are =sheet1!a10 (b10,
c10, etc.) Then the final columns perform some math to calculate dimensions
and vlookup functions to finish the calculations.
In an ideal world, I would also prefer to do this as a tab through. When I
tab out of row 19 to row 20, a new blank row 21 would appear with all of the
formatting, functions and calculations. The formatting is minimal. Kind of a
light gray dot pattern every other row. If it is easier to eliminate this, it
can be done without a problem.
Any help or direction you could point me in would be greatly appreciated.
Even if the only thing you could do is point me to where I can learn about
the button to insert a row.
Thank You in advance for your help. Have A Great Day.
Frank Pytel
|
Similar Threads
