How can I copy text from one worksheet to another

[Guest]

I am having a hard time and hope someone can help me!
I have a large spreadsheet that holds data, both numeric and alpha, and has
12 worksheets within the spreadsheet for each months' data. What I need to do
is create another worksheet titled Summary, which would give me a summary of
the information I need (not all on each worksheet is pertinant) at the end of
each year. It would be easiest if I could create a formula to pull the
information I need and add it to my summary worksheet rather than cut and
paste each worksheets' information to my summary worksheet.

I hope I explained this correctly.

Thanks everyone!

 

[Bernard Liengme]

On sheet10 use formulas like =Sheet1!Z20 to get Z20 value from Sheet1

Use formula like =SUM(Sheet1:Sheet9!Z10) to sum all Z10 values

Any help?

 

[Guest]

Actually, treat me like I am 10 and you are trying to explain this to me. I
am very good at certain functions in excel, so I am not new to it, but
anything with the formulas, I normally only do the SUM of numeric figures, so
this one is tricky. Sorry to be such a pain!
For example - your example of Sheet1!Z20 - what is the Z20 representing?

 

[Bernard Liengme]

Hi Kendra:
You have 12 sheets with data for each month; you want to have some of the
data summarized on another sheet.
Suppose the data you want comes from Z20 on Sheet1, then on the summary
sheet use =Sheet1!Z20 and the cell on the summary sheet will display the
same value as cell Z20 on Sheet1

If you want to sum the Z10 values on Sheet1, Sheet2....all the way to
Sheet12 use =SUM(Sheet1:Sheet12!Z10)

 

[Guest]

Awesome!!! I am going to give that a shot and I will let you know how it
works! Thanks so much!
Kendra

 

[Guest]

This was great! Thanks so much. I have another question and wanted to post it
as a new one, but now when I hit new question, nothing happens. Anyway,
I am trying to sort colums that have titles and the titles keep getting
sorted alphabetically even though I don't select them before I hit the AZ key
to sort ascending. Am I doing something wrong? It really is going to defeat
my whole purpose if I can't get them to sort once the information has been
extraced.
Thanks Bernard!
Kendra

 

[Pete]

I always advise people NOT to use the sort AZ icons!

It is better to highlight the data you want to sort, including any
header row, then select Data | Sort and specify your parameters - the
column you want to sort on (you can choose up to 3), whether you want
it sorted in ascending or descending order, and if your data contains a
header row (Excel will try to guess this for you). You thus have more
flexibility but also more control over what gets sorted.

Hope this helps.

Pete

 

[Guest]

Thanks Pete, I will try doing it this way and see if it works!