PDA

View Full Version : VBA new row based on last row and input box



Kubas
10-26-2016, 05:56 AM
Hello everybody,

I am trying to find a code which which could do:

1. Always create a new row with all formats from previous row.
2. Open input box and ask for information to type in i.e Full name, and place that information in to created row in column "Full name" which is "C" range. This could be based on last value in column C and then offset maybe?
3. Would want to repeat input box for more column values i.e address, job role etc.

Could somebody help me out with it please?

Best regards

mana
10-26-2016, 06:16 AM
data form?

https://support.office.com/en-us/article/Add-edit-find-and-delete-rows-by-using-a-data-form-17bca0a4-3ba5-444a-983c-a8ce70609374

Kubas
10-26-2016, 07:20 AM
This is awesome and does a job, but there is one reason I wish to use VBA for this.
I have more Worksheets and would like to create "New entry" macro which would create a row on all worksheets simulately.

Kubas
10-26-2016, 10:07 AM
Atleast what would be a code to create new row in each worksheet and copying formulas, formats?.

mana
10-30-2016, 01:25 AM
table?

http://https://support.office.com/en-us/article/Overview-of-Excel-tables-7ab0bb7d-3a9e-4b56-a3c9-6c94334e492c