A clerk collects sales data each quarter and enters the data in a new worksheet. An accountant wants to add the quarterly data to the worksheet that contains the sales data for the year.
Create and save the following worksheets.
Sales_Data.MTW
C1-D
C2
C3-T
Date
Sales
Source
January
2,000.00
Q1
February
2,200.00
Q1
March
2,210.00
Q1
Q2_Sales.MTW
C1-D
C2
Date
Sales
April
2,400.00
May
2,450.00
June
2,700.00
Choose Data > Stack
Worksheets.
From Stack option, select Append worksheets to the bottom of a master worksheet.
From Master worksheet, select Sales_Data.MTW.
Move Q2_Sales.MTW from Available worksheets to Worksheets to stack.
Select Update the following column with the worksheet source name for each appended row.
From Column, select Source.
Click OK.
Results
In the stacked worksheet, the second quarter data is appended to the first quarter data and the Source column is updated with the worksheet name.
Sales_Data.MTW
C1-D
C2
C3-T
Date
Sales
Source
January
2,000.00
Q1
February
2,200.00
Q1
March
2,210.00
Q1
April
2,400.00
Q2_Sales.MTW
May
2,450.00
Q2_Sales.MTW
June
2,700.00
Q2_Sales.MTW
By using this site you agree to the use of cookies for analytics and personalized content. Read our policy