SeanJ
03-30-2016, 09:40 AM
Attached workbook has code that takes over 1hr to run through. I know i am missing something. but either I need advice or scrap the whole code.
1. in Asset Correlation tab are Serial number that need to have rest of the information filled in from AMR Asset Report tab
2. there are duplicate information with slightly different dates attached
3. Grab the most current date for certain columns and populate the Asset Correlation tab are Serial number
4. the SN in the Asset Correlation sheet can not be deleted.
I have posted a copy of the code here with no help.
http://www.excelforum.com/showthread.php?t=1132811
1. in Asset Correlation tab are Serial number that need to have rest of the information filled in from AMR Asset Report tab
2. there are duplicate information with slightly different dates attached
3. Grab the most current date for certain columns and populate the Asset Correlation tab are Serial number
4. the SN in the Asset Correlation sheet can not be deleted.
I have posted a copy of the code here with no help.
http://www.excelforum.com/showthread.php?t=1132811