Posts by ivandgreat

Quote from trunten

I have a solution for you. I've PM'd you my payment details

ok.. i'll check.. may i know if its hundred percent will be found duplicates?

how about difference between singular and plural words?

Thanks..

Quote from ivandgreat

Dears,

I would like to separate the duplicates string values to a separate sheet. (unique sheet and duplicated sheet)

The cell values are almost identical base on the description name which was shuffled on the cell values.

Please check attached file.

Display More

Transaction ID05S28880ER208103C

Dears,

I would like to separate the duplicates string values to a separate sheet. (unique sheet and duplicated sheet)

The cell values are almost identical base on the description name which was shuffled on the cell values.

Please check attached file.

Also, when i filter the first and 2nd row.. the images doesn't show..

Only show when the 3rd row was expanded.. but still the first row doesn't show the picture..

Thanks.

Error, Unable to get the insert property of the pictures class.

Some link doesn't have picture yet.

Pls. support. Thanks.

pls check pm.. link for images. Thanks

Hello .. i have an error when collapsing the pivot.. could you pls check again. Thanks.

Payment send.

Pls. pm me the code. Thanks.

Thanks.

Pls. check sample file.

Hi,

VBA code.. show/hide only the images that was expanded/collapsed on the pivot table, since it's loading all images when expanding/collapsing the whole fields.

PM for sample file.

Transaction ID35N25611GV941410F

br,

HI GCExcel,

Please your support to revise the code..

Thanks..

HI GCExcel,

Please your support to revise the code.. show/hide only the images that was expanded/collapsed on the pivot table, since it's loading all images when expanding/collapsing the whole fields.

Thanks..

Quote from GCExcel

Hello,

I have a solution ready for you... Will send you payment details via PM

Pls pm me the solution.

Payment done. Thanks.

Quote from GCExcel

Hi,

I can look at this for you....

I will let you know if I have any questions.

Thanks.

Transaction # 38H90898PV7046144

Hello,

I have a pivot table from a table

I would like to insert the images/pictures from my computer folder which matches the cell value (path on the folder) from a pivot table.

Resize the picture on a standard size.

Code received. It is great, Thanks KjBox.

Payment sent. pls pm the code. Thanks.

Quote from KjBox

OK, and every "Religion" sheet will be the same format? In other words, columns A & B empty, row 1 a header row and data starting in C2.

[USER="33159"]KjBox[/USER], Yes, mostly.

Quote from KjBox

Are you looking to replace the data on the "Catholic" sheet with the new data or have the new data on a new sheet?

[USER="33159"]KjBox[/USER], I have the same data on different sheet, i wanted to collect them all in one sheet.