My team has a 2 page document they use
- Book 1 - external, sent to the customer, no pricing or anthing linked.
- Book 2 - Internal version, linked to pricing, not sent to customer.
Essentially, I would like them to be able to hit the "select all" in the top left corner, copy the customer version, and then paste all into the internal version. However, the internal version has other information, in areas that are blank on the customer version. I do not want these overwritten with blank cells.
Is it possible to limit the customer version's rows and columns, so when they select all, I can determine the range of "all". That way they will only paste the range I want.
If not, I will just teach them all about carefully copy and pasting the range but I'd rather keep it simple.
Bookmarks