Hi, I have an issue where the formulas in a Summary table becomes corrupt if I add or delete rows in the main data table. Is there VBA code to stop this happening? I have attached an example file (If you add a row in the main log table.....the summary table becomes corrupt)...... Hope this makes sense!!Test.xlsm
Put this into B5 of your summary log and paste down.
PUt this in C5 of your summary log and paste down.
Please Login or Register to view this content.
Please Login or Register to view this content.
The way you had it set up, the formula was using a direct data reference, so the formula was basically going to attempt to always track that data should it move.
The formula's above uses and index reference, so instead of the formula wondering where its reference went when it was deleted, it is now told to always look at that specific cell and to not try and follow the data in it.
Hope that makes sense.
Janos S. Vamos
Data Systems Technician/Fire Controlman PO1(SW/AW)
US Navy Retired
Remember, Record Macro can be your friend for figuring out solutions.
Good or Bad, let me know how I did by clicking on the "Add Reputation" * just to the lower left of here. it only takes a few seconds to let someone know.
Excellent........Worked a treat
Sorry for the late reply (vacation)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks