Hello there again!
I'm trying to assign a formula or function to a column of a dynamic table. In short, I have a data entry UserForm that I use to add invoices to one of my sheets. However, as it keeps adding new rows every time I add a new invoice I can't assign functions to columns in the same table that don't get filled in by the UserForm. For instance, when I enter the date of the invoice on the UserForm and save it, it enters the date in column C. In column D I want Excel to use the function =C2+14 to get a date 14 days later than the date entered in column C.
There are a couple more columns that need to be set up using different functions so I guess what I'm trying to find out is how to assigns a function and cell style (date, currency, etc) to a column and add it automaticly to every new row added. If that makes sense.
Thanks in advance!
I'm trying to assign a formula or function to a column of a dynamic table. In short, I have a data entry UserForm that I use to add invoices to one of my sheets. However, as it keeps adding new rows every time I add a new invoice I can't assign functions to columns in the same table that don't get filled in by the UserForm. For instance, when I enter the date of the invoice on the UserForm and save it, it enters the date in column C. In column D I want Excel to use the function =C2+14 to get a date 14 days later than the date entered in column C.
There are a couple more columns that need to be set up using different functions so I guess what I'm trying to find out is how to assigns a function and cell style (date, currency, etc) to a column and add it automaticly to every new row added. If that makes sense.
Thanks in advance!