Copying Text

W

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-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??
 
W

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-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.
 
Top