dubabear
05-08-2017, 12:05 PM
Hello, fairly new to VBA coding and I am trying to improve a process that was done before with multiple formulas.
I have an idea that code would require if,and,elseif statements to make it work properly and have no clue how to start it.
The current process is
Sheet1
In column I, there is a concatenate formula to put column B,D,F. Then take column A (account #) and paste it on column J. (moving A to J is to grab the information via vlookup by the concatenate.)
There also a sorting to move large numbers top to grab the correct information.
Sheet2
column AF is the concatenate formula that is pulling column B,K,P to tie back to sheet1.
Column AG is the vlookup to grab the information from Sheet1 Column J that was originally from column A
My Goal:
is to just grab columns A account numbers from Sheet1 that have certain account numbers (accounting there will be an opposite entry, this is why originally sheet 1 was sorted) account # such as 40100,40150, etc etc and work my way down to the last account that will be the catch all.
Then move to the next row.
I have an idea that code would require if,and,elseif statements to make it work properly and have no clue how to start it.
The current process is
Sheet1
In column I, there is a concatenate formula to put column B,D,F. Then take column A (account #) and paste it on column J. (moving A to J is to grab the information via vlookup by the concatenate.)
There also a sorting to move large numbers top to grab the correct information.
Sheet2
column AF is the concatenate formula that is pulling column B,K,P to tie back to sheet1.
Column AG is the vlookup to grab the information from Sheet1 Column J that was originally from column A
My Goal:
is to just grab columns A account numbers from Sheet1 that have certain account numbers (accounting there will be an opposite entry, this is why originally sheet 1 was sorted) account # such as 40100,40150, etc etc and work my way down to the last account that will be the catch all.
Then move to the next row.