Compare Headers in Array - Display Missing Header - Ask and Rename

The SH sheets are the two sheets in the workbook. I have created the other arrays manually within the macro. The sheets are where the headers are that I am trying to compare to the LO and SO arrays already defined in the macro.

OH - Thanks for looking at this! It is greatly appreciated.
Kehf

Kehfera,

See if this is how you wanted.

Please Login or Register  to view this content.

This has come closest to my needs. I am still working out through DEBUG how this actually works. I got confused a bit with an error I got when I tried to rename the column. It is letting me know that the SO is missing headers that are not part of the SO array. I think what this is doing is comparing one sheet to the next when I think I need to compare the sheet headers to the array. Once I understand it, I might be able to tweak it and post it here if it works for me. I want to share the working solution.

My explanation may not be so great but you followed it nicely. THANKS.

Kehf

As I stepped through the solutions I think my explanation needs some clarification:

I predefined the correct headers in my code.
For Sheet SO I want the headers in the sheet to = the array headers in the code hedrSO
For Sheet LO I want the headers in the sheet to = the array headers in the code hedrLO

Here is my code stated in sentences.
set the hedrSO = the headers I want for any SO sheet in the workbook
set the hedrLO = the headers I want for any LO sheet in the workbook

Go through all the sheets in the workbook
Get the first sheet
put the headers from the sheet into an array
Can use the count of headers to determine if it is an LO sheet or an SO sheet
if the headers are from and SO sheet then compare the hedrSO to the hedrSH (sheet header array)
if there is a header missing (or misspelled-Nice to have) on the sheet show which header is missing and from which column, _
then prompt to rename the column header on the sheet to the missing name
end the middle if
end the first if
if the headers are from and LO sheet then compare the hedrLO to the hedrSH
if there is a header missing (or misspelled-Nice to have) on the sheet show which header is missing and from which column, _
then prompt to rename the column header on the sheet to the missing name
end the middle if
end the first if
Get the next sheet
Finished with all sheets

I hope this clarifies the need a bit. Like I noted both sets of codes do a portion of the work but I am still trying to step through some of the code to understand where the fix may be needed.

THANKS SO MUCH for everyone's help. I will post the solution when it works for me along with a better spreadsheet so everyone can learn.

Kehf

Try

Please Login or Register  to view this content.

I got the latest code from Jindon. I will work on it this evening. I stepped through it once and got an error in the sub "RenameHeader" when I went stepped through the code. It happened the second time around. The first time it was fine. Type mismatch. I am sure it is a small tweak and when I find it, I will post it.

THANKS
Kehf

Originally Posted by Kehfera

I stepped through it once and got an error in the sub "RenameHeader" when I went stepped through the code. It happened the second time around.

Not for me.
Evidencing.

Of course, I did not think that Jindon had errors in his code. It is definitely me and my code. I pasted in the code but something on my file kept it from working and I did not know enough to find the error and fix it. Since Jindon uploaded a file and I ran through it, it was perfect. However, I need to compare the headers in those two sheets to master headers. I will work on trying to integrate some code and get that part going. I will post it here.

THANKS ALL! You have been so helpful. I wish I knew a bit more. Only time will help that and you all have helped me a bunch!

Cheers,
Kehf - I will post the code if I can get it to work the way I need it to.