VBA copy text from different columns to another sheet

[Lars98s]

Hello,

I got an excel sheet which makes summaries.
I've tried lots of different kind of codes but i cant work out how to do the following:

I got an sheet with data. Column B is filled with headers and column C is filled with options (text) regarding the headers.
I want to use column D to put "x" of "X" in. (not case sensetive).

I would like the code to copy the headers from column B en the text form column C to another sheet. But i only want the text copied to the other sheet if i put an x in column D.
My code is a bit of a mess so i wont post it.

Hope someone can help me.
(I'm not native English so if something is unclear please ask )

Best regards,
Lars

 

[Lars98s]

For more information on what my excel looks like an example below. The sheet contains multiple of these.

For example I want the 3 rows with the x at the end to be copied to another sheet.
I also want the header 'Algemeen' to be shown above the 3 copied rows.

	Algemeen
1		Geldende voorwaarden voor het werk	x
1		Garanties conform Woningborg
1		Andere garantievoorwaarden c.q. modules van toepassing
1		CAR verzekering	x
1		Zijn er geluidseisen (belastingen) op de gevel van toepassing
1		Geluidsniveaumetingen binnen-buiten uitvoeren	x

 

[Joe4]

Welcome to the Board!

Can you provide a more robust data example and expected results?
Might you have multiple headers in column B?
What happens if you have a header in column B, but none of the entries under it have an "x" in column D? Do you want that header skipped then, or should it show a header with no records under it?

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[Lars98s]

Welcome to the Board!

Can you provide a more robust data example and expected results?
Might you have multiple headers in column B?
What happens if you have a header in column B, but none of the entries under it have an "x" in column D? Do you want that header skipped then, or should it show a header with no records under it?

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual post

Thanks for the reply! I found another way for doing what i wanted!