Hi All,
Please refer the attached sample work book, which contains daily sales figures - sales staff wise and channel of invoice wise. What I seek your support is to create a macro or some kind of formula which will auto sum the figures.
Example;
on day 01 Merwin sold 1 unit against DC10 (row 4) and with this sale his Month Till date (MTD) figures reaches 5 (row 6). On date 02nd, he sells 2 units but in DC80 channel (row 14) and the value in row 16 must change to 2 as soon as i press enter from key board. please note that the row 4 to 7 are constant and the position does not change every day. Only the daily values are updated to the daily sales made by the staff.
My look out is that once the value in row 4 & 5 is inserted / updated, their cumulative values in row 6 & 7 must automatically sum up to the day before's value (or subtract if a minus value is inserted, due to sales returns)
Can anyone help, please.
last time one of the distinguished member helped in solving a similar need on "columns" through a vb macro. i am not good in VB and could not find the way to convert that for "rows"
Thank you in advance
Bookmarks