Trying to automate a spreadsheet report.

Hi guys another question,

This is what im try to do, i have a spreadsheet that shows me how much fuel my engineers have spent over the year, and another spreadsheet i recieve from esso to tell me there monthly spend, at the moment i have 200 engineers and what happens is one of my admin has to manually cross check the two reports and copy the information over but as there is over 200 entrys its taking her to long is there anyway of automating this.

Ive attached an example of how the two sheets look ive put them on one workbook using sheet 1 and 2

so what should be done there? what is being copied where and why?

hi,
welcome to the board,

when you are posting a question try to be more specific about the requirement. i went through the whole sheet but couldnt figure out what the requirement is.

Sorry Guys fair point, an example would be sheet 1 J3 needs to be copied to sheet 2 M5

but this is just a little example theres a lot to copy across and theres a new report each month so this is then a monthly task. does that make a little more sense, sorry i know im terrible at explaining things.

see attachment, run macro "Monthreport"

Excellent, thank you for that, ive just read the macros and its way over my head but its definatly something i need to spend time on to learn

i spoke to soon, it works on the example but doesnt on the full report, as there are some that the data moves across and some that is putting in data for techs that have left the business and not on the esso report

I think the problem is that the macro does not take into account that there are techs with no spend in that month because of holiday or if they left have left the business.