How do I automatically pull a value from a cell in one sheet into another sheet?
Hi. I have two sheets:
Sheet 1 - a Work Order Submission Log
Sheet 2 - a Project Log
When a work order is submitted to Sheet 1, a Work Order # is generated in the Auto-Number column of that sheet. Each Work Order # is unique, but they all have the same suffix ("_wo").
I would like the Work Order # from Sheet 1 to automatically appear in Sheet 2, under the same column name. The criteria is merely that it exists: if it shows up in Sheet 1, it should show up in Sheet 2.
I assume I want to use a column formula, perhaps using the INDEX function with cross sheet referencing? Or can I set up cell linking to occur automatically? I can't seem to make any of my attempts work.
Thanks for any and all help!!
Help Article Resources
Check out the Formula Handbook template!