Help with VBA ARRAY

[Ppessina]

I am relatively new to VBA and I am trying to create an array to compare columns in a worksheet. for example, I want to look through a column with unknown rows and every time I find the word "AUTH" I want to then look at its value which is in another column and paste it to an empy tolumn in the same row.

Another example is I want to look at more than one column and compare them. Ex) if row says "AUTH" and then another column (same row) says "CANCELLED" then again return value found in another column to blank column.


Thank you for your help. I hope this isnt completely confusing. I guess i am just having a lot of trouble understanding how to compare arrays or even set them up to be compared.

[Solus Rankin]

I'm not sure you even need an array. Can you paste a sample workbook with a before and after example of what you would like to see?

[Ppessina]

Here is an example of some of the code I have created. Problem is it is looping too much and takes forever

Please Login or Register  to view this content.

[Ppessina]

I am trying to set it up to find the specific rows and columns I am looking for because if extra columns are deleted I want it to continue to run without issue

[Solus Rankin]

The code you posted seems to do significantly more than what you asked for in your first post. This is where a workbook with a before and after example becomes so useful.

if extra columns are deleted I want it to continue to run without issue

This should be no problem, usually if you are deleting rows you can loop backwards and the loop is not effected.

[Ppessina]

Sorry. I know that code was really long. What I am looking for is an example array for one of those loops. If I can get an idea of how to set it up I think ill be able to adapt it for the rest.

[Solus Rankin]

Well if I take what your OP asks for literally then this:

Please Login or Register  to view this content.

Looks in column A for AUTH. If AUTH is found in A and CANCELLED is found in B of same row then it copies Column C of same row to the first empty cell in that row. If cancelled is NOT found in column b then it copies column D of the same row to the first empty cell in that row.

Clear as mud?

[Kenneth Hobson]

It would probably be easier to do a multi-find and then iterate the found range.

Please Login or Register  to view this content.

[Ppessina]

attahced is example. This will contain roughly 25k lines

[Ppessina]

Thanks for the replies. Sorry I was slow in getting an example ready

[Ppessina]

Thank again