Hello!
I have made a template of sorts in excel to help organize files for the office. The top of the template spreadsheet has a place for a Name, Employee ID, address, company, Job Title, and Date of Hire. The second half of the template is where I will put elections that employee has made.
In order to save time, I have pulled a report that will show all the first information in list form. Column A is Name, Column B is Employee ID, etc)
Is there a way that I pull all the data from the second list into the template automatically, instead of me copying and pasting the info?
I wish there was a way for me to attach my file so you could see it. Please let me know if I have given enough information to help understand.
Thank you!
Thank you!
[/IMG]
I have made a template of sorts in excel to help organize files for the office. The top of the template spreadsheet has a place for a Name, Employee ID, address, company, Job Title, and Date of Hire. The second half of the template is where I will put elections that employee has made.
In order to save time, I have pulled a report that will show all the first information in list form. Column A is Name, Column B is Employee ID, etc)
Is there a way that I pull all the data from the second list into the template automatically, instead of me copying and pasting the info?
I wish there was a way for me to attach my file so you could see it. Please let me know if I have given enough information to help understand.
Thank you!
Thank you!
