StillUnderstanding
Board Regular
- Joined
- Jan 30, 2021
- Messages
- 80
- Office Version
- 365
- Platform
- Windows
- MacOS
Hello,
Please could I ask for some expert help! I am trying to copy data based on the following but cant seem to get it to work, it would be great if anyone could help me work this out.
If cell "C2" in "Sheet 1" matches a tab name then copy data from that tab cell "A6" and paste into "Sheet 1" cell "A6"
Here is the code I am using but its not pasting in sheet 1
Would be grateful if anyone could help!
Thanks in advance!
Please could I ask for some expert help! I am trying to copy data based on the following but cant seem to get it to work, it would be great if anyone could help me work this out.
If cell "C2" in "Sheet 1" matches a tab name then copy data from that tab cell "A6" and paste into "Sheet 1" cell "A6"
Here is the code I am using but its not pasting in sheet 1
VBA Code:
Sub Copy_data()
Dim wkSht As Worksheet
For Each wkSht In Sheets
If Sheets("Sheet1").Range("C2").Value = wkSht.Name Then
Sheets("Sheet1").Range("a6").Copy Destination:=wkSht.Range("N" & FinalRow + 6)
End If
Next
End Sub
Would be grateful if anyone could help!
Thanks in advance!