Phoenix - Your AI AssistantSimple Excel 2007 Macro to reorder text file
- Posted:
- Proposals: 3
- Remote
- #33343
- Archived
have already sent a proposal. Description
Experience Level: Intermediate
Our Excel file contains a list of courses and associated keywords. Each course sits in a Row in Column A with the keywords for the course in Column B - onwards.
What we need is a macro that will
1. Take the first keyword and put in Cell B1
2. create a new row in the spreadsheet
3. Add the course in Cell A2
4. Add the second keyword (in C1)
5. Move to Cell B2
6. Keep on moving keywords for the first course until all keywords have been moved
7. Move onto the second course in Cell A2 and repeat until all course have been done
Attached is an Excel sheet that show the before and after
What we need is a macro that will
1. Take the first keyword and put in Cell B1
2. create a new row in the spreadsheet
3. Add the course in Cell A2
4. Add the second keyword (in C1)
5. Move to Cell B2
6. Keep on moving keywords for the first course until all keywords have been moved
7. Move onto the second course in Cell A2 and repeat until all course have been done
Attached is an Excel sheet that show the before and after
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.