Hi Hilary, looks good!
My first question: You're a 14 year old single mom?! And an Excel whiz to boot. Please update on how it is coming along, and I will try to help with some of your remaining troubles! Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of hilary lomotey Sent: Monday, April 30, 2012 9:06 AM To: excel-macros Subject: $$Excel-Macros$$ My First Excel Program Hello Guru's i am trying to build my first program with excel and its been fun,daring and tough at the same time. From a finance background i wanted to build something i can relate to. Attached is the file, basically what i want is to have to go thru a process of setting up a client, post the details to create the database. Secondly transact a business, ie be able to deposit or post a withdrawal and post it to the database. Be able to retrieve the client information.- i have been able to write a formula to retrive the client information (client info a/c) ***i have been able to write a formula that will extract a unique name from multiple records which i used for my data validation of names, i tried to sort these names with a formula but getting an error-- i need assistance here pls (client transactions a/c) ***Furthermore if i select the name of the client some of them come correctly while others give me an error (client transactions a/c). i have checked the formula over and over again but cant see where the error is coming from *** For the A/c Set up, can i get a VBA code such that any time i enter information in the spaces provided, i will be able to post the transaction to the a/c setup database. ***is it also possible to retrieve a client information and do amendment with a VBA code. (i have started learning VBA but not too strong enough) Thanks -- 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
image001.png
Description: Binary data
