I have sheet called ’ contact’ that listed all my clients and suppliers. But now I really want to seperate the client and suppliers into 2 different sheets. Is there a way to achieve this real quick, like duplicate the ’ contact’ sheet include all the entries, take it for ‘client’ sheet and delete whatever suppliers entries inside that sheet?
1 Like
Hi there,
If you’d like the client and supplier data to remain in the same underlying sheet structure and stay in sync, you can use Multiple Versions. Simply apply a fixed filter in each version to display either clients or suppliers.
However, if you prefer to completely separate the data, without the data being synced, and manage clients and suppliers in different sheets going forward, please refer to this guide on copying a sheet along with its data. When importing into the new sheet, make sure to include only client or supplier entries as needed. After that, you can go back to the original sheet and delete the entries you’ve already moved.
Hope this helps!
2 Likes
I managed to copy the sheet and add entries manually since there’s not that many.
Thank you for the instructions.
1 Like