paramveer Member Feb 15, 2014 #1 Hi I am a distributor I gave goods to dellers and record it in different excel sheel. In attachment sheet. Please solve my problem Thanks Attachments question 1.xlsx 24.4 KB · Views: 7
Hi I am a distributor I gave goods to dellers and record it in different excel sheel. In attachment sheet. Please solve my problem Thanks
Somendra Misra Excel Ninja Feb 15, 2014 #2 Hi Paramveer, Please see the attached file. Yellow colour cells have formula in it. Just ad vise if any issue. regards, Attachments question_1(1).xlsx 25 KB · Views: 11
Hi Paramveer, Please see the attached file. Yellow colour cells have formula in it. Just ad vise if any issue. regards,
Somendra Misra Excel Ninja Feb 15, 2014 #3 Hi Parmaveer, Just one thought, you are making Net proforma on date basis, but the figures shows total net, either you should make month wise net or remove the dates and make it as on date wise net proforma. Just a thought. Regards,
Hi Parmaveer, Just one thought, you are making Net proforma on date basis, but the figures shows total net, either you should make month wise net or remove the dates and make it as on date wise net proforma. Just a thought. Regards,