Sorry if this is a bit confusing or if I’m not explaining this well enough. Using my provided picture as an example how would one auto copy data that gets inputted into that table based on estimated rates vs actual rate tables?
For example, in rows 13-15 you can see the estimated rates are extremely off in comparison to the actual rates. But in rows 6-10 the estimates are almost spot on. How would one auto copy that data & paste it into a new sheet depending on close matches / inaccurate matches?
Would it be possible to just auto copy the data based on accurate estimates / inaccurate estimates? Essentially I would be looking to just have it be so that when someone inputs the necessary data into the spreadsheet it will just automatically copy itself into a new page depending on if it falls into one of those parameters?