VBA - Matching specific date horizontally and insert value

[minhlac]

Hi all,

I found this forum very helpful so I sign up and this is my first post in this forum.

Please help! I have data as below, date from column D will keep going to the right (as a diary record).

	A	B	C	D	E	F	G	H	I	J
1	Item	Quantity	Delivery date	04/08	05/08	06/08	07/08	08/08	09/08	10/08
2	red	2	07/08				2
3	blue
4	yellow
5	pink	5	09/08						5

<tbody>
</tbody>

I would like to have a solution with Excel VBA carry out two tasks

1. For the example above, for item "red" when input delivery date and quantity then it will scan through row 2 for a matching date and leave the quantity at the intersecting cell of the same row looking up to that date column. Therefore we have the result 2 in cell "G2". In general, VBA will look up value (date format) in column C to match value (also date format) of any column from D onward, find the intersecting cell of the value current row and matched date column, then pick up value in column B (same row) and to insert in intersecting cell.

2. The intersecting cell value will stay as "text" only without formula format since column B and C will be dynamic changes based on user input.

I hope that would make sense.
Thank you in advance for your time.

 

[fhqwgads]

have a bump
i hope someone can help solve your problem