Copy rows from one sheet to another based on a cell value

[StumpoC]

Experts, I need help ...

I'm using Microsoft Excel for Mac (does have "Filter" function) and I have this issue to solve.

I've that sheet "Data" where there are lots of rows.

For each row where appears number "1" on column "Y" I have to copy information from columns "D" and "E" (from that "Data" sheet) to another sheet, called "Estatistica".

If you need I send my Excel for better understanding.

Thank you very much.

(this is my first time on the Forum and I'm not having success on uploading my MiniSheet

Copy_rows.xlsx
	L
10	CLT
Data

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Copy Rows
and Copying rows from a Worksheet to another - Mac Excel
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[StumpoC]

Sorry, it was my mistake
There is something I need to do for going further on my issue?
Thank you

 

[Fluff]

You do not need to do anything this time unless you have asked this question anywhere other than here & Excel Forum.
However if you crosspost in future you need to supply the links yourself.

 

[StumpoC]

I need to delete my post.

How can I do it, please?

Thank you.

 

[Fluff]

You cannot delete posts or threads and there is no need to.