Hi People
I was hoping some of the more experienced heads of VBA users would be able to help me out here please.
In Excel I have some records from Column A to Column L - however I only require help on the data from column H to L.
What I want to do is run a bit of coding where it will do two things:
1, In column H to L there are some columns with data missing and what I want to do is show each column next to each other.
For example now there is always data shown in column H and then nothing in column I and then some data in column J. In other columns it shows data in column H and then another some in either I J K or L - would it be possible to run some coding where if a cell/s is/are empty then to move the 2nd and then the 3rd etc etc. So in other words there are no empty columns in between columns H and L.
2, This is the more difficult coding I need help with, In some Columns between H and L they have text like ?HYPERI (some text) USING?..? ? What I?m trying to do is in these cells to remove the word ?HYPERI? and everything after and including ?USING?.
If you require any more information then please ask.
Any help please?