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!

 

[Breakfast Guy]

You would need to create a userform where the user can enter the data in
one go, after which the entered data could be highlighted and a message
box that the user can either click yes or no to continue, you also need
to make sure that your named ranges are dynamic otherwise they will not
expand or contract with the insertion or removal of data.


--
Breakfast Guy

Regards,
Breakfast Guy
Forum Moderator
www.thecodecage.com

 

[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?

 

[Breakfast Guy]

No they don't have to be contiguous and yes you can write/record macro's
to deal with these issues.


--
Breakfast Guy

Regards,
Breakfast Guy
Forum Moderator
www.thecodecage.com

 

[a m spock]

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