Search and Update - Using a Ref. to locate and update info.

V

vamosj

Here is what I am trying to do. I have created a spreadsheet that keep
track of movies (around 512 of them) and the I am trying to figure
way to update the last time they were played. I currently have
master list of the movies which will hold the "Last Played" Date.
also have a weekly schedule that I print out which has the day they ar
playing. What I was trying to accomplish is, using a
ActiveCell.Offset (Or if anyone knows a better way) line to take
movie on the weekly schedule, Find it in the Master List, Then take th
Date just to the left of it (Weekly Schedule) and paste it into th
cell that contains the "Last Played" Date on the Master List. Pleas
help before this lump on my head gets any bigger. :)


Thanks
 
J

Jonathan Cooper

So, if I understand your situation, it should be very simple

=VLOOKUP('weekly schedule'!A1,'Master List'!$A$1:$B$512,2,FALSE

This looks at the movie title in cell A1, looks it up on the master list, and returns the date in column 2 of the master list

----- vamosj > wrote: ----

Here is what I am trying to do. I have created a spreadsheet that keep
track of movies (around 512 of them) and the I am trying to figure
way to update the last time they were played. I currently have
master list of the movies which will hold the "Last Played" Date.
also have a weekly schedule that I print out which has the day they ar
playing. What I was trying to accomplish is, using a
ActiveCell.Offset (Or if anyone knows a better way) line to take
movie on the weekly schedule, Find it in the Master List, Then take th
Date just to the left of it (Weekly Schedule) and paste it into th
cell that contains the "Last Played" Date on the Master List. Pleas
help before this lump on my head gets any bigger. :)


Thanks
 
V

vamosj

Thanks for the assistance. Before reading your reply I was able to com
up with a solutions.

I had 4 movies playing per day and what I did was make a copy of th
weekly schedule on a "Workspace" Worksheet. Copying the days date i
is being played just to the left of it. I figured that saving th
movie title as "i" allowed me to use a loop until it found it on th
master list then I offset it on the worksheet to copy the date the
offset it on the master list to paste it in the appropriate location.
After that it selected the next movie on the weekly schedule then di
the process again. Probably a little longer of a macro but I'm happ
with the way it works. I think once I get done with this I may post i
on a website to let others take a look at it and grade me on it. Als
to let someone know where I could have done better (which is probably
lot of areas) since I am really digging through this for my first time
 
Top