C
cb
Hi Everyone,
I have a bit of a question. I have two lists of items with the label for each item in column A and the number of items in column B. All of the item labels are the same while some of the amounts are not. They are in random order. Is there a way to have Excel combine these files so that the B columns are to the specific labels in column A?
For example:
fileA:
List1: $A$1:$A$50
are the labels for
List1A: $B1:$B50.
fileB:
List2: $A$1:$A$25
are labels for
List2A: $B$1:$B$25
For each item in List2 find the corresponding item in List1 and add List2A to List1A in this third worksheet.
And what's up that you can't SUM file cells in a new workbook isn't that a major spreadsheet task? Like this:
SUM([file1.xls]sheet!$B$1, [file2.xls]sheet!$B$1)
Thanks, in advance, for your help even if the answer is "No CB, it can't be done".
cb
I have a bit of a question. I have two lists of items with the label for each item in column A and the number of items in column B. All of the item labels are the same while some of the amounts are not. They are in random order. Is there a way to have Excel combine these files so that the B columns are to the specific labels in column A?
For example:
fileA:
List1: $A$1:$A$50
are the labels for
List1A: $B1:$B50.
fileB:
List2: $A$1:$A$25
are labels for
List2A: $B$1:$B$25
For each item in List2 find the corresponding item in List1 and add List2A to List1A in this third worksheet.
And what's up that you can't SUM file cells in a new workbook isn't that a major spreadsheet task? Like this:
SUM([file1.xls]sheet!$B$1, [file2.xls]sheet!$B$1)
Thanks, in advance, for your help even if the answer is "No CB, it can't be done".
cb