VBA new row based on last row and input box

[Kubas]

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]

data form?

https://support.office.com/en-us/art...c-a8ce70609374

[Kubas]

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]

Atleast what would be a code to create new row in each worksheet and copying formulas, formats?.

[mana]

table?

http://https://support.office.com/en...9-6c94334e492c