Moving text from one cell to another

[Firefighter_930]

I have to track EMS calls. I have 30 different people that could respond to just as many locations. I used the "IF" function to return a text "true" instead on a number. My question: How do I make the text move to a certain cell on a different worksheet in the same book? I would have to do this upwards of 75 times (the number of calls in a 24 hour period) Please help.

[oldchippy]

If your word "True" is on Sheet1 cell A1, you can go to sheet2 click in a cell press =, then click on Sheet1 tab, then cell A1, then enter.

Whatever is on Sheet1 will now appear on Sheet2

[Firefighter_930]

Chippy, the text is the initials for my medics and abreviations for the cities were the calls are to. By placing a 1 in one cell below the name, or the city, I can return a true (the initials) to another cell by using the "if" function. Now, I want to be able to send the initials to another cell on another page using a function. Is this possible? If need be, I can send a sample problem. Please advise. Thanks

[oldchippy]

Yes, can you please post a sample, that would help to understand the situation better - Thanks

[Firefighter_930]

I hope this helps. If you need more, let me know. The next thing would be to send the whole file.

[Carim]

Hi,

Would you mind zipping your XL worksheet ... it is far better than Word ...

Thanks

Carim

[Firefighter_930]

Zipped, per your request. Thanks for the help.

[Json]

I do not really understand your workbook but....

If you want a value of one cell to appear in another in the same or another workbook then:

Select the source cell COPY
Select the destination cell PASTE SPECIAL > PASTE LINK

If you are working across workbooks they both need to be open

Can you use that?

Otherwise please clarify, where does the text need to be sent?

[oldchippy]

Zipped, per your request. Thanks for the help.

Is this what you mean?

Sheet1 Cell D5

=Sheet6!DJ4

Sheet1 Cell H5

=Sheet6!DP4

[Json]

If you are asking me then yes.

I think Firerighter just wanted to move text, if he wanted to add a condition to what text appeared then with 30 options he would have to use an array wouldn't he?

Excel won't handle more than 7 (?) nested if statements an I wouldn't like to have to try to write them lol.

[Firefighter_930]

First let me thank all of you for the time you have put into helping me with this problem.

Look at sheet1. Rows 5/6 (merged) need to have data input at cells D, E, F, G, H, S or T, U, and W This data is coming from sheet6.

Now, open sheet6. Place a 1 in cell C4. This returns GAD in cell D4. Place a 1 in cell C6. This returns GAD911 in D6. Look across sheet6 row 2. From column C to DB represents where a call can be (sheet1 F5 Call Area), how the call was received (sheet1 U5), and scene destination (sheet1 W5). Because of these variables, I have to be able to say to cells on sheet6 "GAD,I see you in D4, I also want to see you in sheet1 F5 but ONLY if I see you in sheet6 D4. GAD911, I see you in in sheet6 D6, I also want to see you in sheet1 cell U5; but ONLY if I see you in sheet6 D6." I cannot just copy the data as I don't know which sheet6 cell will have the data in it until a call is received.

I hope this makes my reqest a little more understandable. As usual, if it still doesn't make sence, let me know.

Thanks

[Json]

DAILY DISP LOG1.zip

This will do the specifics you asked for and; I think; allow you to work out the rest.

It wasn't obvious to me what needed to go where. If you want more done just give the specifics.
Sometimes it's more of a challenge trying to understand what someone is asking than actually answering the question.

Would a summary sheet detailing where your teams are and what their status is be useful?

[Firefighter_930]

Hi Jason,
Thanks for the input. Could you please post the file again. I went to download it and I get a corrupt file message. It looks like the offset function might work. I tried to use it (offset) without your file and I'm missing something. How is the "reference" different from the number of rows and the number of cells?

[oldchippy]

Downloaded OK on mine, but here are the formula's

Sheet 1 cell F5

=OFFSET(Sheet6!C4,0,MATCH(1,Sheet6!C4:CH4,0))

Sheet 1 cell U5

=OFFSET(Sheet6!C6,0,MATCH(1,Sheet6!C6:CH6,0))

[Json]

Did that do it?

I just downloaded the file my self and it's ok.

you could do with some validation on sheet 6, =sum(...)<=1 would do it to prevent multiple entries.

Just say if your still having problems.