Hello Everyone!
I have quite a daunting task to perform. I have a spreadsheet with: 1.data divided into categories (by date, site, number, products); 2. within the cell are contained alpha/numeric; 3. I need to calculate that field (alpha/numeric); 4. the location of these items are on several sheets (22) that needs to be calculated; 5. Can this data be combined on one (1) page. I know this is a lot to ask, but if I cannot find an answer, I will just have to try and calculate each page. The data was already set-up,so it was inherited. Any assistance would be gratefully appreciated. Below is an example and the Products column has to be totaled. The locations are on several sheets, so I need to get a total somehow.
Thank you, Thank you Thank you for any assistance, and have a beautiful day!
<tbody>
</tbody>
I have quite a daunting task to perform. I have a spreadsheet with: 1.data divided into categories (by date, site, number, products); 2. within the cell are contained alpha/numeric; 3. I need to calculate that field (alpha/numeric); 4. the location of these items are on several sheets (22) that needs to be calculated; 5. Can this data be combined on one (1) page. I know this is a lot to ask, but if I cannot find an answer, I will just have to try and calculate each page. The data was already set-up,so it was inherited. Any assistance would be gratefully appreciated. Below is an example and the Products column has to be totaled. The locations are on several sheets, so I need to get a total somehow.
Thank you, Thank you Thank you for any assistance, and have a beautiful day!
| Date | Delivery Site | Prod-No. | Products |
| Monday, May 25, 2015 | N/A | N/A | 0 |
| Tuesday, May 26, 2015 | Human Resource | SN-53845 | 20 Tablets |
| Maintenance | SN-54066 | 6 Drills | |
| STS | SN- 53845 | 5 Cabinets | |
| Wednesday, May 27, 2015 | Cafeteria | SN- 53719 | 30 Tables |
| ATTC | SN- 53477 | 10 desks |
<tbody>
</tbody>
