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!
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 |