Hi, I have a table of data in tab "All Open" in the attached google sheet. Can someone tell me if its possible and how to write some script to sort the data by area and copy that data to the correctly named area tab.
There is a tab called plant list which list the plant number in column B next to the geographic area its in in column A. What i want is for some script to search is to search in "All Open" tab and match plant number and then copy the sorted data to the correct area tab. I can do this in excel using VBA but am new to google sheets and was hoping something similar was possible. https://docs.google.com/spreadsheets/d/1D1B__Vnc69xX8n_KEy_7iEAa4h_N7fapPepNotEpXJ8/edit?usp=sharing -- ------------------------------ This email communication may be intercepted for regulatory, quality control, or crime detection purposes as per the UK Government Regulation of Investigatory Powers (RIP) Act. This message is intended only for the use of person(s) ("the Intended Recipient") to whom it is addressed. It may contain information that is privileged and confidential within the meaning of applicable law. Accordingly any dissemination, distribution, copying or other use of this message or any of its content by any other person may constitute a breach of civil or criminal law and is strictly prohibited. If you are not the Intended Recipient please contact the sender as soon as possible. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of Lafarge Tarmac Limited. -- *Lafarge Tarmac Limited* Registered in England and Wales No. 08197397 Registered Office: Portland House, Bickenhill Lane, Solihull, Birmingham, B37 7BQ *Lafarge Tarmac Cement and Lime Limited* Registered in England and Wales No. 66558 Registered Office: Portland House, Bickenhill Lane, Solihull, Birmingham, B37 7BQ *Lafarge Tarmac Trading Limited* Registered in England and Wales No. 453791 Registered Office: Portland House, Bickenhill Lane, Solihull, Birmingham, B37 7BQ -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
