Inserting text in cell based on another cell text

I'm fairly new to Excel. I have the 2007 version and here's what I want to do...
I need formula (if possibe) to insert text into a cell based on text from another cell. For example, if I type "PTO" in A1 then "PTO" should automatically appear in A2....
=IF(A1="PTO")THEN(A2="PTO")
Or something like that....

Originally Posted by DonkeyOte

You might need to clarify the logic with some further examples but if you want a straight replication of A1 in A2 then the formula for A2 would be:

=A1

or, to account for A1 being blank (and not returning 0 to A2)

=IF(A1="","",A1)

Thanks for the response... it's so hard to explain Excel functions in words, especially when you're new to Excel and you're not sure if what you want to do is even possible. Here's more detail....
If I type the word "PTO" in A1, I want it to appear in A2 but if I leave A1 blank then I still want to be to I'm not sure if that's the best way to do this but I'm making a work schedule with 2 tables. One for time requests and one for the actual schedule. I'm hoping it possible to mark down "PTO" on the time request table and have it automatically appear on the schedule under the same person and date so I know, when I'm making the schedule not to schedule their shift on that day.