Macro to combine duplicate Rows Based on a particular Column to separate INV Headings

Hi,

I am terrible with macro's, so I would like to provide an alternate solution to your situation.
Plus I think you should keep the "Actual" so if you need to do a search using the inventory number it will be easier in the future.

My solution involves having your "Desired" as an additional sheet instead of replacing your "Actual".

The new sheet will consist of a Pivot Table to consolidate most of your table. With a formula to the right to return your inventory data.

The fundamentals of this formula can be found here:

http://www.globaliconnect.com/excel/...=77&Itemid=473

Attached is a modified version of your file. The additional "Pivot & Formula" tab demonstrates how a Pivot and Formula can provide the "desired" results.

Hope this makes sense and is helpful.

Cheers

Hi,
Thanks for your time and solution.


Your formula gives the following results

Inv1 Inv2 Inv3 Inv4 Inv5
198565 201653 206185 205926
205673


Actually it should be as below
195085 198565 201653 206185
205926 205673

However, I would like to have a VBA Solution.

Thanks once again.

Hi,

Sorry for the mistake in the formula. I got in a hurry. Here is the corrected one.

Please Login or Register  to view this content.

Good luck with a VBA Solution.

Cheers

vba

Please Login or Register  to view this content.

Hello Jindon,
Thanks for your marvelous code as usual.

A small problem is coming when I run it on my real data.
The sample shown on the DESIRED sheet was having few Invoice Nos extending from Cell M5 onwards
My actual data have many invoice numbers so now when I run the macro it is not extending further ..it stops at whatever heading is last in Row no. 4

Is it possible to amend your code to extend from Cell M5 with heading Inv2, Cell N5 as Inv3, Cell O5 as Inv4....till the last invoice available.
My current listing of Invoice Nos are 40+ in some cases which might be more in future too.

Thanks once again for your time and help

Thanks for your amended formula and link you gave me in your previous post.
I would use in my future requirements

Cheers

Try change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Thanks Jindon.
But the heading is coming as Column1, Column2...etc till the last Column
Can the heading show as INV2 for Column1, INV3 for Column2 till the last

Thanks once again for all your time and support.

Hello Jindon,
Any update on my problem please!

Thanks for your time and help once again.

If you upload a workbook that shows your desired results, may be help to understand what you are trying to do.

Hello Jindon,
Please check the attached sample

Sheet YOUR MACRO shows the result. Please see Cells M5 to P5. It displays Column1, Column2 etc

Kindly see the sheet DESIRED. Cells M5 to P5. It should display INV2, INV3 etc...

Your code is perfect

The only issue is that instead of showing Column1, Column2 etc it should show INV2, INV3 ...

Hope it is clear

Thanks for all your help

OK, add one line

Please Login or Register  to view this content.

Hello Jindon,
Thanks thanks and thanks
you are always a great help

Post marked Solved