G
Guest
I have several application workbooks that use a 2 sheet approach.
Sheet 1 is designed for end user input. It is pre-formatted and allows the
end-user to input only the pertinent data
Sheet 2 is very structured with very specific formulas. Its purpose is to
recalculate and rearrange the data for a specific inport into another program.
Everything works great until the end user uses cut and paste to move data
that was incorrectly entered on Sheet 1 which creates #REF! errors on Sheet 2
whereever the data was moved.
I have used both absolute and realative referenced formulas with the same
result.
Any suggestions?
Sheet 1 is designed for end user input. It is pre-formatted and allows the
end-user to input only the pertinent data
Sheet 2 is very structured with very specific formulas. Its purpose is to
recalculate and rearrange the data for a specific inport into another program.
Everything works great until the end user uses cut and paste to move data
that was incorrectly entered on Sheet 1 which creates #REF! errors on Sheet 2
whereever the data was moved.
I have used both absolute and realative referenced formulas with the same
result.
Any suggestions?