Hello I have a problem.
Ok I have a macro that copies data to another worksheet
However I want everytime the macro copies this data to move it down to the next cell for example:
One time when I copy the data from the cell 'B11' I copy it to a new worksheet to the cell 'A2' however the next time I copy the data from 'B11' want it to copy the data to 'A3' and so on
Ok I have a macro that copies data to another worksheet
However I want everytime the macro copies this data to move it down to the next cell for example:
One time when I copy the data from the cell 'B11' I copy it to a new worksheet to the cell 'A2' however the next time I copy the data from 'B11' want it to copy the data to 'A3' and so on