Macro to update cost value of sales transactions between 2 dates

[rajdeepkhurana]

Hi Experts,
Heres my query and thank you in advance for your help.

TABLE 1
===
I have a list of sales transactions.

Date	Item #	Revenue	Cost	Profit
17 feb 2017	568	$100	$70	30
18 Feb 2017	439	$120	$130	-10
01 Mar 2017	439	$150	$130	20

<tbody>
</tbody>

TABLE 2
===
I have another table that records the costs of each item.

Item #	Shipping Cost	Direct Cost	Total Cost
568	20	50	$70
439	80	50	$130

<tbody>
</tbody>

I currently use the Index and Match function to fetch the cost of the item # from Table 2


Here's the problem:
Due to changing market, lets say the the cost of procuring item 439 changes. My old profit should not change. How do i fetch the new cost in the subsequent transactions? In my current scenario, if I change the cost for item 439 in Table 2, profit in all previous transactions will change, which is not what i want.

Solution :
What I want is a macro where I input the start date and end date of the sales transactions. It would then update the cost only for those transactions. This way, my old transactions and their profit figures don't change. Can anyone help with this macro?

I would be open to any other suggestions.

Thank you so much!!