Lookup and merge vba code

[jezza667]

Hi brains trust

I’m struggling to develop some code that I’m hoping someone here could help with please…


I have a spreadsheet of books and their data in columns A-AZ

I have 20 different book genres in column F

I have 200 book titles in column P

Each book title has its own row (therefore the genres are duplicated multiple times down column F, one row for each of the 200 books).

I want to develop some vba code so that based on the different book genres in column F, it combines all related book titles in column P into a single cell (so that there are only 20 rows in the end- one for each genre and it’s list of books).

Thanks in advance!

 

[airforceone]

Hi brains trust

I’m struggling to develop some code that I’m hoping someone here could help with please…


I have a spreadsheet of books and their data in columns A-AZ

I have 20 different book genres in column F

I have 200 book titles in column P

Each book title has its own row (therefore the genres are duplicated multiple times down column F, one row for each of the 200 books).

I want to develop some vba code so that based on the different book genres in column F, it combines all related book titles in column P into a single cell (so that there are only 20 rows in the end- one for each genre and it’s list of books).

Thanks in advance!

would be a great help if you can provide data in XL2BB format...

 

[jezza667]

would be a great help if you can provide data in XL2BB format...

Sadly I can't as the XL2BB add-in doesn't work with the version I have on my macbook (the real data is on my work computer and I can't transfer it across).

 

[airforceone]

Sadly I can't as the XL2BB add-in doesn't work with the version I have on my macbook (the real data is on my work computer and I can't transfer it across).

as our MODs always tells us, kindly update your profile so they can help you more effectively! ie. office version and OS version... since I'm on windows OS maybe some Mac user can jump in goodluck...

 

[bebo021999]

Sadly I can't as the XL2BB add-in doesn't work with the version I have on my macbook (the real data is on my work computer and I can't transfer it across).

Or image/ screenshot may helps...