Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What formula do I use to add totals between workbooks? | Excel Worksheet Functions | |||
Pasting a formula in many different workbooks | Excel Discussion (Misc queries) | |||
IF formula between workbooks | Excel Discussion (Misc queries) | |||
In two workbooks, how do I create a formula that will look at a o. | Excel Discussion (Misc queries) | |||
how can i merge 2 workbooks using a formula? | Excel Worksheet Functions |