Steve Swift
Board Regular
- Joined
- Jan 18, 2004
- Messages
- 187
I have 3 worksheets. Sheet 1 contains the name of various sales people in column A, e.g. 'John Smith' and the Month of the sale in Column B, e.g. 'March'
What I want to do is create a seperate worksheet for each sales person and then fetch all of the information to that worksheet if the name appears on sheet 1.
In summary, Sheet 1 contains all the data Row by Row.
Row 1,5,13,22,44, Column A, contains the sales persons name 'John Smith'
Row, 2,3,4,6, Column A, contains the sales persons name 'Fred Smith'
All other rows contain the sales person with the name of 'Bill Smith'
In all cases, Rows Columns B through G contain other info I need.
All the other sheets are named with the sales persons name 'John Smith'
On the John Smith sheet in cell A1 I want to look up 'Sheet 1' and say, IF anywhere in Column A you find the name 'John Smith' then fetch all of the information from that row and put it in the next available row.
Hope someone can help.
Thanks
Steve
What I want to do is create a seperate worksheet for each sales person and then fetch all of the information to that worksheet if the name appears on sheet 1.
In summary, Sheet 1 contains all the data Row by Row.
Row 1,5,13,22,44, Column A, contains the sales persons name 'John Smith'
Row, 2,3,4,6, Column A, contains the sales persons name 'Fred Smith'
All other rows contain the sales person with the name of 'Bill Smith'
In all cases, Rows Columns B through G contain other info I need.
All the other sheets are named with the sales persons name 'John Smith'
On the John Smith sheet in cell A1 I want to look up 'Sheet 1' and say, IF anywhere in Column A you find the name 'John Smith' then fetch all of the information from that row and put it in the next available row.
Hope someone can help.
Thanks
Steve