I'm currently trying to make a spreadsheet that can be used to input and store large volumes of data. One way of speeding up the process of inputting the data is to copy data from the previous row. So far what I have is:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$J$3" Then
Call LD_Copy_Paste_Delete
End If
End Sub
Sub FillBlanks()
If Range("B13").Value = Empty Then
Range("B14").Selects
Selection.Copy
Range("B13").Select
ActiveSheet.Paste
Range("B13").Select
Application.CutCopyMode = False
If Range("C13").Value = Empty Then
Range("C14").Select
Selection.Copy
Range("C13").Select
ActiveSheet.Paste
Range("C13").Select
Application.CutCopyMode = False
If Range("D13").Value = Empty Then
Range("D14").Select
Selection.Copy
Range("D13").Select
ActiveSheet.Paste
Range("D13").Select
Application.CutCopyMode = False
If Range("E13").Value = Empty Then
Range("E14").Select
Selection.Copy
Range("E13").Select
ActiveSheet.Paste
Range("E13").Select
Application.CutCopyMode = False
If Range("F13").Value = Empty Then
Range("F14").Select
Selection.Copy
Range("F13").Select
ActiveSheet.Paste
Range("F13").Select
Application.CutCopyMode = False
End If
End If
End If
End If
End If
End Sub
What I would like is for the FillBlanks() to run just after the first sub, without having to do anything more. All help would be appreciated.
Many thanks
Aucun commentaire:
Enregistrer un commentaire