covlocks
New Member
- Joined
- Apr 11, 2020
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
I raise a standard worksheet record for each engraving order and would like would like to keep track of these orders on a collector worksheet
Many years ago I used a similar system to collect information on a workbook that contained hundreds of sheets referring to many different components on a design, but that knowledge has drifted away in time, not having used vba for many years.
The 'indirect' command doesn't work for me, so I am hoping an excel wiz can help me please. Column A is obviously a worsheet/JobNumber which will just stay in the same format, pulling in info from the same cells on each sheet.
Without copying and editing 100's of cells, I would just like column B> just to pull in the information from the sheet name in column A.
Any help would be brilliant.
Many years ago I used a similar system to collect information on a workbook that contained hundreds of sheets referring to many different components on a design, but that knowledge has drifted away in time, not having used vba for many years.
The 'indirect' command doesn't work for me, so I am hoping an excel wiz can help me please. Column A is obviously a worsheet/JobNumber which will just stay in the same format, pulling in info from the same cells on each sheet.
Without copying and editing 100's of cells, I would just like column B> just to pull in the information from the sheet name in column A.
Any help would be brilliant.