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