0

I want to copy from sheet 1 and paste it in to sheet 2 , but I dont want to change the cell format / validation

enter image description here

I have written a macro which copies data from sheet 1 to sheet 2 , but I when I paste it in to sheet 2 the data validation (dropdown) gets removed . I want to keep it as it is , the drop downs.

 LastRowLoad = wsLoad.Cells(wsLoad.Rows.Count, 1).End(xlUp).Row  'checking the rows
 LastRowInventory = WSInventory.Cells(WSInventory.Rows.Count, 1).End(xlUp).Row   'checking the rows
    
 WSInventory.Range("A2:AQ" & LastRowInventory).copy Destination:=wsLoad.Cells(LastRowLoad + 1, "A")enter image description here
Nilesh Surve
  • 1
  • 1

0 Answers0