cleanup if and sumif in worksheet/workbook
Good day
i have a work book that make use of if and sumif to calculate and show data to 9 different blocks of data... would it be posible to make a if/sumif or a macro to make it easier and shorter sum than currently? at the moment the blocks only use data for the first 5 items. and i expanded the items. do not feel like editing every sumif/if calculation http://www.home-bound.co.za/saladlabel.xlsm for the file the 9 block are located on 'new label' and the data file on 'data sheet' regards phillip |
All times are GMT +1. The time now is 02:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com