Help a Newbie copy from one file to another

[lunchbox3]

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:

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

Thanks!

 

[stanleydgromjr]

lunchbox3,

Welcome to the board.

Please post examples of both sheets, and what your data will look like.

Post a screenshot of your sheet with Colo's HTML Maker.

[url]http://www.puremis.net/excel/downloads.shtml
[/url]

Have a great day,
Stan

 

[lunchbox3]

Here we go

Thanks Stan. Here is the evaluation sheet header, from which I need to copy the data in cell B2

electronicmonitoringtemplate.xls
	A	B	C	D	E	F	G	H	I	J	K	L
1	Project Name:		WB&A Market Research Monitoring Evaluation								Interviewer Initials:	_____________
2	Project Number:	085									Date:
3	Supervisor:										Start Monitoring:
4	Interviewer:										End Monitoring:
Sheet1

And here is the sheet I want to paste into.

08-2007 - August.xls
	A	B	C	D	E	F	G	H
1					Spreadsheet Key
2					WEEK 1
3					1-Aug	2-Aug	3-Aug	4-Aug
4	ID#	F NAME	L NAME		Wednesday	Thursday	Friday	Saturday
5
6	5110	name	name	0
7	5104	name	name	0
8	5180	name	name	1	085c
9	5201	name	name	1	085c
10	5098	name	name	0
11	5200	name	name	0
12	5196	name	name	0
13	5165	name	name	0
14	5125	name	name	0
15	5203	name	name	0
16	5204	name	name	2	095	095
17	5175	name	name	0
Monitor

Yeah basically I can't figure out how to have excel match todays date with the interviewer ID column (I think column A).

 

[stanleydgromjr]

lunchbox3,

These variables:
sID = Range("B4").Value
sProject = Range("B2").Value
do not seem to correspond to what is on the screenshot of Sheet1.

What cell address on Sheet1 corresponds to:
B2 = project code
B? = the person being interviewed?

How does the date in the third row, what column????, correspond to the Week # in the Monitor sheet?


What information from Sheet1, by description and cell address, do you want to copy, and search for in the Monitor sheet?

What date on Sheet1, description and cell address, do you want to search for in the Monitor sheet?

Please display Sheet1 for all the information (that is not confidential) that we need to work in the Monitor sheet.


Have a great day,
Stan

 

[lunchbox3]

stan - Thanks for the quick reply. Regarding the first sheet (the monitoring evaluation) in B2 I will enter the project code (the example is 085) and then in B4 I will enter their interviewer ID#. Then I would like those variables to be set and have excel search for the ID# variable, sID, in column A of the larger worksheet and todays date in row 3 (its hard to see in the post, it shows up black on here, you have to select it with the mouse to see the data).

I'm trying to copy the project # from the evaluation sheet to the larger monitoring sheet.

I would like it to search for the current date. The idea being that after people are done evaluating interviewers (which doesn't take more than one day) it can be pasted into the second sheet.