The shape is simply from the forms. You could even use a .jpg or whatever. I will look forward to seeing you final.
Don Guillett SalesAid Software dguille...@gmail.com From: ITP Abdulgani Shaikh Sent: Wednesday, December 21, 2011 9:30 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to create Form for storing data Thanks Sir, for your prompt reply. Can you please tell me how you have created the button/shape ? I will be back to you after completing whole macro. Regards On Wed, Dec 21, 2011 at 7:29 PM, dguillett1 <dguille...@gmail.com> wrote: 1. You would want a macro to export the master sheet data to the next available row in the db. A button/shape when filled in. 2. Another macro to import db data back to master. See attached A note to all. When attaching files please give your name and meaningful name such as attached. You may rename when final. Don Guillett SalesAid Software dguille...@gmail.com From: ITP Abdulgani Shaikh Sent: Wednesday, December 21, 2011 2:38 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ How to create Form for storing data Dear Friends, I am Tax Practitioner. I have to calculate tax to be payable by each Salaried employees (say 200 in numbers), format of Computation of Tax Liability is in attached file (Sheet name "Master"). For calculating 200 employees tax liability I have to always create new sheet (By pressing Common Button at J1). My query is 01. When I entered data in Master Sheet, it should be stored in next Data Sheet. Field name and Data from where (Cell reference) to be captured is given in attached file. 02. Data can be retrieved by selecting "EM Code" given at cell A1. eg.There are 200 employees, I want to see calculation of EM 85, when I select EM85 from Master Sheet, all relevant data should re-appear in Master sheet from Data Sheet. Please guide Regards -- Shaikh AbdulGani A R ITP, STP, TRP, STRP -- FORUM RULES (934+ 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 (934+ 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 -- Shaikh AbdulGani A R ITP, STP, TRP, STRP -- FORUM RULES (934+ 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 (934+ 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
