I received help with developing this macro from dlmille (Dave). I now need for the macro to only populate data if the data is not already present. The field D, "Reconstruction ID". If that data is present then the routine to move the data can be skipped, read the next record, check it etc. Attached is the excel spreadsheet output with some results already populated plus a folder with input files. The spreadsheet macro reads through each file in the folder an populates every line with a record. Now it needs to begin populating after the last record with new records. Thanks for your help and let me know if you have questions. Janis MCU-File-Review-Summary-Detail-N.xlsm DeRoy--Shelia-P01-3-19-2012-QC.xlsx Everly--Gloria-P01-2-20-2012-QC.xlsx Fields-Murphy--Rebecca-P01-3-18-.xlsx
More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.