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 ...
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
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.
Riny_van_Eekelen : I have mentioned the requirement in the excel file attached. Please have a look.