Edit Clear contents of cells in CommonSheet to sheet name

[RAJESH1960]

Hello JohnnyL,
When I press the first button Generate Master xml. there are 3 rows in Import masters sheet. When I press the second button Generate Purchase xml it deletes all the rows except the first which it doesn't as it is not at all connected to purchase xml. The good thing the master xml has generated 3 rows of data and saved it on the desktop but the question is why is it deleting the data. Is the common sheet code connected to both master and purchase codes? Can you edit the code from deleting the data in the Import Master sheet.?

Sub ClearCommonDataFromSheet(CommonSheet As Worksheet)
'
    Dim LastRowInCommonSheet        As Long
    Dim LastColumnLetterCommonSheet As String
'
    With CommonSheet
        LastColumnLetterCommonSheet = Split(Cells(1, (.Cells.Find("*", _
            , xlFormulas, , xlByColumns, xlPrevious).Column)).Address, "$")(1)                  ' Get last column letter used in CommonSheet
        LastRowInCommonSheet = .Cells.Find("*", , xlFormulas, , xlByRows, xlPrevious).Row       ' Find last row # used in CommonSheet
        .Range("A3:" & LastColumnLetterCommonSheet & LastRowInCommonSheet + 1).ClearContents    ' Clear contents of cells in CommonSheet
    End With
End Sub

 

[RAJESH1960]

Hi JohnnyL

 

[johnnyL]

Hi

 

[RAJESH1960]

I have found a old copy of the above application after which a lot of editing is done. I will work on that tomorrow and post the portion which I will not be able to edit.

 

[johnnyL]

Which one do you need? The one with the two buttons to generate master xml & generate purchases xml?

 

[RAJESH1960]

Which one do you need? The one with the two buttons to generate master xml & generate purchases xml?

Actually there are 3 buttons - Check & Match Headings, Generate Master XML and Generate Purchase XML If the headings are corrected it takes less than a minute to get both the xml files.

 

[johnnyL]

I don't recall that one. Is that something I would have? If so, do you know what it was called?

 

[RAJESH1960]

Please check today's query. I will get confused if I work on 2 things at a time. I have been working on the bank statement the whole day and you can ask me about it.
Please refer post #3

Code not to resize if count is 1​

 

[RAJESH1960]

I will work on the purchases tomorrow morning and by this time tomorrow night I will share the file with you.