PDA

View Full Version : Importing an excel worksheet into another workbook(which has a prexisting table)



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

Moncrief86
11-12-2008, 01:19 PM
here is the November.xlsx file


thanks you again for any help

Moncrief86
11-13-2008, 12:55 PM
Sorry about before, it was alot to ask. It is What i wanted it to do when finished. But having problems getting the sorting and then importing started.