Forum Discussion
Solved
Copy/paste new table in a new worksheet without error message
Hello,
I've created Table 2 using the FILTER and LET function on Table 1.
I want to copy/paste Table 2 in a new worksheet without Table 1 but Excel is displaying error message since the Table 2 is dependent on Table 1.
How do I "break" this dependence and make it possible to copy/paste Table 2 in a new worksheet without error messages?
Thank you in advance.
Select Table2 and copy it.
Activate the new sheet and select the top left cell of where you want to paste.
Click the lower half of the Paste button and select Values.
2 Replies
Select Table2 and copy it.
Activate the new sheet and select the top left cell of where you want to paste.
Click the lower half of the Paste button and select Values.
- It was much simpler than what I thought.
Thank you HansVogelaar for your help!
