Dear Pros,
Is is possible for cell to recognize of date(month) & after recognition, it places the desired value in the designated cell?
In this case, for APAC01, I want "2640" of "8/30/19" in Aug cell.
Thank you so much for the help.
Hello All,
This is my first post and I really hope someone can be of help. I normally try and eek out success with Excel but this has got me stumped. Everything I find seems to just fall to the side of what I need to do.
Here is a quick example.
Let's say I have Sheet 1 that has this data...
Hi -
There is a property DOMDocument.async which when set to true, the default, it is supposed to allow processing to continue and return control to VBA while DOMDocument.load (tried loadXML as well) runs.
Tried a couple of different ways after searching.
One is posted at...
Hi everyone, I'd like to find a way so that if you enter a number in a cell of the column D, the rest of the column will fill automatically. I can't find a way to do this. Hope the image makes it clear to understand.
thanks, Pascal
Hi, I not sure what I had done wrong?
This is the original code which everything works well with no problem and excel can filter the result.
http://imgur.com/a/5oYPC
But once I modify it, the excel simple can't filter the result anymore. Can anyone help me what I do wrong on the code. Your...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.