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