Jan 16 2022 09:09 AM
Hi,
I have an excel file that I would like to be able to populate information from one sheet to another. I am using a Marco because it will have to use specific words (i.e. "Angel Monroe" technician name). I have multiple field technicians that I am trying to track specific jobs in separate sheets. For example on my master sheet I have a list of each job with multiple columns and different information. One of the columns list the technicians names, this changes per job, I would like to create a sheet for each technician that will auto-populate information from the master sheet when entered. I have attached the Excel file so you can see the Marco I have created. It continues to give me a "compile error: Invalid Outside Procedure".
I have been told that function "specific" might work but I do not know how to do the correct formula.
Can someone please help me troubleshoot a resolution to my issues?
Thanks!
Link to workbook: