Help with learning to automate task at internship
I'm currently working on a project where I have an excel sheet of assembly numbers and I need to check if we have CAD files that correspond to that assembly number in our company server and then add yes, no, or maybe next to the assembly number in the excel document. This seems like something that could be automated rather than doing all manually, but I have no idea how I'd even get started trying to do that or even where to start to research if it's possible. Any advice on this would be greatly appreciated.
Posted Jun 6, 2023, 6:30 PM UTC
Move your CAD file #s on your company server to an excel document and then you can use vlookup or write a pretty easy script to automatically look for matches.
Also, chat GPT is pretty good at stuff like this if you can ask it the right questions.
Thanks for pointing me in the right direction.
DO NOT INPUT COMPANY DOCUMENTS OR ANY PRIVILIGED INFORMATION INTO
CHAT-GPT.
Yeah definitely don’t do that. I just meant asking GPT how to do things in excel.