Suggestions on how to improve - VBA

Hello,

I have written a macro and it's attached to the excel file along with the data it's to process. A couple of hiccups I am dealing with and would love to know the fix.

One: how to do an autofill based upon column a cell data. Or any cell relying on any column.
Two: IFS with OR formula, you'll notice in my subsidiary column I've repeated my commands but cannot seem to get the "OR" to work.
Three: How to program the macro to convert text to number, location and account columns as subsidiary is reliant upon location.

Look: your comments don't help much to understand you, but your macro -directly- doesn't help at all.

I suggest you upload a workbook to the Forum again, but this time with two pages:

- On the first sheet, show us what you have to process.
- And on the second page show us the complete expected result.

Maybe this is how it can be understood.

I have the feeling (from what I saw in your other query in this same Forum) that you have the information in a text file.

So you have to import it, process its columns and end up getting data into Excel.

If so, I suggest you go up to the forum:

- Your text file, and
- Your workbook with the final product you hope to obtain.