I have a work book with 5 identical sheets filtered to different lists
Ive linked these sheets so an edit in 1 sheets updated all the others
Its linked with the following code
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
On Error Resume Next
Sheets("NEXT SHEET NAME").Range(Target.Address) = Target
End Sub
NEXT SHEET NAME
= name of next sheet in workbook creating a loop between them
The trouble im having is I can copy paste a single cell but if I try to copy multiple or click and drag to paste in multiple cells it does nothing. It shows hovering over paste but wont actually paste keeping the cells blank.
Anyone have any ideas?