#1   Report Post  
Posted to microsoft.public.excel.setup
Devon
 
Posts: n/a
Default I have a question

I hope this is not a repost...

I have a Excel Workbook with four tabs. Now I want to get information from
1-3 (totals) tabs and place that information into some cells on tab 4. I
don't want to cut and paste, I would like it to be a =sum or something like
that.

Can this be done?

Thank you

Devon
  #2   Report Post  
Posted to microsoft.public.excel.setup
Gary''s Student
 
Posts: n/a
Default I have a question

Something like:

=Sheet2!A1+Sheet1!A1+Sheet3!A1
--
Gary's Student


"Devon" wrote:

I hope this is not a repost...

I have a Excel Workbook with four tabs. Now I want to get information from
1-3 (totals) tabs and place that information into some cells on tab 4. I
don't want to cut and paste, I would like it to be a =sum or something like
that.

Can this be done?

Thank you

Devon

  #3   Report Post  
Posted to microsoft.public.excel.setup
Devon
 
Posts: n/a
Default I have a question

thank you.. it worked

"Gary''s Student" wrote:

Something like:

=Sheet2!A1+Sheet1!A1+Sheet3!A1
--
Gary's Student


"Devon" wrote:

I hope this is not a repost...

I have a Excel Workbook with four tabs. Now I want to get information from
1-3 (totals) tabs and place that information into some cells on tab 4. I
don't want to cut and paste, I would like it to be a =sum or something like
that.

Can this be done?

Thank you

Devon

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Summary Page Question EyeNoNothing via OfficeKB.com Excel Discussion (Misc queries) 1 February 18th 06 10:03 PM
Pivot table question gary Excel Discussion (Misc queries) 1 January 10th 06 06:25 PM
How do I find and replace a question mark in Excel? Ranpalandil Excel Discussion (Misc queries) 1 September 7th 05 10:20 PM
Hints And Tips For New Posters In The Excel Newsgroups Gary Brown Excel Worksheet Functions 0 April 15th 05 05:47 PM
An easy macro question and one I believe to be a little more diffi TroutKing Excel Worksheet Functions 3 January 18th 05 09:17 PM


All times are GMT +1. The time now is 08:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"