Copy data from one spreadsheet to another
Closed
cacaip89
Posts
5
Registration date
Monday February 28, 2011
Status
Member
Last seen
March 2, 2011
-
Feb 28, 2011 at 01:03 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 4, 2011 at 06:07 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 4, 2011 at 06:07 PM
Related:
- When you wrote incorrect functions, what did you learn about spreadsheet data?
- Functions of spreadsheet - Guide
- Tmobile data check - Guide
- How to be offline in whatsapp when data is on - Guide
- We limit how often you can post, comment or do other things in a given amount of time in order to help protect the community from spam. you can try again later. learn more ✓ - Facebook Forum
- We limit the number of times you can request security codes in a given amount of time. we have this limit to protect your security. for help accessing your account, learn more, or try again later. - Facebook Forum
4 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 28, 2011 at 06:02 AM
Feb 28, 2011 at 06:02 AM
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
Private Sub Worksheet_Change(ByVal Target As Range)
End Sub
cacaip89
Posts
5
Registration date
Monday February 28, 2011
Status
Member
Last seen
March 2, 2011
2
Feb 28, 2011 at 11:05 AM
Feb 28, 2011 at 11:05 AM
Thanks, rizvisa1.
I am sorry! I am new to macro. Will you be able to provide the complete coding?
Thanks,
I am sorry! I am new to macro. Will you be able to provide the complete coding?
Thanks,
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 28, 2011 at 03:40 PM
Feb 28, 2011 at 03:40 PM
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
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
cacaip89
Posts
5
Registration date
Monday February 28, 2011
Status
Member
Last seen
March 2, 2011
2
Feb 28, 2011 at 08:15 PM
Feb 28, 2011 at 08:15 PM
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!
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!
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 1, 2011 at 06:11 AM
Mar 1, 2011 at 06:11 AM
are you looking to copy from one sheet to other of same workbook or two different book ?
cacaip89
Posts
5
Registration date
Monday February 28, 2011
Status
Member
Last seen
March 2, 2011
2
Mar 2, 2011 at 12:41 PM
Mar 2, 2011 at 12:41 PM
Can someone please help?? Thank you!
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 4, 2011 at 05:01 PM
Mar 4, 2011 at 05:01 PM
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?
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 4, 2011 at 05:30 PM
Mar 4, 2011 at 05:30 PM
columns "Project ID + Name + Part"
