• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. M

    Hello! I just wanted to say THANK YOU ! very much for helping people and sharing your time and...

    Hello! I just wanted to say THANK YOU ! very much for helping people and sharing your time and knowledge :)
  2. M

    Formula or Function Needed

    here is a new link http://www.mediafire.com/?rn2qfd1s5b014yi I have tried , (Well i think i have) what you suggested but it is not fully working I am new to VBA and a novice so still not sure Thank You
  3. M

    Formula or Function Needed

    This code however does not work Dim c As Range For Each c In Worksheets("Stock").Range("B5:B100,G5:G100") If c.Text = Worksheets("Selection").Range("B6,F6").Text Then _ c.Offset(0, 2).Value = c.Offset(0, 2).Value - Worksheets("Selection").Range("C6,G7").Value Next End Sub Thank You
  4. M

    Formula or Function Needed

    Thank You very much for that!! Thank You There is simply one last part left. I will attempt to create this my self but as the attached sheet was a sample i will test it with 2 or 3 other selection items Here is the Link http://www.mediafire.com/?hn8tcfaoc2hbqw5 Dim c As Range For...
  5. M

    Formula or Function Needed

    @Hui - Did you check your email Thank You for that it has worked. Thank You very very much! Can you explain the code for me please. ' This is all new Dim c As Range - What does the C mean ? For Each c In Worksheets("Stock").Range("B5:B100") - ( the item names) If c.Text =...
  6. M

    Formula or Function Needed

    Hello Thank You for your replay, I am a begginer in VBA sorry, Yes i would like : ou want to reduce the Stock Qty on the Stock Sheet by the selected Items Qty? Do i create a new Button and paste in the code? What do you mean by : Changing the CommandButton1_Click event should do what...
  7. M

    Formula or Function Needed

    Hello below is a worksheet which I have Uploaded, I need a formula or a function which can help make it work Thank You http://www.mediafire.com/?lzxwr965ez98hz9 Thank You
Back
Top