Macro to copy values to a new sheet

[BeerKing]

Hello.

I have a workbook with which I keep track of my personal economy, and I have several sheets to do that. What I basically need, is that I have a sheet for each month, where I want to compare my budget with the actual events, so I need to copy the actual income and expenses to a new sheet.

I've attached a file to show what I want to do.

In the sheet called AccountsDebet I have 2 date columns, A showing the date in date format, and B showing it as integer. I want a macro to look at column B and within a specific range, e.g. 40544 to 40574 for January, it should (e.g.) take the number at offset 0,17 and copy that number to sheet CompareJanuary and make it cell C4 value, it should (e.g.) take offset 0,22 (in AccountsDebet) and copy that value (if any) to cell G4 in CompareJanuary, and e.g offset 0,46 to cell G10.

I can't really figure out whether I should use if-then or select case ((or a third option :-) Yes I'm a VBA rookie)


Thanks in advance