Rustyf2003
New Member
- Joined
- Nov 20, 2009
- Messages
- 17
Hello- Using Excel in Office 365
I 'believe' I am missing a step and can't for the life of me recall how I accomplished this task a bit ago.
I am needing to Append multiple sheets in a single workbook (all have identical structures - column headings and format). into a single sheet.
i.e. Yearly Data with each year being on an individual sheet.
What I recall I did earlier was follow this process
DATA > GET DATA > FROM FILE > FROM WORKBOOK [Established the Connection and Selected My Workbook > Selected The Table
It is beyond this point that I feel I am missing Something.
What I've attempted (after selecting applicable tables) I am selecting > LOAD TO from the Drop Down > Then I am selecting to view the Data > TABLE > NEW WORKSHEET > OK
I thought previously that I was 'Asked' did I want to Append the Data into a new table // That option isn't coming up and the RESULT I GET is a replication of the individual sheets I selected into the current workbook. On the Right Side of the Workbook I have [Queries and Connections] and below list each of the sheets and the number of resulting records from each query. I would imagine this is where I am getting lost in the woods and no not which way to go
AM I MISSING A STEP OR HAVE LOST MY MIND AND NEVER ACCOMPLISHED THE TASK AS I DESCRIBED ABOVE.
Thanks for the assistance
Rusty
I 'believe' I am missing a step and can't for the life of me recall how I accomplished this task a bit ago.
I am needing to Append multiple sheets in a single workbook (all have identical structures - column headings and format). into a single sheet.
i.e. Yearly Data with each year being on an individual sheet.
What I recall I did earlier was follow this process
DATA > GET DATA > FROM FILE > FROM WORKBOOK [Established the Connection and Selected My Workbook > Selected The Table
It is beyond this point that I feel I am missing Something.
What I've attempted (after selecting applicable tables) I am selecting > LOAD TO from the Drop Down > Then I am selecting to view the Data > TABLE > NEW WORKSHEET > OK
I thought previously that I was 'Asked' did I want to Append the Data into a new table // That option isn't coming up and the RESULT I GET is a replication of the individual sheets I selected into the current workbook. On the Right Side of the Workbook I have [Queries and Connections] and below list each of the sheets and the number of resulting records from each query. I would imagine this is where I am getting lost in the woods and no not which way to go
AM I MISSING A STEP OR HAVE LOST MY MIND AND NEVER ACCOMPLISHED THE TASK AS I DESCRIBED ABOVE.
Thanks for the assistance
Rusty