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 <itpabdulg...@gmail.com> > *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
