Date Copy and column adjust macro
 

Hi All,

I'm having alot of trouble with this macro - please keep in mind i a
relatively new to VBA programming. I would really appreciate any help
can get with this code, as it is the second last piece of code t
complete my project.

I need the copy to take a start and end date (which are usuall
mondays) which a user has input and calculate the amount of week
between. It then needs to change the dates to a monday.

It would be easy if i could then just put the start, end and middle
dates straight into headings for a sheet, but i seem to keep gettin
mismatched data values even though the dates are formatted the same. S
i thought a work around would be to copy the corresponding cells fro
another grid and paste them into the table header.

If this is confusing (which I'm sure it is because i'm writing thi
quite early in the morning, please take a look at my excel shee
attached as it should explain what im after much better.

Thank you for your help!!!!!!

:mad:
Sam

+-------------------------------------------------------------------
|Filename: datecopy.zip
|Download: http://www.excelforum.com/attachment.php?postid=3797
+-------------------------------------------------------------------

--
Sami8
-----------------------------------------------------------------------
Sami82's Profile: http://www.excelforum.com/member.php...fo&userid=2711
View this thread: http://www.excelforum.com/showthread.php?threadid=46628