Hello!
I am completely lost. I have scoured the internet trying to figure things out but I cannot.
I need to review documents and create a spreadsheet based on the documents. I will have different columns on the master sheet -- column A is the document number; B is the document name; C is the date; D includes all of the people associated with the document.
D will include multiple people. For simplicity, let's just say Paul, George, and Jack.
I need to create separate spreadsheets based on the people associated -- so if Paul is associated with the document on the master sheet, I need all of that information to automatically populate into Paul's separate spreadsheet.
Is there a way to do that? Also, I'm not sure what would be the easiest way to do that since there will usually be multiple people associated with a document on the master sheet. Should I list the names under each other, all in column D or what?
Any help would be greatly appreciated. Thank you.
I am completely lost. I have scoured the internet trying to figure things out but I cannot.
I need to review documents and create a spreadsheet based on the documents. I will have different columns on the master sheet -- column A is the document number; B is the document name; C is the date; D includes all of the people associated with the document.
D will include multiple people. For simplicity, let's just say Paul, George, and Jack.
I need to create separate spreadsheets based on the people associated -- so if Paul is associated with the document on the master sheet, I need all of that information to automatically populate into Paul's separate spreadsheet.
Is there a way to do that? Also, I'm not sure what would be the easiest way to do that since there will usually be multiple people associated with a document on the master sheet. Should I list the names under each other, all in column D or what?
Any help would be greatly appreciated. Thank you.