Nov 29 2021 03:55 AM
Hi Everyone,
I have a planning file in which I will have names of my customer & the products with some price plan & estimate based on my planning.
So how can I move the rows from month1(sheet1) to month2(sheet2), based on my estimate value if its 0, without using VBA is it possible ?
& I have 2 categories of products, so upon looking at the total money I am getting from the sum in each category, is it possible to get the customer name & price in summary column next to the total, If I click the total of catagory 1 & catagory 2 ?
All this can be done manually, but assuming the no. of customers 100+, it is taking more time to do it manually.
Attaching the sample excel file.
Nov 29 2021 03:58 AM - edited Nov 30 2021 02:01 AM
For Summary part I have tried with filter formula but its pulling all the data, I want only customer name & price to be displayed in summary @Riny_van_Eekelen : Please have a look
Nov 30 2021 02:17 AM
@arunrj What exactly would you want to see in the summary cells on sheet 2? You mention name & price, but what should be the price part. I see two columns with revenue (plan and actual), but no price.
Nov 30 2021 02:37 AM
Nov 30 2021 02:48 AM
@arunrj Sorry, I don't follow. Can you fill it in in the schedule you uploaded earlier, so that I can see how you would want to summarise the example data.
Nov 30 2021 03:21 AM
@Riny_van_Eekelen : I have mentioned the requirement in the excel file attached. Please have a look.
Nov 30 2021 03:36 AM
@arunrj Added a FILTER formula in the summary area on Month 1 (cell A10). Still don't understand the second part of your question. You probably have it very clear in your mind, but I just can't grasp it. Sorry.
And then, physically moving a row (or in fact copying) and inserting it in another sheet in between other rows can't be done with a formula. You'll need VBA for that.
Nov 30 2021 03:40 AM
Nov 30 2021 03:41 AM
@Riny_van_Eekelen Sorry, forgot the file. doing it now.
Nov 30 2021 03:51 AM