Tamamlanmış

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

Beceriler: Visual Basic, Excel, Uygulamalar için Visual Basic

Daha fazlasını gör: 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

İşveren Hakkında:
( 0 değerlendirme ) Newtonabbey, United Kingdom

Proje NO: #27929224

Seçilen:

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 Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% GBP
(27 Değerlendirme)
6.0

Bu iş için 12 freelancer ortalamada £17 teklif veriyor

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 Daha Fazla

£15 GBP in 7 gün içinde
(43 Değerlendirme)
4.9
(52 Değerlendirme)
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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(32 Değerlendirme)
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(16 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(12 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(11 Değerlendirme)
3.3
MykolaDudych

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(8 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(1 Yorum)
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 Daha Fazla

£10 GBP in 2 gün içinde
(2 Değerlendirme)
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 gün içinde
(0 Değerlendirme)
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 Daha Fazla

£10 GBP in 3 gün içinde
(0 Değerlendirme)
0.0