Hello,
I have a table of data where i want to select data that meet a certain criteria and copy and paste that to a table in another range.
I.e. I have a table with 6 columns. The first column is date and that is what i am using as a condition. If the date for a given row is in the past week then i want to take the value from columns 2, 3, and 4 from that row and copy paste their values into a table on another sheet.
I've dimensionalised the ranges for each column, but im not sure how to go about going through each row to look at the date and then copy paste the data from the other columns if that date was in the past week.
Can someone assist?!
Much appreciated.
I have a table of data where i want to select data that meet a certain criteria and copy and paste that to a table in another range.
I.e. I have a table with 6 columns. The first column is date and that is what i am using as a condition. If the date for a given row is in the past week then i want to take the value from columns 2, 3, and 4 from that row and copy paste their values into a table on another sheet.
I've dimensionalised the ranges for each column, but im not sure how to go about going through each row to look at the date and then copy paste the data from the other columns if that date was in the past week.
Can someone assist?!
Much appreciated.