Help with VBA

[Russk68]

Hi All
I need an automated method of replacing a formula when a change in a specific cell is made. I have been using a VBA method of double clicking in a cell to replace a formula. I have many layouts like this that consist of 12 rows. The next layout would be 14 thru 25. Column A and B are Index,Match formulas.
Sometimes column B needs to be overwritten. Lets say B5 is overwritten.
Sometimes the truck # might change. If it does, I need B5:B12 to update but B5 has no formula. I would then double click in B5 and the formula would be replaced. This is fast but it's not fail safe.
Is it possible to have the formulas in B5:B12 replaced with VBA when A2 changes? And the repeat for each layout.

B5 Formula: =IFERROR(INDEX('Patch By UNIVERSE'!$BH$3:$BH$5000,MATCH(AY5,'Patch By UNIVERSE'!$BG$3:$BG$5000,0)),"")

This would be awesome!

Thank you!

	A
2	Truck 1

	A	B
4	Label	Item
5	Crate 1	Apple
6	Crate 2	Orange
7
8
19
10
11
12

 

[Russk68]

The problem with using calculate is that it can change some manual entries to formulas prematurely because almost any change will trigger the calculate event. I cannot think of a way to confine the event to just certain columns on specific sheets.

I see
I will have to rethink my layout.

Thank you for your time!