Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding row from userfrom and copying formulas
I have the following code that will add a record to the next blank row.
Private Sub cmdAdd_Click() ' Save form contents before changing rows: SaveRow ' Set current row to first empty row, i.e. one row after ' the last row currently in use: If Cells(1, 1).Value = "" Then lCurrentRow = 1 ' (list is empty - start in row 1) Else lCurrentRow = ActiveSheet.UsedRange.Rows.Count + 1 End If ' Clear the form for user to add new name: LoadRow ' Set focus to Name textbox: txtReqNum.SetFocus End Sub What I would like to do is instead of add the userform data to the blank row is to add a new row and add the userform data to that new row. I have existing data in columns A:O (this is also where the new data from the userform will be added, but in the newly added row) and I have hidden formulas that counts up the various values of A:O in columns P:AG. I need the formulas from the previous row that currently has existing hidden formulas (P:AG) copied to the new row that we just added in the same range (P:AG). I also have the sums of colums P:AG added up in the row below the new added row in the same range P:AG in each of those columns and need the sum formula updated to reflect the counts of the newly added row data. I know this may be very complicated (it is for me at least) so any help would be greatly appreciated. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userfrom problem... | Excel Discussion (Misc queries) | |||
How do you use DTpicker in a Userfrom | Excel Discussion (Misc queries) | |||
sum function in a userfrom | Excel Programming | |||
Userfrom textboxes | Excel Programming | |||
Userfrom textboxes | Excel Programming |