Macro for copying value to specific cells

[Ivica1987]

Hello

Since I don't use much Excel Macro I will need help with a VBA Macro for Excel. What I need is to copy a specific value from the 5th row (the Main Value) depending which month it is (cell K1). As an example: if the month is equal to number 9 then it will copy the value from the cell for September (cell AD5: 125068) to the column D for each of the three employees (the orange fields).

I can maybe solve this with normal formulas and with the VBA function for recording, but it could happen that next month the number of employees is different and so the recorded macro wouldn't work. Also, I will need something that works on multiple sheets since every table in every sheet has the same layout.

Here is an example.

Thanks in advance and best regards

 

[Muhammad_Usman]

Same value you want to paste in column D . 125068 in three cells ??

[TABLE="width: 500"]
<tbody>[TR]
[TD]Max Muster[/TD]
[TD]125068[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Peter Peterson[/TD]
[TD]125068[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Christian Christianson[/TD]
[TD]125068[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Ivica1987]

Yes, exactly like that.

 

[shreif]

put this formula into cell d7 and just confirm it with CTRL+SHIFT+ENTER then drag it to cell d9

=INDEX($F$5:$AO$5,MATCH($K$1,MONTH($F$4:$AO$4),0))

hope that helps

 

[Muhammad_Usman]

<embed width="440" height="420" type="application/x-shockwave-flash" src="http://v9.tinypic.com/player.swf?file=n2g3go&s=9">


CTRL+SHIFT+ENTER

Formulla = =INDEX($F$5:$AO$5,MATCH($K$1,MONTH($F$4:$AO$4),0))

 

[Ivica1987]

Sadly it didn't help much. Excel is showing me an error (Value error). I tried it on english and german versions of Excel.

 

[shreif]

Sadly it didn't help much. Excel is showing me an error (Value error). I tried it on english and german versions of Excel.

are you sure you confirmed it with
CTRL+SHIFT+ENTER

 

[Ivica1987]

I did. It still shows an error.

 

[shreif]

please share your excel file.

 

[Ivica1987]

Here is the german version including the formula between D7 and D9.
Link.

Regards