I hope this is the right forum for this
I've got a macro in a sheet thats used for copying some data from one sheet to another. And yes I'm very new to this!
' copy_to_po Macro
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
The problem that I have is that the range is dynamic. It always starts at B7 and goes no further than column F, however the row varies based on data that is entered in column E. Its always in order, its just a case of saying stop the selection at the row where there is no more data in column E.
Thanks in advance!