austenr
11-07-2006, 10:15 AM
In the attached workbook, there are four sheets;
Master, September, August and July. I need to take the subtotals in each month and paste them in the corresponding place on the master sheet.
What is in B & C needs to go on the master sheet under the corresponding month. Tried a couple of lookup functions but the entries that had no assigned value were filled with the last value in memory. Any help is appreciated. Thanks
Master, September, August and July. I need to take the subtotals in each month and paste them in the corresponding place on the master sheet.
What is in B & C needs to go on the master sheet under the corresponding month. Tried a couple of lookup functions but the entries that had no assigned value were filled with the last value in memory. Any help is appreciated. Thanks