range and individual data duplicate

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]

End If

End Sub

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.

Taidot: Excel, Excel VBA

Näytä lisää: looking hire individual data entry, simple individual data entry, individual data entry project bangladesh, mysql copy individual data fields, convert sas table individual data, excel convert range individual, individual data entry project, individual data entry workers needed, make excel conceptual worksheet individual data values statistics, script retrieve individual data php, extract individual data web excel, open range product data, range tree data structure, individual data looking, individual data entry work, I have 500 jpeg image data that i want to convert to ms word. It\ s required min. 50 - 70 WPM speed in typing., I have 500 jpeg image data that i want to convert to ms word. It\ s required min. 50 - 70, why do i always want new things

Tietoa työnantajasta:
( 0 arvostelua ) Delhi, India

Projektin tunnus: #29451943

Myönnetty käyttäjälle:


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.

₹900 INR 1 päivässä
(1 arvostelu)

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.

₹1050 INR 7 päivässä
(0 arvostelua)

Hello! Can be completed according to your requirements. Can you send a file for an example and evaluation of the work? Sincerely, Alexey.

₹1050 INR 7 päivässä
(0 arvostelua)

I have completed more than 100 task in pervious organization to full fill the different requirement of client to build atomization program.

₹1000 INR 2 päivässä
(0 arvostelua)

nice to meet you ,I am working as a clerk which required using excel vba programming and Marco usually.

₹600 INR 1 päivässä
(0 arvostelua)