how do i link export data from one worksheet to another

G

Guest

I have 3 different worksheets (3 different jobs) that consists of 11-12
columns each with multiple rows 1-50 and a bottom total line. What I am
trying to do is to create a separate worksheet as a summary sheet. I want to
take the totals off the other 3 sheets and import them into 1 sheet. How do
I do this? Any help that you can give me would be greatly appreciated.
 
F

Frank Kabel

Hi
enter a formua such as
='other_sheet'!A10

--
Regards
Frank Kabel
Frankfurt, Germany

kris said:
I have 3 different worksheets (3 different jobs) that consists of 11-12
columns each with multiple rows 1-50 and a bottom total line. What I am
trying to do is to create a separate worksheet as a summary sheet. I want to
take the totals off the other 3 sheets and import them into 1 sheet. How do
I do this? Any help that you can give me would be greatly
Click to expand...
appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using data from one worksheet in another worksheet 1
link columns from one worksheet to another 3
Copying Data from One Worksheet to Another 2
How can I export data from one worksheet to another? 2
filtering data for analysis 6
Copy multiple worksheet into one colum 4
Summarizing monthly worksheet totals 1
How to export table from outlook into ms access table? 0

Top