Copying columns to additional sheets
I have a sheet where information is submitted using a form. When a row is added, a unique identification number is attached to that row. I have separate sheets that are used for the investigation into the incidents/hazards reported in the form/rows. I would like some of the columns to be automatically copied across into those additional sheets (please don't suggest ctrl C!!!!!!). I could use the option of 'link cell from another sheet', but would really like it to be automated. Does anyone know if this is possible? if it is, what formula can I use?
Help Article Resources
Check out the Formula Handbook template!