I have this code which helps me in saving data for two cells in different sheet.
Private Sub Worksheet_Change(ByVal Target As Range)
If [login to view URL] = Range("C2").Address Then
Dim intLastRow As Long
intLastRow = [login to view URL]([login to view URL], "A").End(xlUp).Row
[login to view URL](intLastRow + 1, "A") = [login to view URL]
ElseIf [login to view URL] = Range("C3").Address Then
Dim intLastRow2 As Long
intLastRow2 = [login to view URL]([login to view URL], "B").End(xlUp).Row
[login to view URL](intLastRow2 + 1, "B") = [login to view URL]
With this code i want two things
1. Whenever i press F2 and enter on column C2 it shows the value in sheet 2 not sure how to make it working continuously without doing it.
2. Also save the data for the range F2:F7 and T2:U7 in different sheet same as where C2 and C3 getting saved starting from column C (Like F2 data goes to C, F3 data goes to D so on).
Thanks in Advance.
Hi, I have an advanced knowledge on Excel's different formulas including pivot charts and visual basic coding. I'm willing to discuss more about the project.
5 freelanceria on tarjonnut keskimäärin ₹920 tähän työhön
Hi there, It seems a fairly easy task but I couldn't understand what you want the code to do in the first point. If you will give me the chance to work on it, I will try to deliver it before 7 days.