I have 2 codes to try and pull data from worksheets ("sheet1") and place into select cells in worksheets ("Group1")
If I use the value = value method - the data is complete but I cannot insert the data into a dynamic cell space
If I use the copy insert function - I lose the data from DOB to generate AGE cells
is there a way to utilise the insert function with the values = values function?
Any help, ideas or feedback appreciated
Cheers,
Cmack
If I use the value = value method - the data is complete but I cannot insert the data into a dynamic cell space
If I use the copy insert function - I lose the data from DOB to generate AGE cells
is there a way to utilise the insert function with the values = values function?
VBA Code:
If InStr(TextBox2.Value, " 5 ") Then
Worksheets("Group1").Range("k6:p6").Value = Worksheets("Sheet3").Range("A5:F5").Value
Worksheets("Group1").Range("K7").Value = Worksheets("Sheet3").Range("H5").Value
End If
If InStr(TextBox2.Value, " 5 ") Then
Worksheets("Sheet3").Range("A5:F5").Copy
Worksheets("Group1").Range("k6:p6").Insert Shift:=xlDown
Worksheets("Sheet3").Range("H5").Copy
Worksheets("Group1").Range("K7").Insert Shift:=xlDown
End If
Any help, ideas or feedback appreciated
Cheers,
Cmack