Moving section headings from below section to above section..

**Fayebaline** · 02-22-2011, 04:27 AM

Hi everyone

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

Faye

**watersev** · 02-22-2011, 04:42 AM

hi, Fayebaline, can you post a sample workbook with original data and result you need to obtain?

**Fayebaline** · 02-22-2011, 04:56 AM

Hi watersev

Thanks for your reply. I hope I have attached the document correctly!

Faye

**watersev** · 02-22-2011, 06:05 AM

check attachment, run code "HeaderMover" being on Sheet "Original Data"

**Fayebaline** · 02-24-2011, 05:10 AM

Hi Watersev

Sorry i haven't replied - day off yesterday!

Thank you so much for that - it works a treat. Would love to understand the VBA though! Maybe one day i will be able to do it myself!
Thanks again

Faye

**watersev** · 02-24-2011, 05:22 AM

if you are happy with the outcome please mark the thread as solved (for details on How to see forum rules)

**Fayebaline** · 02-24-2011, 06:09 AM

Hi Watersev,

I was just testing it and have noticed that if the department is only 1 word rather than 2 it doesn't move it. Is there a way round this please?

Thanks Faye

**watersev** · 02-24-2011, 06:25 AM

you mean the department name is in two cells, right?

**Fayebaline** · 02-24-2011, 06:40 AM

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

thanks

Faye

**watersev** · 02-24-2011, 06:51 AM

check attachament, run macro "HeaderMover"

**watersev** · 02-24-2011, 06:55 AM

the first code works for any number of words as long as they are in column A, see attachment

**Fayebaline** · 02-24-2011, 06:58 AM

thanks for that - is works on all headers so great!
Faye

Moving section headings from below section to above section..

LinkBack

Thread Tools

Rate This Thread

Display

Moving section headings from below section to above section..

Re: Moving section headings from below section to above section..

Re: Moving section headings from below section to above section..

Re: Moving section headings from below section to above section..

Re: Moving section headings from below section to above section..

Re: Moving section headings from below section to above section..

Re: Moving section headings from below section to above section..

Re: Moving section headings from below section to above section..

Re: Moving section headings from below section to above section..

Re: Moving section headings from below section to above section..

Re: Moving section headings from below section to above section..

Re: Moving section headings from below section to above section..

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions