Insert columns upon criterias

[Ramzes]

Hello,

I have got a sheet that is loading reports and needs to calculate data from a certain point of the spreadsheet (column with certain day).

What I want Macro to do is to check a G2 location of it starts with certain 2 letters to determine how many columns I need to insert in front of it to make sure that the rest of the macro and calculations are working correctly. This to make sure I can always find Monday's data in the same location.

I am hoping that someone knows what code to use to determine the conditions - I know what is the code for the column insertion but do not know how to make it conditional.

I am attaching a sample file with a little explanation in it as well.

I appreciate your effort and any tries to make it work and want to thank you all for having a go at it. I really do not know how to work it out.

Thank you in advance.

Simon

[IonutC]

Goood morning,

Here you go.

Please Login or Register  to view this content.

[Ramzes]

Hi,

Thank you very much for your help.

I have got a little trouble though. It worked perfectly on a sample file.

In my original one I am inserting data from text file. it looks then exactly alike as per the attached sample but about 2000 rows and 50 columns.

In the original file it seems to be checking H2 instead of G2 despite the fact that the code is clearly stating G2 and G:G but inserts before H.

I have change the range to F2 so that it reads the G2 and columns from G:G to F:F to make it work and it seems I succeeded.

Would you have any ideas why this is working this way?

[IonutC]

Hi there,

I created an if function in order to check all the time the value from cell G2.
If you want to check H2 then you can customize the code in order to check H2.

The line that has to be changed is: ' Lresult = Left(Range("H2").Value, 2) ' instead of H2 you can change it in order to check other cell, if you need other cell and not G2.

[Ramzes]

Hello,

Thank you for your reply.

I have noticed it is customisable.

I do want it to look in G2 although what I meant is that in my main file I asked it to look into G2 but it was taking values from H2 for some reason.

it must be a "ghost in a machine".

Thank you once again for your help.

[IonutC]

Hi Ramzes,

If the answer provided is what you needed.

Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done.
If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .