Posts by ivandgreat

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.

Hi,
I would like to summarize and combine some row cells to single cells, with respect to the column surname which is merge and use it as a reference to combine the row cells.
And add the sheet name and item count on the output.
Paypal Transaction ID
6E6789760A785643P br,

Hi,

Please anyone could help me to summarize my table.

I have a table, and only to get the value of the cell data that is not empty within the row range and get the column header on which the data was located.

Thanks for all the help.

br,
ivan

Quote from GCExcel

Hi,

I got a code ready for you. Do you still have my email address to send the payment?

Thanks

Please check. Payment sent. Thanks.

Quote from GCExcel

Hi,

I can help you with this.
Are all tables in the different tabs always located at the same position (in Column A) or not?

Thanks, GCExcel. Yes.

Hi,

Please help me to collect and summarize my table from all the sheets on the workbook with respect to the header/column name.

Transaction ID: 7EV962541N2429406

br,
Ivan

Thanks. Works fine.

Quote from GCExcel

Hello again,
I have a solution ready. I will post the code here once payment is received. I'll send you my email via PM.
GC

Thanks. Payment sent.

Quote from NBVC

If you are okay with a formula based solution (requires a helper column in the input sheet) then let me know...

[USER="14282"]NBVC[/USER], Thanks, but i prefer to have a VBA, since its slows down when a lot of formula on the cell.

I have a simple table which I wanted to transfer to another format by using Excel VBA.
It should run to select all records on input sheet and have it output.

Please find my input sheet and the output should be as per the output sheet.
Transaction ID: 22831538RS982110G

Quote from trunten

Sent you a pm

Hi trunten, i didn't get the message.

yes, i think it's much better to have a macro (to have the output right away), it much cleaner.
Since i don't need the formula anymore.

If it's possible also not to add any column on the main sheet, since it will have the same concatenation for all.
Much better to define it on the macro code as well.

The only thing i will add is based on the query sheet, which i define on ColA(Description) as L-T or L-F and ColC(Location) as Name. Run the macro and have the output as per columns.

Need your advice. Thanks.

No issue.
About adding additional column for main, no problem. I just tested it. It's really nice.
Its only works for a few rows exist on the query.

My only concern is that every time i will add a row to query it doesn't show on the output.

Can you please modify a little so that i could input any amount of number rows to query sheet and have that on the output sheet.

Thanks.

trunten,
hi, any update. thanks..

[USER="325177"]josuito[/USER], where can i see the files? Thanks.

trunten,

Yes. it was paid already. Transaction ID: 8X848174UJ644040R