Insert a new Column when there's none under certain conditions

[gabeBU]

Hey Guys

I'd like to create a VBA Script for the following task:

I have an Excel Sheet with numbers, which are categorized in A B and C. Unfortunately, some numbers are missing (there's like a column with B and 8, and another with B and 10, but not with B and 9), so i'd like to create a Script which inserts those missing columns. Do you know how this would be possible?

Thanks for your help.

Kind regards


Gabe

[Richard Buttrey]

Hi and welcome to the forum.

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

[gabeBU]

Hi Richard

Okay sure, I can do that:

I have to excel sheets. Both have ID-Numbers, which are representing personal Information on the first Sheet (Name, Adress, etc.) and a Score on the other sheet. Unfortunately, some ID-Numbers are missing on the score-sheet, because not every peron has a score, so that's why some ID's are missing on the second sheet. But now I need to merge this to Sheets together, so they can analyze the data.

So here's an example:

That's how it is:

A	1
B	1
C	1
A	2
C	2

And this is how it should be:

A	1
B	1
C	1
A	2
B	2
C	2

[JeteMc]

It isn't clear to me as to why you would need to list, on the score sheet, the ID's of the employees whom do not have scores. It would seem that indexing the scores to match the ID's on the personal information sheet would be all that is needed to do analysis.
It may help to clear things up if you would, as Richard requested, upload a sample of your workbook by clicking on the GO ADVANCED button below the Quick Reply window and then scrolling down to Manage Attachments to open the upload window.
Let us know if you have any questions.