Copying Text

[wethery]

Not sure if you can do this but here goes. I work as an estimator and i have a front sheet which has a heading which reads desciption. I currently have 250 of these cells which have different descriptions in them. I have 250 tabs on the bottom of the screen and i need to copy each heading on the main screen to a heading in the tab. I currently press = on the tab heading then go back to the main screen highlight the relevant description and press equals. You can imagine doing 250 takes time. Not sure if it makes sense i hope it does and someone can help me

[0-0 Wai Wai ^-^]

Do you mean you wish to copy the text in the tab (the one at the bottom of the
Excel) to the cell?

What you do is similar to:
Copy 1st tab text --> 1st cell
Copy 2nd tab text --> 2nd cell
Copy 3rd tab text --> 3rd cell
and so on...

Right??

--
Additional information:
- I'm using Office XP
- I'm using Windows XP

[wethery]

No sorry explanation maybe crap. I want to copy text from my main sheet to separate sheets. I currently click the first tab on the bottom say for example this first sheet relates to light bulbs. On my main sheet i have a list of text one of those may read light bulbs. I want this same heading on the first sheet . I have 250 of these to do. So i click on the first sheet and press = on the cell i want the text in then i move to my main sheet and press return on the text i want to copy. I then do the same on the second sheet then go back to my main sheet and go to the second description and press return and so on. (250 times!!!)

[0-0 Wai Wai ^-^]

Are you copying the text, say from "Sheet1 Cell A1/A2/A3..." to "Sheet2 Cell
A1/A2/A3..."?
If so, that's easy.

1)
Type this in Sheet 2 Cell A1:
=Sheet1!A1

Alternatively, you may type the equal sign (=) in sheet 2 Cell A1. Then:
- go back to Sheet 1
- select Cell A1
- press Enter

2) Apply the formula in A1 to A2-A250. To do so:
- Highlight A1
- Can you see the small black square on the bottomright? Hold this square
- keep dragging until you reach the last cell

Hopefully this is what you want.