Jan 13 2022 03:26 PM - edited Jan 13 2022 03:34 PM
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 Trujillo" 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".
Can someone please help me troubleshoot a resolution to my issues?
Thanks!
Jan 13 2022 03:37 PM
Jan 13 2022 03:43 PM - edited Jan 13 2022 03:50 PM
See below for link to the file.
That is exactly what I would like to do! I figured I had to create a Marco to complete the command. Can you maybe help walk me through setting up the function instead?
File Link:
Jan 13 2022 03:47 PM
Jan 13 2022 05:25 PM
Jan 13 2022 05:26 PM
Jan 14 2022 12:10 PM
Sorry about the error, I think I have fixed it but let me know if it still does not work. Thank you very much for your patience, I greatly appreciate it.
See the updated link below:
Jan 16 2022 11:16 AM
SolutionJan 19 2022 06:52 AM
Jan 16 2022 11:16 AM
Solution