Matching Via Code

Topic

New Reply

I’ve got an excel spreadsheet with a column that has the date. We’ll call it Cows.xls, column D has the date in format mm/dd/yy.

I have another spreadsheet, we’ll call it Chickens.xls, Column D has numbers 1 through 31 representing the day.

How can I make the code recognize the date and put the data into the corresponding day #?

Reply | Quote

Replies

Drk:

I’m not quite sure what data you want to move in there, but see if the DAY( ) function applied against the Cows date gets you closer to where you wanna be.

Reply | Quote

[prep
Workbooks(“Chickens”).Worksheet(“Sheet1”).Range(A1).Offset(Day(Workbooks(“Cows”).Worksheets_
(“Sheet1”).Range(“D1”).Value)-1,0).Value = Data
[/pre]

Untested

Reply | Quote