#### peter.abing

##### New member

- Joined
- Oct 24, 2012

- Messages
- 34

- Reaction score
- 0

- Points
- 0

Hi everyone,

I am an intermediate user of Excel. I know a little about Macros and I know how to use most of the formulas in Excel.

I want your help in a certain spreadsheet for reporting purposes.

Please see illustration in the attached Excel file.

The spreadsheet contains a list of employees and the projects where they have worked for a certain period.

What I want to do is sort the list of employees and insert a spacer (row) between each employee.

If possible, the row will be formatted.

I know this is possible with Excel because anything is possible in Excel.

I just don't know how to code this in VBA.

Thanks,

Peter

I am an intermediate user of Excel. I know a little about Macros and I know how to use most of the formulas in Excel.

I want your help in a certain spreadsheet for reporting purposes.

Please see illustration in the attached Excel file.

The spreadsheet contains a list of employees and the projects where they have worked for a certain period.

What I want to do is sort the list of employees and insert a spacer (row) between each employee.

If possible, the row will be formatted.

I know this is possible with Excel because anything is possible in Excel.

I just don't know how to code this in VBA.

Thanks,

Peter