Moving section headings from below section to above section..
I am new here so sorry if I don't explain myself fully! I'll do my best..
I am working on a macro that manipulates data in Excel. The data consists of payroll number (column A), Name (B), Day worked (C) and hours worked (D), however after so many people the name of the department they worked in appears in column A on a line of its own, then the next departments staff details start, again followed by the name of their department.. What I need to do is move the department name from below each section of staff to above them. The number of staff in each department and the number of departments may vary from week to week.
Could anyone please help?
Sorry if you need anymore information! Just ask and I will try to explain more..
Thanks for your help inadvance
Last edited by Fayebaline; 02-24-2011 at 07:01 AM.
Reason: Solved - thank you!
Re: Moving section headings from below section to above section..
Sorry maybe didn't explain myself. On the spreadsheet that i attached all of the Departments had 2 words within column A, but if there was to be a department that only had 1 word e.g. Manufacturing rather than Cylinder F, then the code doesn't pick these up