Brooks70459
New Member
- Joined
- Jun 25, 2009
- Messages
- 43
I hope that I am explaining this correctly.
I am about to audit a factory. I am building a standard form in an Excel workbook to collect the data. I will initially have fifteen workbooks. Each workbook will represent a specific area in the factory. Each workbook has about fifty worksheets, each a different (sub)assembly.
What I would like to do is make a template that would have a function that would populate a cell in (let's say Column G) with its respective worksheet tab name. It would be nice to this automatically occur when data is entered into Col. C the same row.
Your help is appreciated.
I am about to audit a factory. I am building a standard form in an Excel workbook to collect the data. I will initially have fifteen workbooks. Each workbook will represent a specific area in the factory. Each workbook has about fifty worksheets, each a different (sub)assembly.
What I would like to do is make a template that would have a function that would populate a cell in (let's say Column G) with its respective worksheet tab name. It would be nice to this automatically occur when data is entered into Col. C the same row.
Your help is appreciated.