Forum Discussion
Excel fromulas
Sherry,
The easiest way to do this is to filter the month column then copy the result to another location.
Then how do I write my formula to move the amount to another worksheet, if the date column equals Jul?
As variant Advanced filter https://support.office.com/en-us/article/Filter-by-using-advanced-criteria-4c9222fe-8529-4cd7-a898-3f16abdff32b could be used to copy data into another location based on criteria.
It's not refreshable, but with update of source data just to open it and click Ok, settings are saved.
No formula there!
You cannot move something using a formula or a function.
Formulas and functions in Excel are used to return or retrieve values, or as a link or mirror for another cell...After you done the filter as shown in the previous reply, just highlight the range of filtered cells, then copy them, and paste them into another worksheet or workbook.
