How do I add one cell of data once created into another sheet?
When a new row is created in Sheet A it is given an auto number. I then want to tell Sheet B that a new row has been added, or rather I want to show the new auto number in Sheet B. But only for rows where another column meets a criteria i.e. we log a certain name and so only want to send the auto number where the column has text "xx" in it.
In Sheet B the auto number will then be used in a data mesh between the 2 sheets....I just needed to get the unique identifier in each sheet.
Help Article Resources
Check out the Formula Handbook template!