Forum Discussion
Excel fromulas
I am trying to create a formula that will do the following; if E21 = Jul then make H7 = F21.
What I need to do is if the month column includes Jul (for July) take the number in the amount column and move it to another sheet or workbook.
Thanks for any help.
4 Replies
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.
