Automatic update from source file

Question

Sir,

I have an Excel file with 3 sheets viz; 1-INP, 2-AVG & INP (2) 

I manually enter all the data in INP (2) with 19 columns this is the source sheet,

and i want a vba or excel formula to automatically transfer the info from INP (2) to INP sheet 

and from sheet named INP to sheet named AVG which is basically a summary sheet.

I could have attached the file here, but there is no option for that, kindly let me know how to attach the file for your reference if needed.

Thanks,

Raaj.

Answer 1

Hi Raaj306,

You had asked," i want a vba or excel formula to automatically transfer the info from INP (2) to INP sheet 

and from sheet named INP to sheet named AVG which is basically a summary sheet."

Try to refer code below.

Private Sub Worksheet_Change(ByVal Target As Range)
Dim sht1, sht2 As Worksheet
Set sht1 = Sheets("INP1")
Set sht2 = Sheets("AVG")
  sht1.Range(Target.Address).Value = Target.Value
  sht2.Range(Target.Address).Value = Target.Value
  
End Sub

Output:

Further, You can try to modify the code based on your requirement.

Reference:

Worksheet.Change Event (Excel)

Let us know, If you have any further questions.

We will try to provide you suggestions to solve the issue.

Regards

Deepak

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 2

No Sir, this code does not work on the huge file i have, it wud be better if you could take a look at my file.

kindly let me know how to send you the file.

thanks,

Raaj.

Answer 3

Hi Raaj306,

You can try to upload your file any free file hosting website.

Then you can share the link of your file here.

We will try to visit the link to get the file.

Then we will try to check your file and try to provide you further suggestions to solve the issue.

Regards

Deepak

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 4

Hi,

I have uploaded my sample file in below link.

thanks,

https://volafile.org/r/g4uz17vc

Answer 5

Hi Raaj306,

I try to visit the link and I find that You had uploaded a .XSLM file.

But when i download the file, File get downloaded as .XLSX File.

As a result, When I try to open the file. Excel shows that file is corrupted.

I suggest you to again try to upload file or any other site and share the link.

Regards

Deepak

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 6

Thank you Mr. Deepak,

I got the VBA code from Mr. HansV this morning and it turned out to be perfect.

Thanks a lot for him and thank you too for your effort.

Best Regards,

Raaj.

Answer 7

Hi Raaj306,

From your last post I can understand that your issue is solved now.

This thread is still open.

I suggest you to mark your own last reply as an answer.

It will help us to close this thread.

This thread will remain open until you mark the answer.

So please take appropriate steps to close this thread.

Thanks for your understanding.

Regards

Deepak

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].