oskar
New member
- Joined
- May 10, 2013
- Messages
- 24
- Reaction score
- 0
- Points
- 0
- Location
- Montreal, Canada
- Excel Version(s)
- Office 2013
I'm using Excel 2002, SP3 and I have a workbook with 10 sheets
The 1st sheet is an entry form where I type various activities (including the date) and the rest contain the summary of the various activities and are named Design, Materials, Purchasing, etc. All sheets have only 2 columns (Date and Description)
What I would like to do is when I enter an activity on the first worksheet which starts lets say with the word "Design" it should be copied to the Design sheet, and if the 1st word is Purchasing it should be copied to the Purchasing sheet, and so on
If lets say the Design sheet has earlier entries, the copied entry should be in the next empty row or it could be in the 1st row and I can manually sort the entries in chronological order
What would be the required formula?
The 1st sheet is an entry form where I type various activities (including the date) and the rest contain the summary of the various activities and are named Design, Materials, Purchasing, etc. All sheets have only 2 columns (Date and Description)
What I would like to do is when I enter an activity on the first worksheet which starts lets say with the word "Design" it should be copied to the Design sheet, and if the 1st word is Purchasing it should be copied to the Purchasing sheet, and so on
If lets say the Design sheet has earlier entries, the copied entry should be in the next empty row or it could be in the 1st row and I can manually sort the entries in chronological order
What would be the required formula?