Macro tweak to ignore header row. +macro to copy from one sheet to another

Hi


Can somebody tweak the macro called “convert” which is in module 4 to ignore the header row of sheet called “2011” and only copy over everything from row 2 downwards to the results sheet? The problem is there is a bug as it is for the time being. Sometimes it takes the header text to results sheet and sometimes it won't take the header text to results sheet. It's usually when I have run the macro “test” which in module 3 more than once and then running macro “convert” in module 4. It then produces a result without header text. So maybe it's easier to ignore that header row and not to bring that header row to results screen at all. Now comes the second part. Can you create me a macro that clears everything on sheet “2011” row 2 downwards, then takes everything (from row 1 to downwards) from sheet “Results” and places them to back to sheet “2011” row 2 downwards. So the header row that is still intact and is nicely there.

Anyone can help but I think watersev might help me out as he is familiar with these macros in question.


Cheers

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.