VBA to sum and clear contents

[Thomas_85]

Hi Guys,

I was hopeful someone could help me out with a Macro I am trying to build.

Here is what I am trying to achieve (there are 3 main sections):

1)

• Subtract "D5" from "H2" and put the answer in "I5"
• .....Then add "I5" with "J5" and put the answer in "K7"
• .....Then take the final answer in "K7" and put it into "D7"

2)

• Clear contents of "H5" and "J5"

3)

• Update the date in cell "B3"

(And I need to do this in 1000 rows of data)

Any ideas guys? I have pasted the data below and would really appreciate any help (I need it! )



A B C D E F G H I J K
[TABLE="width: 1038"]
<colgroup><col><col><col><col><col><col><col><col><col span="2"><col></colgroup><tbody>[TR]
[TD]1
2
3 Last updated[/TD]
[TD] 7/29/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4 WHSE[/TD]
[TD]PART NUMBER[/TD]
[TD]PART DESCRIPTION[/TD]
[TD]Quanity on Hand[/TD]
[TD]BINS[/TD]
[TD]MIN[/TD]
[TD]MAX[/TD]
[TD]Used[/TD]
[TD]Total[/TD]
[TD]Received[/TD]
[TD]Grd. Total [/TD]
[/TR]
[TR]
[TD]5 RRR4[/TD]
[TD]103815001[/TD]
[TD]STRIP, PRESSER 10X86[/TD]
[TD]4[/TD]
[TD]1L01[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]5[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]6 RRR4[/TD]
[TD]205629011[/TD]
[TD]STRIP (5P-88 MM FOIL)[/TD]
[TD]1[/TD]
[TD]1L01[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD]1[/TD]
[TD] [/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

 

[Thomas_85]

For some reason the column letters all moved over to the left hand side when I inputted them into the thread, I apologize. I'm working with columns "A:K"

 

[Thomas_85]

Any idea on how I could go about this guys? (examples of code?)