Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default formula between two workbooks

I have two open workbooks A and B

Both workbooks contain a range with a name representiing a group of sheets.
In workbook A there may be multiple sheets with the same name. In workbook
B, the name appears only once per sheet.

For example: workbook A might contain three sheets representing a group
called A1A and the cell B2 in all three would contain that name. Another
group of, say two sheets with the group A2A in each of the B2 cels, etc..

In workbook B, in the same cell, there would be one sheet for each group
and the group name in the same cell as Workbook A.

The formula would first look for cell matches between the two workbooks then
sum a value for the group (given in anothercell).

All cell refrences beetween the two workbooks are consistent except that the
source workbook (A) can contain multiple instances of the same number and the
summary workbook (B) only one.

All the formulas I've tried give a #VALUE error.

I hope this makes sense (?)

--
dave
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default formula between two workbooks

I think ur example is not clear
--
If this post helps, pls click Yes
---------------
TGV


"dave" wrote:

I have two open workbooks A and B

Both workbooks contain a range with a name representiing a group of sheets.
In workbook A there may be multiple sheets with the same name. In workbook
B, the name appears only once per sheet.

For example: workbook A might contain three sheets representing a group
called A1A and the cell B2 in all three would contain that name. Another
group of, say two sheets with the group A2A in each of the B2 cels, etc..

In workbook B, in the same cell, there would be one sheet for each group
and the group name in the same cell as Workbook A.

The formula would first look for cell matches between the two workbooks then
sum a value for the group (given in anothercell).

All cell refrences beetween the two workbooks are consistent except that the
source workbook (A) can contain multiple instances of the same number and the
summary workbook (B) only one.

All the formulas I've tried give a #VALUE error.

I hope this makes sense (?)

--
dave

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
What formula do I use to add totals between workbooks? Jodi @ Tehachapi Unified Excel Worksheet Functions 0 October 4th 06 08:25 PM
Pasting a formula in many different workbooks Playa Excel Discussion (Misc queries) 3 July 18th 06 05:57 PM
IF formula between workbooks jezzica85 Excel Discussion (Misc queries) 1 May 12th 06 01:32 PM
In two workbooks, how do I create a formula that will look at a o. socaldave469 Excel Discussion (Misc queries) 1 April 22nd 05 10:01 PM
how can i merge 2 workbooks using a formula? John F Excel Worksheet Functions 6 November 23rd 04 05:45 PM


All times are GMT +1. The time now is 11:29 AM.

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"