Copy Data from One sheet to another based on the condition column

[AlexRub]

Hi, I need help, please.
I saw a few options but nothing worked so far.
My problem is this:
I work with two sheets on the same file, "RawData" and "FinalData"
RawData is summarized data from PowerBI and it varies in the number of rows.
I added a column on that sheet with a condition, with Copy / NoCopy.
All I need is to copy all the rows from RawData to Final that has the 'Copy ' condition (without the condition of course)
Can you please assist?

 

[etaf]

as you have 365 how about
=filter ( range , column with Copy/nocopy = "Copy")

=filter (Rawdata!A1:Z20000 , rwdata!Z1:Z20000="copy")

Book3
	A	B	C	D	E																					Z
1	1	B1	1	B1	1																					copy
2	3	B3	3	B3	3																					copy
3	0	0	0	0	0																					copy
Sheet1

Cell Formulas
Range	Formula
A1:Z3	A1	=FILTER(Rawdata!A1:Z20000,Rawdata!Z1:Z20000="copy")
Dynamic array formulas.

Book3
	A	B	C	D	E	F																			Y	Z
1	1	B1	1	B1	1																					copy
2	2	B2	2	B2	2																					nocopy
3	3	B3	3	B3	3																					copy
4	4	B4	4	B4	4																					nocopy
5																										copy
Rawdata

 

[AlexRub]

Well, I need it in vba for a button, this didnt seem to work either, i dont want to filter data, I need to copy since i re edit it later. i copy/paste differerent data each day (to the RawData sheet)...

 

[etaf]

Well, I need it in vba for a button,

Ok, i dont supply VBA solutions on forums , so another member will need to answer - dont know if you can still update title - but would be worth mentioning that in title or first post