Need help to correct code

[RAJESH1960]

Hello Code Experts

I am using one of Johnnyl”s code, editing it and using it for another project. I need help in some places. Firstly, I am not able to take the range of values below the particulars column which is column C as the cells are merged. So, I added another code to copy the sheet to the working sheet and used unmerged, shifted the heading “Particulars” from B10 to C10. The range need to be edited in the code.

Secondly, here is the tough part. In the List of ledgers sheet, I want the code to avoid 4 names from the list which are Opening Balance, (as per details), 2171377 which can be different in different scenarios and finally Closing Balance. That way I will get the correct ledgers, in MasterData sheet, that I have to create.

Lastly, In the ImportMasters sheet, I am getting 5 excess rows which are empty. They will generate an error when I import the xml file to the server.
If the working sheet is avoided it would be great.
Test NA Masters.xlsm

 

[johnnyL]

Glad we could help.

 

[Peter_SSs]

As there is no option to click multiple posts, I will just leave it here and mark this as solution. No offence...

Unfortunately the post you marked is definitely not the solution so I have unmarked it.
You either have to choose one of the others or mark none.

I have not read through the thread but if you have asked lots of questions in the thread then perhaps in future you should think about one question per thread. Or perhaps it might be a case of thinking more carefully at the beginning to make sure you have asked everything that you want to know right from the start.

 

[RAJESH1960]

Unfortunately the post you marked is definitely not the solution so I have unmarked it.
You either have to choose one of the others or mark none.

I have not read through the thread but if you have asked lots of questions in the thread then perhaps in future you should think about one question per thread. Or perhaps it might be a case of thinking more carefully at the beginning to make sure you have asked everything that you want to know right from the start.

Noted Peter_SSs.