Copy Specific SO Number until next SO Number

**borissinga** · 10-10-2010, 12:35 PM

Hi, please help me.

I'm trying to copy the SO Number (SO-0001..SO-0467) next to the Voucher Number (10-RV0001, 10-CM0001, 10-DM0002, 10-BY0003 etc.) so i can sort it.

I've used this code, but it didn't work.

Please Login or Register  to view this content.

I'm new to Excel Macros, thank you in advance

PS: here's an example of my worksheet.

**StephenR** · 10-10-2010, 12:48 PM

Try this:

Please Login or Register  to view this content.

**borissinga** · 10-11-2010, 11:44 AM

It works! Thank you!

I have another question. :D
With all the Voucher had SO Number, i've copied SO #, DO #, DO Date from another worksheet. Now i want to return the Voucher Amount and sum it based on SO # and DO Date.

Some Amount is for several DO, thus it didn't need to add from the previous amount. Just return the same amount as the previous one. In other words: Different DO, same DO Date, same amount.

I used lookup:

Please Login or Register  to view this content.

But some amount didn't showed up! And i've used sumif to sum the amount, but it didn't work!

I'm sorry if it's confusing. Thank you.

PS: Can i post the question here? Or should i make another thread, since this is the excel programming sub forum. And here's the example.