Reply to: Excel Group & Merge Question

[scooterscot]

Most enjoyable read

I once got excel to read a dxf drawing file and import the entire text of material into a table... no macro's involved! I was quite excited

[Lowery]

Ended up working it out....

By the if I was snr management I would have deligated it to some poor sap!

[MarillionFan]

Best to stick a spreadsheet somewhere Lowery cause you're crap at explaining what you want!!!

Do you work in senior management???

[cojak]

They're aint nothing I can't get Excel to do.

I'll remember that, MF

[Sockpuppet]

Stick the spreadsheet online somewhere and PM me the link.

[lilelvis2000]

Does the report need to stay in Excel...'cause you could do this very easy in a Access report.

[Lowery]

Man I wish I could attach an excel sheet as an example....it would clearly show what I am trying to do.

The way the labels are printed they need to be in this format...no way around it.

Cannot be doen without a lot of moving text about. If you merge a cell it will delete all the text other than the first cell.

Yep. And that's ok because all the cells I am merging are of the same value. That's the formatting I need to do.

The problem is that I can do it manually but it's going to take me days to get through the entire spreadsheet (total about 30000 rows).

Figured there might be a macro/VB I can right which will merge all the cells with the same values.

[Sockpuppet]

Yep wish I didn't have to do it but have to print some labels and I need to build the template in this format.

There is almost certainly an easier way to do what you are doing. Tell us about the problem.

[Sockpuppet]

Cannot be doen without a lot of moving text about. If you merge a cell it will delete all the text other than the first cell.

[MarillionFan]

Use a macro or crystal reports.

[Lowery]

Umm sorry I think I need to clarify a bit further. Say you start with the below table...starting with 1 = A1, a = B1 etc...

The table will be sorted by column A.

1 a
1 b
1 c
2 d
2 e
3 f
3 g
3 h

The solution will search column A.
1. Select cells A1-A3.
2. Merge and Centre.
3. Select cells A4-A5.
4. Merge and Centre.
5. Select cells A6-A8.
6. Merge and Centre.

and so on through the entire table...

It's purely a formatting issue which is why I think I may need to use VB or a Macro.

Why he wants to do it god knows????

Yep wish I didn't have to do it but have to print some labels and I need to build the template in this format.

[MarillionFan]

They're aint nothing I can't get Excel to do.

[Warrior Princess]

=IF(A2=A1,TEXT(A2,"0"),TEXT(A2,"0")&TEXT(B2,"0"))

Start Data must be in row 2. Put formula in c2, drag down


A B C
1 1 11
1 2 1
1 3 1
2 5 25
2 6 2
3 4 34
3 6 3
3 7 3

Well done MF!!!!

Your the man!!!

[Sockpuppet]

Why he wants to do it god knows????

His teacher set some homework?

[MarillionFan]

Why he wants to do it god knows????