Forum Discussion
arunrj
Nov 29, 2021Brass Contributor
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 ...
Riny_van_Eekelen
Nov 30, 2021Platinum Contributor
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.
arunrj
Nov 30, 2021Brass Contributor
With filter formula all the data in row will be displayed in summary right ?
Can you please attach the file ?
Can you please attach the file ?