I need a macro VBA.
In the file attached, i have two tables, both with ID NUMBER, a date and a Type.
On the red Column "OLD ID"from the left table, i need to find a value "old ID" from the right table that has the same type and the inv. date has to be previous from the date on the left "del. date" .
This are the conditions: Same type and del. date > inv. date.
If there isn't a value that match this condition the macro have to write N/D.
The OLD ID can occur only one time.
I am proficient with excel macro/VBA development, I can write the macro to perform the search as per your specification, if you are interested feel free to message me, looking forward to chat further and work on your project.
€23 EUR in 1 day
5.0 (108 reviews)
6.3
6.3
10 freelancers are bidding on average €28 EUR for this job
Hi! I'd be happy to get this done for you, I'm incredibly experienced with Excel VBA from my 13 years working in London financial institutions. All the best! David
I have 10+ years experience in Microsoft Excel and Macros. I also worked on similar work. I have also knowledge of other languages like C# and RDBMS MSSQL.