Using if and isblank nested.

Originally Posted by Norie

Mark

What have you tried?

Do you need to keep the blank row?

No i do not need the blank row.
have tried variations of if and isblank. have since then researched some courses and am looking ad doloop.

I will pop up a sheet showing what i get and what I want. If effect what I am doing is creating a simplified account system for a friend. I want her to be able to get her bank statements and put them into an excel sheet which then does some operations on them. Then some manual. Then another jump into the main transaction sheet which will give her her VAT,Monthly accounts and end of year accounts. Once thereI will add on a few more bits like individual accounts debtors etc. OK I could buy it but then i would not learn anything. Everything in accounts is very straight forward. Only bit outside is what to allocate this or that to which can change year to year depending upon government and one's personal situation.

Excuse the xxx which will be in the sample. Don't want to advertise her account etc.

mark

Hi Norie
You did ask me to tell you what I am aiming to do. I though that rather than just show you the immediate issue i would give you the whole section so you know what is in my mind. Attached please see a sample. The columns on the left are the original as they come and on the right is what I want to end up with. I am including the original csv file in case you have some thoughts. Ah does not like .csv files . No matter

Mark

Hi Norie
I have two scenarios in the same example the first batch of columns are what i receive and the second is what I want to end up with. Hope this makes sense.
Mark

Sorry Norie but yes that is correct. The explanation is what I am working on. In the sheet with the data I have made two sections. The data on the left is what i have and adjacent to it is the same data with the additional columns etc as described in the explanation. Would it be better if i had three sheets? Can do so immediately if necessary>

By the way i am trying =match to see how many it can recognize. Results are surprising in that it can recognize some but not others. I do not know precisely how it works.

Here is a new workbook with three work sheets.

So far with Excel i have stuck to using Functions. I will make a start studying VBA this evening so that I can use this exceptional advice. So you will not hear from me till tomorrow.

Thanks again and again

Hi Guys

Thanks for the help i have used the first solution by Norie. Pathetic but it made me so good to see it working that I had to run it again and again. So thanks.

All the best Mark