URGENT VBA Code Required

**tf91** · 03-02-2012, 08:20 AM

Dear all,

I am currently creating a series of spreadsheets for a client to log their financial activity. One of the spreadsheets is directly related to the sales and income of his business.

The idea is that he enters all info into a single spreadsheet, which then transfers the relevant information into the other spreadsheets.

The business plan is a simple commission taken from the letting of a property. I want him to be able to enter the date, amount in, commission held, amount out and most importantly, the property that the transaction relates to.

From here I would like the information in the row to be copied to the relevent worksheet, based on the value that has been entered.

Properties are 1-10 (Property 1...etc), and the target worksheets are labelled as such. This will also be the reference used when entering the transaction info first of all.

The intial worksheet is called 'Client Monies'. Column G of Client Monies will contain the references to the properties, and entries start on row 10.

The destination worksheets (Property 1 - Property 10) have their entries starting from A15:E15.

When a cell in Client Monies, column G, contains the relevent information, I would like cells B-F of the same row transferred to the relevent sheet.

Any questions, please ask.

Thanks in advance,

T Hall

**snb** · 03-02-2012, 08:42 AM

Because it's urgent: what is your budget ?

**tf91** · 03-02-2012, 09:14 AM

Most likely end of the day....!

**hensucker** · 03-02-2012, 09:22 AM

As above this is required urgent! As by your Budget "snb" meant how much are you willing to spend to have the document created.
This is not a straight forward task, and depending on which direction you want to go the Best would be Excel Frontend and Database on the Back, excel from sheet to sheet without the copy function becomes very cluttered, slow and cumbersome.
So the question would be exactly what is required and should you need it so urgently how much can you part with to have someone create this for you?

And also Adhere to site rules your titles have to be about the project and not a demand.

**royUK** · 03-02-2012, 09:24 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST

**royUK** · 03-02-2012, 09:28 AM

This is a pretty big request in one chunk. I'm sure you'll get better response if you break down your question into several parts, so that they can be tackled one after the other.

Also, we're happy to help you with your effort, but nobody here will be keen on developing a solution from scratch. This forum is about helping people learn how to use Excel, not a free development service.

Have you started any work on this project yet?
How far did you get?
Where are you stuck?

We can help you develop your own code, but if you want someone to code this for you all the way, you should try and find a commercial developer.

**tf91** · 03-02-2012, 09:38 AM

I literally have no idea where to start in terms of coding. I have created the basic sheets, and have got thus far using the worksheet native functions. I was hoping perhaps there was a conditional copying formula that I could adapt to my needs, but again, the examples I have found are way over my head, and I wouldn't even know where to put any suggested code.

To those who object to my title - I apologise. As it says, this is urgent and I am under pressure at work to complete.

From the responses already, this task appears to be enourmous, and probably impossible on my deadline.