Hey everyone - I'm trying to teach myself VB while I go , but I figured its time to ask for some help. I'm trying to create a performance evaluation form that automatically copies data to another larger form. Specifically, I have one cell into which I enter the project for which the employee was reviewed. I would like the information from that cell (project number) to be automatically written to the overall spreadsheet that charts how many times in a month the employee has been reviewed, and what project it was. I am currently storing the project number as a variable, and I can get the part where I have it written to a cell. But I need help with code that will search for todays date in the 3rd row, and then also search for the employee ID# in the first column. Then where those two intersect, plant the project number. This is just a first first draft of what I have:
Thanks!
Code:
Sub test()
Dim sProject As String
Dim sID As Value
sID = Range("B4").Value
sProject = Range("B2").Value
Workbooks.Open Filename:="\\Dkurzweil-xp\shared documents\Monitoring Spreadsheets\2007\08-2007 - August.xls"
End Sub