Interactive Data Entry

[a m spock]

I need user to interactively enter sales data into six columns each of which
is a named range i.e. Date, Quantity, Rate, Net Amount, SalesTax, Service
Tax. The rest of the columns are calculated from this dat and are locked. The
sheet opens at the left cell of the first empty row. Data is filled as
transaction takes place.

Afer entry user should review and confirm before data is saved. Can someone
please help!

 

[a m spock]

thanks. these columns are not contiguous and for various reasons can not be.
they also do not have column heads. i understand both are preconditions for
userforms! is that correct?

and can one write a mcro to do the same thing?

 

[a m spock]

Thanks. I have no idea where to go from here! Can you help?