Forum Discussion
Data in Sheet 1 to Sheet 2 if meets criteria in Sheet 1
This may be fairly straight forward, I'm hoping so! I have data in Sheet 1: Names in Column A, Program Code in Column B. I need Sheets 2 - 12 to take any Names from Sheet 1: Column A to populate into...
If you have Microsoft 365 or Office 2021, you can use the FILTER function.
See the attached version.
HansVogelaar Thanks for your help. I attempted the Formula but didn't work, just lots of dinging from the machine. I do have Office 365. I appreciate your help! I'll mess around with the Filter function more.
Does it work for you in the sample workbook? I had to convert the tables on the second and following sheets to ordinary ranges.