Forum Discussion
How to make a formula result static
Hi Esat,
It does sound like you'd be better off with some VBA to copy and paste historic transactions as values into a table / database.
It's a difficult query to answer without spending a fair bit of time getting into the detail.
Could you add a date field to your customer pricing table (e.g. a new row with a new date each time the date changes) and then have your formula bring back the relevant price based on current date?
I could add a date and that would work perfectly for that single occurance, but there are many other possible changes that could cause problems hence why Im trying to find a way to at least make the record generated "static" or basically replace the formula with the answer. I guess pasting the value is the result im after, just how to get to it in an automated way is the issue.
- Unfortunately I'm not going to be able to help with this as it seems to be more of a project than a quick answer. Hopefully another kind soul on the forum can assist.
Sorry I can't help further.