VB Code to clean up Payroll Data by deleting rows

[rmomin]

Hello:

Please refer to attached file.
I have data as shown in Sheet1 and it needs to be transformed as shown in Sheet2

Basically, need VB code to look for ", in Column B,\
if Found then copy Data from next row column C into Column C above arow

In this case I would copy Cell C3 to Cell C2
So now you have B2 = Name of employee, C2= Amount $2500 and D2 = 03/31/20

And this needs to go thru the whole sheet and delete the rows in between

I have shown completed manually in Sheet2.

Please let me know if you have any questions.
Thanks.

R




Let me know if you have any questions.
Thanks.

[Trebor76]

Hi rmomin,

Here's one way:

Please Login or Register  to view this content.

Regards,

Robert

[sintek]

Another Option...

Please Login or Register  to view this content.

[rmomin]

Hello

Thanks to both, it works

R

[sintek]

Glad I could contribute...

[rmomin]

Hello Guys:

Hello:

Looks like I will need help in changing previosly done macro as it is malfunctioning.

Please refer to attached file.

Here Look for character "," in column D.
If Found then the value in 1 row below to the row with the "," and then copy the whole row in Sheet2


Let me know if you have any questions.
Thanks.

R

[rmomin]

Hello Trebor or sintek

Or any other exceler, can you help.

Thanks

R

[Trebor76]

Looks like I will need help in changing previosly done macro as it is malfunctioning.

It's not that the codes are malfunctioning but your requirement (data layout) has changed

See how this goes:

Please Login or Register  to view this content.

[rmomin]

Hello Trebor

Thanks a lot, if any thing change i will let you know.

R

[sintek]

As Trebor says...Complete different data setup...

Please Login or Register  to view this content.