Forum Discussion
Data moving from one sheet to another sheet in same file (Without VBA or Macros)
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.
9 Replies
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
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.
- I want to see name & revenue plan in summary & the rows where qty est & rev est are coming zero, i need to add to next month sheet
