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

    VBA Code to import file, Delete, & Edit columns

    i posted this query at Eileen's site, i will be happy to accept any good and easy method in order to solve my query here is the original MTO file Here here is the required result here as u can see i imported 8 columns from the original file, re-arrange them, and then i divided column J to 3...
  2. T

    VBA Code to import file, Delete, & Edit columns

    i searched everywhere i was not able to find a VBA Code that will do the following 1- ask for a file to import the following columns B, C, D, G, J, O, Q, M to row 3 2- Rearrange the imported columns to be · O is Column 1 · G is column 2 · J is column 3 – it should be divided (...
  3. T

    How to create Add/Subtract VBA Code with Vlookup ?

    MR Chihiro thank you very much for your help I Tried the code it works Greet , i really appreciate your help, this code will make my life easier, tonight i will learn how to modify it, thanks again for your precious time. Marc L, thanks for your warning next time, if i did cross posting,i...
  4. T

    How to create Add/Subtract VBA Code with Vlookup ?

    First of all: thank you for your replay you did it in the opposite way i want the data to go from sheet1 to sales sheet so the stock column will increase or decrease Not from Sales to sheet1, please help
  5. T

    How to create Add/Subtract VBA Code with Vlookup ?

    what i want Briefly: Add button: will add the quantities of C9:C23, to sales sheet column E Subtract button: will Subtract the quantities of C9:C23, From sales sheet Column E here is a sample file
  6. T

    How to create Add/Subtract VBA Code with Vlookup ?

    Good Day,, I need VBA Code for Add button & Subtract Button, but with extra Features !! i Googled it but nothing helpful the add button: will take all the Products quantities from C9:C60, and search & find the items [the items in column D in Sales sheet] ,and Add the quantities [the...
  7. T

    VBA Filtering for 3 columns

    here is the file, i just want the TextBox to search the 3 columns please help
  8. T

    VBA Filtering for 3 columns

    its not working,, maybe i didn't explain my problem very well , i created a TextBox using Macro and i'm using this code to filter the data whenever i write something inside the Textbox , the problem i need to filter 3 Fields ActiveSheet.ListObjects("Table2").Range.AutoFilter Field:=3...
  9. T

    VBA Filtering for 3 columns

    Good Day How to edit this code to make it filter 3 columns instead of 1 column ActiveSheet.ListObjects("Table2").Range.AutoFilter Field:=2, Criteria1:="*" & [k3] & "*", Operator:=xlFilterValues as you can see Field:=2 i can only put one column to filter please how to edit it?
Back
Top