Search results

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

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

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

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...

@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 =...

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...

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