Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Interactive Data Entry
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Interactive Data Entry
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 ------------------------------------------------------------------------ Breakfast Guy's Profile: http://www.thecodecage.com/forumz/member.php?userid=5 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=7252 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Interactive Data Entry
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" wrote: 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 ------------------------------------------------------------------------ Breakfast Guy's Profile: http://www.thecodecage.com/forumz/member.php?userid=5 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=7252 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Interactive Data Entry
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 ------------------------------------------------------------------------ Breakfast Guy's Profile: http://www.thecodecage.com/forumz/member.php?userid=5 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=7252 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Interactive Data Entry
Thanks. I have no idea where to go from here! Can you help?
"Breakfast Guy" wrote: 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 ------------------------------------------------------------------------ Breakfast Guy's Profile: http://www.thecodecage.com/forumz/member.php?userid=5 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=7252 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save 60% on Data Entry, Data Conversion, Data Processing Services byOffshore-Data-Entry | Excel Programming | |||
Save 60% on Data Entry, Data Conversion, Data Processing Services byOffshore-Data-Entry | Excel Programming | |||
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
iNTERACTIVE EXCEL FILE NOT INTERACTIVE ON THE WEB | Excel Discussion (Misc queries) | |||
Interactive Data entry | Excel Programming |