Raw data convert to Particular Format

[ushaanu]

HI all,

I have some raw data in excel file which I need to convert to some specific format. This file already have one VBAmacro code but now one new condition add and I am not able to fit new condition with old one . Details Condition example enclosed .

 

[ushaanu]

Hi all ,

is anyone help on this.

Regards
Anu

 

[Deepak]

Hi,

You should be very clear to query to get the answers...

I found that there is a mismatch in your highlighted written details which was confusing.

Pls be careful for explanation to get the target answer.

The more clear query is - chances are very high to get answers!!!

Pls check the attached file...

Added below code!

    If ws1.Range("E" & lngRow) = "C400" Or ws1.Range("E" & lngRow) = "7000" Then
        ws2.Range("D" & lngTRow + 1).Value = ws1.Range("I" & lngRow).Value - ws1.Range("N" & lngRow).Value
        ws2.Range("D" & lngTRow + 3).Value = ws1.Range("K" & lngRow).Value - ws1.Range("M" & lngRow).Value
    End If

 

[ushaanu]

Thank you So much Deepak sir ....it`s working fine thank you so much .......

 

[ushaanu]

Hi,

You should be very clear to query to get the answers...

I found that there is a mismatch in your highlighted written details which was confusing.

Pls be careful for explanation to get the target answer.

The more clear query is - chances are very high to get answers!!!

Pls check the attached file...

Added below code!

    If ws1.Range("E" & lngRow) = "C400" Or ws1.Range("E" & lngRow) = "7000" Then
        ws2.Range("D" & lngTRow + 1).Value = ws1.Range("I" & lngRow).Value - ws1.Range("N" & lngRow).Value
        ws2.Range("D" & lngTRow + 3).Value = ws1.Range("K" & lngRow).Value - ws1.Range("M" & lngRow).Value
    End If

HI Deepak Sir,

Can one more condition add in this code

If in ws1 column E name is 7777 than I+J -N= value shows in ws 2 as a ED123456-LB value like enclosed file.

Regards
Anu

 

[Deepak]

Pls share a sample....

 

[ushaanu]

Pls share a sample....