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...
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.