I know this is a very easy task but i need to know the macro to copy a certain range of data from one sheet to another.
This range is dynamic and changes on a regular basis.