How can i edit historic formulas from Excel table?????

[daleholden]

Hi Guys


I am having a real issue with a spreadsheet i run which has a sales table that does a vlookup to two other sheets.
It also has a a vba modules in it for keeping sold prices in static.


After a few weeks of running it one of the vlookups was wrong from 1 sheet.


I have got the correct formula now but the table keeps remembering the old onemptied


So in essence if sell an item from one sheet the vlookups correct but if the item is on the other sheet i have to edit the formula so it is right.


This affects 3 cells.


Is it possible to edit historic formulas in Excel tables so it does not remember old ones and i can use my new ones.




In F Correct formula is =IFERROR(VLOOKUP([@SKU],ResearchStock[#All],6,0),IFERROR(VLOOKUP([@SKU],Ownstock[#All],6,0)*[@[Items Sold]],"No Price Listed"))

Excel is currently giving me =IFERROR(VLOOKUP([@SKU],ResearchStock[#All],6,0),IFERROR(VLOOKUP([@SKU],Ownstock[#All],8,0),"No Price Listed"))

In H Correct formula is =IFERROR(VLOOKUP([@SKU],ResearchStock[#All],10,0),IFERROR(VLOOKUP([@SKU],Ownstock[#All],11,0)*[@[Items Sold]],"No Price Listed"))

Currently giving me =IFERROR(VLOOKUP([@SKU],ResearchStock[#All],10,0),IFERROR(VLOOKUP([@SKU],Ownstock[#All],10,0),"No Price Listed"))

In I Correct formula is =IFERROR(VLOOKUP([@SKU],ResearchStock[#All],12,0),IFERROR(VLOOKUP([@SKU],Ownstock[#All],14,0)*[@[Items Sold]],"No Price Listed"))

Excel currently giving me =IFERROR(VLOOKUP([@SKU],ResearchStock[#All],12,0),IFERROR(VLOOKUP([@SKU],Ownstock[#All],13,0),"No Price Listed"))

As you can see it is column positions i just need to know how to fix this please

Dale

 

[mole999]

if the formula keeps reverting it seems to me that the book has code that fixes deletions

 

[daleholden]

Hi guys

I have gone the long route created a new sheet which now works. I thought spending hours trying to fix was not time efficient.