I need a project done as part of a daily rec process. I don't think it will take very long but I am getting stuck on how to write the vba code even though I do know some vba myself. Essentially I just need column I (Quantity) to net to zero (once the "sells" have been made negative - this much I can do) and I need the cells in Column H (Period) to have matching text if the adjacent cells to these cells in Column M also have matching text (prices). I need the code to run down Column H and every time it finds quantity nets to zero (which should be 3/4 times) then it checks that the periods are all the same and that prices for that group of buys and sells are also the same. I want it to notify me if period or prices are out when there is a net to zero but I also want it to recognise if there is not a net to zero when the adjacent cells in Column M all have the same price. It needs to be dynamic enough to notice that Column H, I and M could all be mismatching but also that just one could be and then [login to view URL] each time there is an error stating where. If all good I just need it to tell me all ties. I imagine IF ELSE statements will be needed here with for loops but am struggling to make it all work together. I may need to explain this in more details to whomever picks this up. Thanks
12 freelancer chào giá trung bình£17 cho công việc này
Hi there, Gone through your requirement and clearly understood what you need. I am a Microsoft Certified Professional in Excel and VBA as an Expert. Awaiting your response. Regards, Karthick G.
Hi Greetings I am having very good knowledge in Excel VBA coding with 13+ years of experience in excel Pls share your file to complete the work by today
Hi . This is Yesu ,I am Working as VBA/Python developer for 5 years I work on automations of [login to view URL] [login to view URL] [login to view URL] [login to view URL] Point [login to view URL] [login to view URL](limited) We use Macros,VBScripts,API's,Selenium, for process I can Thêm
Dear Sir, I am 15+year Experienced professional with experience in excel vba programming. I am active contributor as well on forums like mrexcel. com and excelforum. com I am happy to with work you on this.