enter data onto report

Hi. I have a query and i am not sure if this can pulled off using vba so i'll post it for some advice. I have an attached file. On this file, on the first tab named, Data Entry, I have 6 fields to key in. They called named Site, Type (Between Electricity and water) Year, Month, consumption and rate. There is a 7th field called costs but i am using an auto sum to enter the data. Upon entering of the data. I require the data to be entered into the respective tabs by site first then search by type, then to find the range of the year and the month an then enter the data of consumption, rate and costs. I am not sure if this is doable and i have input a sample on the file or illustration purposes.

How about

Please Login or Register  to view this content.

This needs to go in the "Data Entry" sheet module & will automatically enter the data onto the relevant sheet when you change the value of B18 on the Data entry sheet

Hi Fluff13. Thank you for the response with the code. I pasted it onto the module and it didnt seem to show the data on the respective tab. I have attached the report.

I misunderstood your layout, try

Please Login or Register  to view this content.

Hi. I have pasted the revised code and have not managed to get the data over. Did i like did an incorrect step on my attachment?

That workbook still has the original code, rather than the revised code in post#4

Hi. Sry. I attached the correct worksheet and i got a debug error on this line.

Please Login or Register  to view this content.

In your Sample 7 the previous workbook you typed in "Electricity", this time you have "Electric".
To deal with that use

Please Login or Register  to view this content.

Hi Fluff13,

I wan't able to get the code run after changing the line given. Should I paste this code on the module instead.

The code works for me in your test file.

Hi Fluff13

I got it. When i pressed enter on the cells without keying in any new data. It doesn't override the previous data to enter. Can i put in a trigger button to enter the data in.

Do you mean that when the data is copied over you want the data on the "data entry" sheet to be removed?