Anton Jansen
New Member
- Joined
- Jun 16, 2014
- Messages
- 41
I have a master Workbook (Quotes) consisting of about 12 columns (and numerous rows) in which various information is recorded by eight sales people. Once a quote has been entered into the master Workbook, I would like to record the new data in column C,D,E and F into a new Workbook automatically for each sales person. Only the four columns from the master will be recorded in the new Workbooks. Column C in the master indentifies the sales persons initials and the information will be transferred to that persons 'own' Workbook. In other words there will be the master and eight other Workbooks, one for each person. The new Workbooks could have the filename of e.g. ABQuotes, GBQuotes, RSQuotes and so on. Could someone please help me with some of the code on this?