Hai Anil, Thanks for resolving the query and thanks for advising me about the user form.
Once again thank a lot experts. Regards Lokesh.M On Wed, May 9, 2012 at 2:42 PM, Anil Gawli <gawlianil8...@gmail.com> wrote: > Attached is the workbook and go to Calculation worksheet. > > > > > > > On Wed, May 9, 2012 at 6:01 AM, David Grugeon <da...@grugeon.com.au>wrote: > >> Hi Lokesh >> >> I do not think you will get a reply from this group to to your question >> as it is. What you are asking for is more in the nature of application >> design and that is not a quick and simple answer to a question. This group >> exists to help people who are having problems with VBA in Excel. Whilst >> you may need VBA to fill your form (which is not a 'user form' but a >> spreadsheet set up as an input form) the design of the form and the linking >> of that form to the relevant spreadsheet is something you will need to do. >> If your company does not have the relevant skills to do this they may need >> to hire a contractor to do it. >> >> To give you a start, I would be looking at using a unique identifier >> (Employee ID for example) to identify the row on sheet two that you want to >> use in sheet 1. Then I would probably use a macro to copy the data for one >> line from Sheet 2 to the form, add a button for OK when the changes were >> done and copy it back to Sheet 2. >> >> We can help you with the macros but the design of the "Beautiful" form is >> entirely up to you >> >> You will need to think about what information a user can enter to >> identify the relevant row of sheet 2. >> >> You will need to think about what operations you need to do create >> buttons for. I would think Edit (Load), Add, Delete, OK and Cancel at >> least. >> >> You will also need to specify all the validation rules for any cell which >> needs them. >> >> When you have done as much work as you can on the form and have >> identified the answers to all the questions come back to the group for more >> help with the VBA. >> >> >> On 9 May 2012 00:29, Lokesh Loki <lokeshsmg2...@gmail.com> wrote: >> >>> Hi Experts, >>> >>> Still i am not receiving any results in the group, could you please help >>> on us for the below query. >>> >>> I need a beautiful form, when i am selecting the name it contains all >>> the data which is already there in sheet2. So based on i need a user form >>> in sheet1. >>> >>> Please do the needful. >>> >>> Thanks in advance. >>> >>> Regards >>> Lokesh.M >>> >>> ---------- Forwarded message ---------- >>> From: Lokesh Loki <lokeshsmg2...@gmail.com> >>> Date: Sun, May 6, 2012 at 8:28 PM >>> Subject: Need help on data >>> To: excel-macros@googlegroups.com >>> >>> >>> Hi Experts, >>> >>> Please find the attached excel sheet and i need user form for this team >>> data. >>> >>> Here in the second sheet i have a data, i need user form in the first >>> sheet. >>> >>> Regards >>> Lokesh.M >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 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) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> ------------------------------------------------------------------------------------------------------ >>> To post to this group, send email to excel-macros@googlegroups.com >>> >> >> >> >> -- >> David Grugeon >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 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) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> ------------------------------------------------------------------------------------------------------ >> To post to this group, send email to excel-macros@googlegroups.com >> > > > > -- > Thanks & Regards, > Gawli Anil Narayan > Software Developer, > Abacus Software Services Pvt Ltd > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
