Searching, copying, and pasting data
Closed
Rob
-
Aug 19, 2010 at 04:30 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Sep 1, 2010 at 06:14 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Sep 1, 2010 at 06:14 PM
Related:
- Searching, copying, and pasting data
- Tmobile data check - Guide
- Root directory is full or error in pasting - Android Forum
- Gta 5 data download for pc - Download - Action and adventure
- Digital data transmission - Guide
- Transfer data from one excel worksheet to another automatically - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Aug 20, 2010 at 09:36 AM
Aug 20, 2010 at 09:36 AM
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
Aug 25, 2010 at 10:23 PM
In Sheet1 Column A is the data that will need to be referenced when searching in Sheet3. Sheet3 is an uploaded file of data. Any of the data in Sheet1 Column A that is also listed in Sheet3 Column A is what I'm looking for. For example, Sheet1 Column has 5 in one of the cells. Sheet3 Column A also has 5 in one of the cells. Therefore, I would want the entire row in Sheet3 (in case, row 3) to be copied and pasted in Sheet2. In the case of the same number appearing multiple times, both rows would be copied and pasted. For example, Sheet1 Column A has 14 listed. In Sheet3 Column A, 14 appears in two different cells. Therefore, I would want both of these rows (6 and 7) copied and pasted into Sheet2. As you can see in the macro, the data in Sheet3 will be cleared the next time the macro is run and new data will be uploaded. The data in Sheet2 needs to stay however with more data being placed in the rows following the data that is already present. I don't have any problems with the macro uploading the file. I just need a macro for searching through the data as I described. Thanks for your help.
Aug 26, 2010 at 08:21 AM
https://ccm.net/forum/affich-446224-copy-paste-specfic-date-to-other-worksheet#10
and this
https://ccm.net/forum/affich-258700-interesting-question-for-excel-champions
Your issue seems to be very close to the first one.
Aug 30, 2010 at 12:17 PM
Sep 1, 2010 at 06:14 PM