Moncrief86
11-12-2008, 01:18 PM
I am still sort of new with using VB scripts. And trying to make a script for work to make everything go a lot quicker and easier
What I am looking to do is take one workbook(November.xlsx), which has a list of names. Sort them and then import it into another workbook(SigninTemplate.xlsx)
Folder structure:
C:\Work Workbooks\SigninLogs\SigningTemplate.xlsx
C:\Work Workbooks\SigninLogs\CompletedLogs
C:\Work Workbooks\VisitorsNames\November.xlsx
Anyone help me get started with sorting November.xlsx A-Z and import them to SigninTemplate.xlsx?
Any help would be appreciated
What I am looking to do is take one workbook(November.xlsx), which has a list of names. Sort them and then import it into another workbook(SigninTemplate.xlsx)
Folder structure:
C:\Work Workbooks\SigninLogs\SigningTemplate.xlsx
C:\Work Workbooks\SigninLogs\CompletedLogs
C:\Work Workbooks\VisitorsNames\November.xlsx
Anyone help me get started with sorting November.xlsx A-Z and import them to SigninTemplate.xlsx?
Any help would be appreciated