Sending data from input sheet to other sheets in a workbook?

**Si902** · 12-11-2009, 06:27 AM

Hi everyone

I'm a relatively new forum member and this is my first post.
Thankyou in advance for taking the time to read my post.

Hopefully one of you excel gods will be able to assist me.
I have searched through the forum and am unable to see anything on what i am trying to acheive.

I am trying to set up a new workbook for my home accounting, this will consist of a seperate sheet for each item which will store the monthly payment data and a master data input sheet, where i intend to select the month and year from a drop down list, then input the amount in each entry for that month. hopefully i will then be able to hit enter and all data will be sent to its corresponding position in its relevent sheet.

I hope that makes sense, i have used some formula etc in the past but this i think is a bit beyond me.

I have attatched a copy of the workbook as it stands so far for your info.

Thanks again in anticipation.

Si.

**davesexcel** · 12-11-2009, 08:36 AM

Here is your sample back, click the button to run the macro, some of the Worksheet Names do not match the items in the column so you will have to fix that.

**Rahul Nagar** · 12-11-2009, 09:29 AM

Hi Si902,

Please check the attached file.
You can use this also.

This is only for suggestion.

**davesexcel** · 12-11-2009, 09:55 AM

Hi Rahul Nagar

I think he was asking for the data in the Input Sheet to be placed into the appropriate worksheets., kind of reverse of what you have supplied.

**Rahul Nagar** · 12-11-2009, 10:01 AM

Ohh yes

you are right, I am little bet confuse.

**Si902** · 12-11-2009, 10:17 AM

Dave

Thank you so much for that, it works perfectly!

Your right it didnt work on certain pages at first because the spelling was not exactly the same, i corrected this and it now works brilliantly.

Are there any pointers you can give me on how to start to learn VBA from a begginers point of view, where should i look?

Thanks again.

Simon.