I am doing a new project to track the sales. I want to write formula to copy data to another sheet based on a cell value. Can’t write a VB script as this needs to run Office 365.
main.JPG
Based on the above table
I want to copy the entire row (or selected columns) if the last (S4) cell value is 4x4 to the "4X4 sheet" or "Used cars sheet" if the last cell (S4) value is used cars
I googled this but still can't find a way to write a formula.
Thanks in advance
Bookmarks