Unanswered: Copy and paste entire rows based on a value in a cell
I am trying to develop a dashboard which will display rows that have a certain value in cells.
Attached is a basic version of what i am trying to create.
I need to copy and paste the data from row 48 down if the text in column F displays "Order Required". The rows then need to be pasted in row 34 downwards.
The dashboard is driven from other tabs which populate the data in rows 47 onward, so when this is updated, i need the pasted rows to change in line with the updated information
Hope this makes sense.....i've searched for some answers to similar problems, but haven't been able to find anything....any help would be greatly appreciated!!! Thank you!