VBA/Macro help

[paleaux]

Ok I have a multi sheet workbook that Iam trying to populate the main sheet "Timesheet" with data from another sheet called "Gate Log"
The Gate Log sheet will change everyday and perhaps even twice a day.

"Timesheet" (Contractor Name) B2:B300 needs to be populated with data from sheet "Gate Log" (Company Name) A2:A300

"Timesheet" (Employee Name) C2:C300 needs to be populated with data from sheet "Gate Log" (Name) B2:B300

"Timesheet" (Date) D2:D300 needs to be populated with data from sheet "Gate Log" (Work Date) D2:D300

I would be very appreciative to anyone who can lead me in the right direction. I am not very up to speed on vba but trying to learn everyday.
Making some progress but not nearly as quickly as I would like.

Thanks to all...

 

[kpark91]

Hi,

Sub Test()
    Worksheets("Gate_Log").Range("A2:B300").Copy Worksheets("Timesheet").Range("B2")
End Sub

Your Gate Log worksheet name is invalid because it has a space while excel does not allow it.
The above code will copy A2:B300 from Gate log to B2:C300 of Timesheet.
The D2:D300 can be copied in a similar fashion.

 

[paleaux]

Getting Run-Time error '9' Subscript out of range

Thanks for the help...

 

[paleaux]

Never mind got it..

Thanks,