So yuo want to compare two cells - in the same row
presumeably? - and when they match copy the value of
another cell to another table. Do this for each of say 50
rows.
The destination table...the "right row" is a bit loose.
What's the criteria?
It helps if you describe more accurately what you mean.
For instance, you may have a table of results with say
the team name in column A and the competor in B with the
result of the match in C
You have a separate results table where you want the
match results copied to where the lookup values match the
team in A
If you could think about what it is you need more
precisely, then you'll get a more precise answer.
-----Original Message-----
Well, as I was looking back on the other post I made in
here I realised
that it was worded wrong so I decided to simplify my
question to see if
anyone around here can help me out. So I've brought it
down to trying
to figure out how to make one macro. See, I'm trying to
make a marco
that basically says, "if this cell is the same as this
cell(text btw),
then copy this and paste it here". My overall goal is to
make the
spread sheet copy match info from a wrestling match and
paste it into
the proper row on a spread sheet with each individual's
scores. In
other words I want the thing to paste it in the right
row without me
having to make a button for each row(50 of 'em). Any
help would be
appreciated.
Thanks,
Ryan:D
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/
.