F
Frank Pytel
Hello;
I have looked through quite a few posts. There appears to be quite a bit of
code that shows how to add a row, between two rows. I need it to add on 2
sheets at a time.
Ideally what I would like to do is something like this.
Rows 10 through 20 are calculated based on 1 selection and 4 data entry
fields. The remainder of the cells on that row will calculate based on the
entries. The user tabs through rows to select qualifiers and complete data
entry.
Occasionally a user will have insufficient rows to enter all of the data
into and they will need to use a new sheet to enter information on. I would
like to add a row. I would like it to carry all of the formulas and
formatting as well. Formatting is fairly simple in that alternate rows have
a fill pattern of dots (12%?) with a 25% gray coloring. The rest is
continuous through out the worksheet except for some conditional formatting
that is not included in the area I would like to put rows. I would like to
include a button, or preferably when the user "tabs" through to the next
line or when the final cell within the rows has a value greater than 0 and
not blank, a new row will appear.
I would also like this row to update to another sheet. The first is for
calculating pricing, the second is for calculating labor costs. All of the
data that is entered is carried over to the installer sheet. Very basic
stuff (=sheet1!A10). There are some more complex (vlookup, pretty basic)
formulas in the other columns that would need to be written to the new row
as well.
Is there a way to get the button, or the preferable method of saying if cell
F20 is greater than 0 and not blank add a row below, to add to both sheets
at the same time?
Thank you very much for your help with this. I prefer to design without VB
whenever possible so I am limited in what I can do with VB.
Have a Great Day.
Frank Pytel
I have looked through quite a few posts. There appears to be quite a bit of
code that shows how to add a row, between two rows. I need it to add on 2
sheets at a time.
Ideally what I would like to do is something like this.
Rows 10 through 20 are calculated based on 1 selection and 4 data entry
fields. The remainder of the cells on that row will calculate based on the
entries. The user tabs through rows to select qualifiers and complete data
entry.
Occasionally a user will have insufficient rows to enter all of the data
into and they will need to use a new sheet to enter information on. I would
like to add a row. I would like it to carry all of the formulas and
formatting as well. Formatting is fairly simple in that alternate rows have
a fill pattern of dots (12%?) with a 25% gray coloring. The rest is
continuous through out the worksheet except for some conditional formatting
that is not included in the area I would like to put rows. I would like to
include a button, or preferably when the user "tabs" through to the next
line or when the final cell within the rows has a value greater than 0 and
not blank, a new row will appear.
I would also like this row to update to another sheet. The first is for
calculating pricing, the second is for calculating labor costs. All of the
data that is entered is carried over to the installer sheet. Very basic
stuff (=sheet1!A10). There are some more complex (vlookup, pretty basic)
formulas in the other columns that would need to be written to the new row
as well.
Is there a way to get the button, or the preferable method of saying if cell
F20 is greater than 0 and not blank add a row below, to add to both sheets
at the same time?
Thank you very much for your help with this. I prefer to design without VB
whenever possible so I am limited in what I can do with VB.
Have a Great Day.
Frank Pytel