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

 

[RAJESH1960]

In the import sheet, the rows need to be resized with the number of rows below the particulars in sheet MasterData.

 

[RAJESH1960]

I am not able to take the range of values below the particulars column

from the "Original" sheet.

 

[RAJESH1960]

Please note I have changed the link with the edited code.
Test NA Masters.xlsm

 

[RAJESH1960]

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.

I have also been able to avoid the extra sheet workings with this code. So, you can avoid the first problem.

 

[johnnyL]

First link has been deleted and the second link does not load.

 

[RAJESH1960]

First link has been deleted and the second link does not load.

It's working. I was able to download. Sending once again here.
Test NA Masters.xlsm

 

[RAJESH1960]

JohnnyL

In my new project, instead of PasteData the name of the sheet is Original. The format in the original sheet is different from the other formats which you have written the code. I tried combining the MoveData code with the Generate xml code. I have been successful to some extent, but not completely.

The range below particulars to be copied to Masterdata from the Original sheet from the second cell row 12, below the particulars column and also avoid the last 3 rows which are 41,42, and 43th rows in this case. In the MasterData sheet, I need only one column “Particulars”.

I am unable to clear the old data in MasterData sheet and Import Master sheets, by adding the code, in the beginning of the code.

I want the code to stop and display all ledgers available when all the ledgers are available. When all the ledgers are available it is generating an error.

I am sharing the old code, for you reference, which is hidden in the workbook, from which I extracted the required lines.

If possible to extract the data from Original, then please remove the codes connected to workings sheet, so that I can remove that sheet.
Code to Edit.xlsm
Video for reference.....
Reference Video.mp4

 

[gravanoc]

It says access denied when I try to check out the workbook. Did you grant permissions?

 

[RAJESH1960]

remove that sheet.
Code to Edit.xlsm
Video for reference.....
Reference Video.mp4

Try this. I have granted access in this and deleted the old ones