Macros inside Excel

M

Mark

I need to create a way to copy info from 1 cell on a spreadsheet to another
sheet based on the info I am putting into another cell on the 1st sheet. I
think it can be done with a macro but am not 100% sure. If someone could
either steer me in the right direction or tell me a better way other than cut
and pasting the info I would greatly appreciate it.
 
C

Carim

Hi Mark,

With the function IF you should reach your objective ...
for example in the destination cell in the Sheet2, you can type

=IF(Sheet1!A1="Yes","Congratulations","Try Again")

HTH
Cheers
Carim
 
M

Mark

I had already tried that and could not get it working correctly. What I am
doing is trying to create a way of copy data from 1 sheet to different places
on another one for a little league baseball draft, based on which coach picks
which player. The players are all rated and average scores are tabulated,
then the coaches get together and pick in turn, based on who has the lowest
total score of exempt and picked players until all players are choosen for a
team. I want to automate this process so that as soon as a player is choosen
his name and score are copied to another sheet that teams score recalculated
and we move on, the end result would be to click on the second sheet once all
players have been choosen for that round and see the list of players under
that respective coaches name, and the new total score calculated so the order
can be redetermined for the next round. Once all players are picked I would
then have a list of players already completed for each team.
 
O

Otto Moehrbach

Mark
Send me your file and I'll work up something for you. Include in the
file, in great detail, exactly what you want to happen. Like:
This coach does this, and this happens.
That coach does that, and that happens.
etc.
My email address is [email protected]. Remove the "nop" from this
address. HTH Otto
 
T

TOT

Mark,

I reviewed your problem and I designed a sample for you using 2 teams and
20 players. By the information you have given here i was able to accomplish
the task you desire using dynamic data exchange linking between 2 sheets. If
no one has assisted you as yet, then you can reply to me and I will help you.
You can contact me at [email protected]

TOT
 
Top