I have a group of 16 people. I am trying to take a large spreadsheet, 30 columns and eventually several hundred rows and trying to automatically copy each persons input from the master sheet to individual worksheeets only when their specific information is in one column.
The master sheet is updated weekly and rows added as information is input.
Can this be done.
Copying rows from one master to sheet to different worksheets