Copy cells to next empty column

Hi
1: I would like a macro or vba to copy a range of cells to the next empty column, however all the columns do have a heading!

2: I would then like a macro or vba to copy the last populated column to a pre specified column on sheet 1

Please see attached file

Many thanks

My apologies, I changed things around and never checked it, and i am rubbish at explaining things like this on paper sorry.

Please see attached file

1: Copy Sheet2 B4:B18 to the next empty column on sheet2 (column D)and paste values only as column B are results of formulas.

2: Copy last populated column on sheet2 (Column D)and paste to B2 on sheet1

I would like items 1 & 2 as separate procedures.

Originally Posted by Richard Buttrey

I think this must be to do with Excel trying to do the best it can with your data and it determining that with the size of the chart and the size of the x axis font it isnt possible to show every date without overlapping the dates making them unreadable.

I say this because if you change the font size of the axis to say 5 (which makes the dates too small to read) and then zoom the sheet to say 200% you'll see that the axis does show all dates in sequence.

Wrong thread I think lol.