Arrange System Generated Data In To User Defined Format

I am attaching excel workbook with this thread. After opening this workbook you will see “Sheet1” and “Sheet2”. Sheet1 contains system generated data which can be in thousands of entries. And Sheet2 is the user defined format which I need after running VBA code.

In this attached workbooks Sheet1 contains more data but in Sheet2 for giving you an idea what I want I have manually illustrated and arranged data so it is of first few transactions data.

This system generated data can be huge so please give the VBA which can tackle this data and give me error free output.

I need VBA code for this in emergency, Please help...

Verify the result and post back the line(s) that is not what you expected.

Please Login or Register  to view this content.

@jindon

First of all Thanks a Lot Brother

Your code is working very well. But there is need some improvement in codes and I am sure you will defiantly can do this.

1. In sheet1 if you filter the data which are begins with “Item:” and than if you copy this filtered data in new sheet and remove the duplicate rows you will find that there are 94 different items in sheet1 but in sheet2 it generated output of only 34 items.

2. In attached sheet when I run the code it gives me one extra column heading contains “Sabar DI:” which is because in original system generated sheet if you will see “Lot Number:” you will find that in some transaction there is two lot numbers. In this attached workbook if you will filter text begins with” Lot Number:” you can see some other items which contains more than one Lot Numbers. So do some modification in code that whenever this type of situation arised in output all the lot should be reflected against concern items in single cell.

3. Same issue is with “ Serial Num:” , when I run the code “Serial Num:” column contains no data but when you filter the data of sheet1 that begins with “ Serial Num:” you will found that some items contains Serial Numbers and this can be varied. in many case there is no serial numbers. In some cases there are one or two serial numbers and in some others cases there are many serial numbers. For example if you see the cell A26998 there are four serial numbers, in cell A27008 also has four serial numbers and in cell A27042 there are thirty serial numbers. So whenever this type of situation arised in output under “Serial Num:” column all serial numbers should be reflected against concern items in single cell.

Delete...............

I am uploading comparably small data file than previous one. In Sheet1 there is system generated data and In sheet2 I have run above VBA code and than done some changes manually which i need if you can help me with this.

Thanks...

Originally Posted by KRIXXXX

I need VBA code for this in emergency, Please help...

FYI This is a free forum offering free help - we do not prioritise anyone's posts, so don't mention words like 'urgent' and 'emergency' in your posts or titles, please. Thanks.

You have been asked to provide more information in a workbook: once you have done so, I am sure more help will be forthcoming, although maybe not today (it is a weekend, so the forum is quieter).

I know it's kind of tricky thing to do but you guys are capable of doing this very easily, After all you are Excel Gurus...

Original data files with whom I have to deal with are contains average 100000 rows and some even contains 500000 plus rows. So you can imagine how helpful this VBA code will be to me if you provide it.

Please do me a favor...

Originally Posted by KRIXXXX

Kindly spare some time for me and provide the VBA code. For you guys it's not that tough task.

As you don't know how to do it, how would you know how easy it might be for someone who does?

I suspect that the lack of responses means that nobody feels able to help you. Sorry.

Administrative Note:

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

Did you forget this one also?

https://chandoo.org/forum/threads/ne...-format.45119/

You need to supply all--not just one. Are there any others?

Sorry my mistake, if I get answer there then I will mark all other thread as SOLVED And I will post the solution of the this thread If found on other thread