Renaming new worksheet using date and name

Hi Everyone,
I am having a issue writing a macro. See attached Excel file..I am trying to rename a worksheet with a date (Cell D1) and the first 5 letters of a name (CellB2) and then have the F2:F28 column transfer into another worksheet (Campbells!) based on the date (Cell A3:E3) Any help with this would be fantastic!!!!
Thanking you in advance
Matthew

Hi Matthew

I think the code below should help you towards acheiving your desired result.

Please Login or Register  to view this content.

Hi,
It renamed the new worksheet, but didnt transfer the data into the campbells worksheet....and wants to debug on the following line...
wsSum.Cells(3 + n, col) = wsMain.Cells(1 + n, "F")
???
PS I am using Office 2003 (Im not sure if that makes a difference for VB code?)
lol thanks for the quick reply though, that was awesome!
Matthew