Hello,
I need help with a formula or a macro that will help me get total dollars for contract that close for the month.
I have 5 workbooks and each of them have 40 to 50 tabs (depending on OPEN/CLOSE contracts for the month). My tabs are named "Vendor-name, Contract##, Open" (which indicated the contract is open for the month). For contract that got closed for the month are labeled "Vendor-name, Contract###) basically the same as open contract without the word open in the title.
Row 11 Column B provides the commodity code for the contract in that tab - I need help with a formula (if possible) or Macro that sums up row70 column R across all tabs for a specific commodity that does not have the word "open" in the title.
for example, Workbook#1 I have the following tabs:
Contract #1 OPEN - B11 "ZZ"
Contract #2 - B11 "ZZ"
Contract #3 OPEN - "ZZ"
Contract #4 - B11 "YY"
Contract #5 - B11 "ZZ"
Contract #6 - B11 "YY"
I want formula or macro that would provide a total for commodity "YY" and "ZZ" for contract that closed. At the moment, i have a formula that added up all dollars in R70 across all of the tabs whether the commodity is close or open.
Any help would be appreciated.
Thanks.
I need help with a formula or a macro that will help me get total dollars for contract that close for the month.
I have 5 workbooks and each of them have 40 to 50 tabs (depending on OPEN/CLOSE contracts for the month). My tabs are named "Vendor-name, Contract##, Open" (which indicated the contract is open for the month). For contract that got closed for the month are labeled "Vendor-name, Contract###) basically the same as open contract without the word open in the title.
Row 11 Column B provides the commodity code for the contract in that tab - I need help with a formula (if possible) or Macro that sums up row70 column R across all tabs for a specific commodity that does not have the word "open" in the title.
for example, Workbook#1 I have the following tabs:
Contract #1 OPEN - B11 "ZZ"
Contract #2 - B11 "ZZ"
Contract #3 OPEN - "ZZ"
Contract #4 - B11 "YY"
Contract #5 - B11 "ZZ"
Contract #6 - B11 "YY"
I want formula or macro that would provide a total for commodity "YY" and "ZZ" for contract that closed. At the moment, i have a formula that added up all dollars in R70 across all of the tabs whether the commodity is close or open.
Any help would be appreciated.
Thanks.