PG, Please share an example with some data!
regards, Basole. Em sexta-feira, 20 de dezembro de 2013 16h27min17s UTC-2, PG escreveu: > > Hi, > I have a problem to solve here. > > I have a master list of about 1000 records, which has Order ID, Customer > Name, Address, and Order Amount columns. > Now I need to print an order list with some Order IDs (hand picked) on it > from time to time which will have all the above columns. Now to print this > Order list, I want to use a User form to enter the Order ID and want other > fields to get populated itself from the master list. Then when I click on a > button to Add, this data gets added to the Order List. > > So basically I want to pull data from the master list into the Order list > but using the form so that when I enter the Order ID manually, the other > corresponding values get populated itself in the form and then get added to > the Order List, until all the orders are added. Then to print this order > list in the end. By this way I don't have to manually pick the Order IDs > from the master List and copy-Paste into the Order List. > > I don't want to use the simple vlookup in Excel because there is a chance > of someone manipulating the data by mistake. I would like the master > database to be hidden from the user and the User Form to show when the > program is run and then get the final printed Order List. > > Hope this is clear, if not please feel free to clarify. > > Thank you so much in advance. > > Regards > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
