Forum Discussion

arunrj's avatar
arunrj
Brass Contributor
Nov 29, 2021

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 ...
excel
Formulas and Functions
office 365
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Nov 30, 2021

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.

 

arunrj's avatar
arunrj
Brass Contributor
Nov 30, 2021
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
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Nov 30, 2021

    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's avatar
        Riny_van_Eekelen
        Platinum Contributor
        Nov 30, 2021

        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.