Simple Excel 2007 Macro to reorder text file

  • Posted:
  • Proposals: 3
  • Remote
  • #33343
  • Archived
Nadia N.Andy O.Lex H. have already sent a proposal.
  • 0


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

New Proposal

Create an account now and send a proposal now to get this job.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.