Færdiggjort

Short VBA Macro

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

Evner: Visual Basic, Excel, Visual Basic for Apps

Se mere: 2,500 excel vba examples pdf, excel vba programming for dummies, vba code library, excel vba shortcut key for macro, 2500 excel vba examples free download, excel macro, vba excel examples, excel vba project examples, vba macro excel unicode, excel vba macro paste adjacent column, next empty cell vba macro paste, vba macro trial, vba macro generate report excel word, paste excel vba macro, row column increment vba macro, vba macro click button webpage, excel vba macro databases, calling oracle procedure vba macro, vba macro perl, excel vba macro programming bids

Om arbejdsgiveren:
( 0 bedømmelser ) Newtonabbey, United Kingdom

Projekt ID: #27929224

Tildelt til:

saif12me

Hi there I'm a VBA Expert and mostly work for VBA projects. I would love to help you to automate sells data and show you outcome as you require. You said you already have some knowledge about VBA, I can explain code to Flere

£20 GBP på 1 dag
(27 bedømmelser)
6.0

12 freelancere byder i gennemsnit £17 timen for dette job

BAVarun

Expert in excel with over 15+ years of experience and over 4.9 user rating on this platform. Completed over 60 projects on FL. Expertise - Macros Formulae VBA User forms Willing to share a sample of my work done o Flere

£15 GBP in 7 dage
(43 bedømmelser)
4.9
(52 bedømmelser)
4.9
dhanrajkarthick

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.

£20 GBP på 1 dag
(32 bedømmelser)
4.9
rameshraja86

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

£24 GBP på 1 dag
(16 bedømmelser)
4.0
kingqueen369

Hi, Greetings! ✅checked your project details Attachments Trade [login to view URL] ✅Completed Time : 24 hours(independent and fast workers only) or your requirement deadline . I would like to work on your project and want to be Flere

£15 GBP på 1 dag
(12 bedømmelser)
3.5
yesubabu10203

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 Flere

£20 GBP på 1 dag
(11 bedømmelser)
3.3
MykolaDudych

Hello I have experience in writing macros VBA for Excel. Can we discuss about your project in details?

£12 GBP på 1 dag
(8 bedømmelser)
3.5
woshiang717

Hello! I have read your requirement carefully, so I am very interested your project. I have rich experience with data processing using Excel VBA. I will finish your Excel VBA project in time with high quality Hope your Flere

£20 GBP på 1 dag
(1 bedømmelse)
1.8
raffayharoon

Hi, I am an expert in VBA macro programming. I am also adept in data processing and manipulation. I have gone through the requirements and have been trying to understand the flow you require. It will help to discuss fu Flere

£10 GBP in 2 dage
(2 bedømmelser)
0.7
ravisca2003

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.

£14 GBP in 7 dage
(0 bedømmelser)
0.0
rajput123456

Hi, my name is Naveen. I have been working from last 6 year with Multinational MNC as a Senior VBA Automation Developer with Expert skills VBA Automation,Macro( Outlook,SAP, Web browser,Excel Automation,Power Point,Not Flere

£10 GBP in 3 dage
(0 bedømmelser)
0.0