Copy data from one spreadsheet to another

[Closed]
Report
Posts
5
Registration date
Monday February 28, 2011
Status
Member
Last seen
March 2, 2011
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

Can someone please help? ABC spreadsheet will copy the data to 123 spreadsheet, if there is no match find on Project ID, Name and Part. If someone changes one of the dates on ABC spreadsheet, for example: Date 2 to 4/1/11, the macro will replace Date 2 to 4/1/11 on 123 spreadsheet.

Spreadsheet ABC

Column A B C D E F G H I
Row # Name Part Date1 Date2 Date3 Date4 Date5 Date6

Spreadsheet 123 will the same format as Spreadsheet 1.

4 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Since the three field seems to be unique record indicator, Could you have one additional column "Project ID + Name + Part" in 123 spreadsheet? In that case you could use event

Private Sub Worksheet_Change(ByVal Target As Range)

End Sub
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
5
Registration date
Monday February 28, 2011
Status
Member
Last seen
March 2, 2011
2
Thanks, rizvisa1.

I am sorry! I am new to macro. Will you be able to provide the complete coding?

Thanks,
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.


Note:
your data need not be to be real data but a good representative of how data looks like
Posts
5
Registration date
Monday February 28, 2011
Status
Member
Last seen
March 2, 2011
2
Hi rizvisa1,

When someone enters the brand new data on spreadsheet 123 at the first time, it will copy the data to spreadsheet abc. The part (Project ID and Project Name can be the same.) have to be new, in order to copy the data to spreadsheet abc.

Later, the date 1 to Date 6 on spreadsheet 123 may get change, so when they are copied over to spreadsheet abc, the old data on spreadsheet abc will be replaced with the new dates from spreadsheet 123.

https://authentification.site/files/27142531/123.xlsx
https://authentification.site/files/27142546/abc.xlsx

Hope this is clear, and thank you so much for your help!
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
On the sheet to which the data is to be copied or updates, can you have one column that has all three fields in one cell?
Which column are you referring to?
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
columns "Project ID + Name + Part"
yes, it is doable. Thanks again.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
See your other question. It is same as this one. only difference is that in this there is one uique identifier. In that unique identifier is spread into 3 columns. If by use of formula you combine all three into one, you can reuse that macro (some modification would be needed).
2 different workbooks.