Synchronize two excel sheets
Dear All, I have a problem with two excel sheets, which I need to synchronize. For example: Sheet1 and Sheet2
I have a table in Sheet1 from row 72, which is automatically get an information from another sheet(call Products). It has a VBA code which take the rows with product details with a specific logic. (Sometimes the table in Sheet1 has 1 row, sometimes has 10 rows). I need to synchronize that specific table with the Sheet2, which will be the main one and we can add all the information from Sheet1 everytime we include information from "Product" sheet.
Could somebody helped me with it? I guess it should be some VBA code, but I'm really new with it and couldn't find a way how to do it.
Thank you in advance!
RE: Synchronize two Excel sheets
Hi,
This is not the best solution but is a simple one. Go to Sheet2 code module and paste the following code:
' ************************* ' ************************* '
Private Sub Worksheet_Activate()
Application.ScreenUpdating = False
Sheet2.UsedRange.Clear
Sheet1.UsedRange.Copy
Sheet2.Range("A1").PasteSpecial Paste:=xlPasteAll
Sheet2.Range("A1").Select
Application.ScreenUpdating = True
End Sub
' ************************* ' ************************* '
If you can attach some sample file will be more clear what exactly you need and then to get a better solution. For example, I'm confused of your explanation where at first point you write that you need to synchronize two sheets and later write that your need is to synchronize two tables.
Best regards.
The thing is that we need to
The thing is that we need to upload and feed a sharepoint list from one excel file (where we have table and justification under and up table). Now I think it will be more easier if we can upload this table into an Access and after that synchronize the Access with the SP. It does make sense for you? For example:
TEXT TEXT TEXT TEXT
TABLE: 9 columns, 5 rows
TEXT TEXT TEXT TEXT
I need upload it only the TABLE.
Thank you!