hi
I need help by search way to transfer data from vertical to horizonal , and summing all the values for all values are existed in COL (UPAID) & (PAID ) then should subtracting between the columns for each customer ,and each month so when subtract total COL (UNPAID ) from col(PAID) and the COL (UNPAID) is bigger than COL (PAID) then should show the result contain for bracket and red color for instance in customer1 in month JAN as show in sheet result . so I put the result in sheet result how should be the values for each customer and each month how calculate the values .
not: every time increase customer and sheets so this is a simple sample to understand me .
any thing is not clear , please inform me, please
Bookmarks