Hi Guys,
This is my first post and I'm not really sure how to go about copying the VBA code so it actually looks like code as I see on other posts but here's the crux of it;
I am currently using a "Private Sub Worksheet_Change(ByVal Target As Range)" to automatically move the data in a column on sheet 1 to sheet to based on a drop down selection.
The code works perfect only I have now realised that I could do with it pasting the data as special paste values only...
Does anyone have any suggestions of how to edit this 'copy paste' coding to make it paste values only?
Range("A" & Target.Row & ":K" & Target.Row).Copy Sheets("Sheet2").Range("A" & LrowCompleted + 1)
Any help would be much appreciated!
Thanks
Neil
Bookmarks