Search results

Thanks Narayan for your feedback and even I opine the same.After creating Report filter pages perhaps I could create a macro to apply CF on individual sheet but tell me whether any VB code can ease all this effort?

Thanks Narayan for the effort but I have to generate multiple sheets which I do by selecting the Pivot Table in Pivot Sheet,go to options and click on "Show Report Filter Pages" rather than making a zonewise copy of sheets.Following this process the CF of original sheets are not applied on...

I understand your point but I am preparing one Pivot Sheet and then using Pivot Report Filter other Sheets are generated. So can't I apply the CF or highlight settings to my Master Pivot and then when I run Report Filter, other sheets gets created with the same settings.

Thanks Narayan. I tried the code you mentioned and its working but what if I want to skip those blank cells between the Customer Name where Pivot Total is applied and also I have to insert the CF for all the sheets separately. Can I just apply the CF to Pivot and when I filter automatically the...

Thanks for Your Reply Luke but the CF is not working when I am applying it to Filtered pages.It is only working for the Pivot Sheet.I wanted CF for all my sheets.Please suggest.

Hello I have to prepare an aging report weekly which is prepared by extracting data in a master sheet and creating a Zone wise Sheets from using Pivot Filter. How can I highlight the name of Customers in every sheets whose outstanding is above 45 days automatically. I tried with conditional...

Guys Thanks for your patience in understanding the problem.....Actually the whole process is done by my accounts team.....I will get back to you with the complete operating formula and link up file....about the CD calculation....Currently I am running SAP software for the complete process but...

I have my transport rate chart as per date and location.Using index and match i have inserted Freight Rate/ton as per location and date in my master cement sheet.When i create a pivot of this data,I insert caluclated field of total qty by summing up two products qty viz OPC & PPC .in order to...

Yes very true the complete process as of now is a manual one....first we subtact the total opening balance from the first collection and compare the value with the invoice.If its equal or more than the invoice we go for the date check up viz(if the collection is between 10 days he is liable for...

Please find the sample file uploaded on the following link https://www.dropbox.com/s/jrdkkuxt1nc4uyj/CD%20CALCULATION.xlsx

In my Industry we give 100 rupee cash discount per 1 ton cement sale within 10 days and 60 rupee cash discount per ton if the customer pays within 17 days. So every month for all customers we need to check opening balance and the payment received against billed invoice and then validate as...

I have a volume of pivotised data having headers as date,transporter,qty,destination. i have to lookup for freight rates which keep on changing very frequently on the basis of destination and the freight for a particular period. How can i do it through excel... Date Transporter qty...