Log In
Register
Home
December 21, 2019
Offline
I have multiple "worksheets" in one "workbook". Each "worksheet" represents a "country database" that contains (3) Columns that label in row (#1):
(A1) Country
(B1) Last
(C1) Column
Each "worksheet" have "historical data", value of a country database, that holds "different ranges or rows".
Now, Every month I receive updated multiple data from (excel web) automatically on "worksheet #1": "Column A (Country)","Column B (Last)" & (Column C (Column).
See example below:
| Country | Last | Column1 |
| Australia | 51.6 | 11/19/2019 |
| Austria | 45.5 | 11/19/2019 |
| Brazil | 52.2 | 11/19/2019 |
| Canada | 51.2 | 11/19/2019 |
| China | 51.7 | 11/19/2019 |
| Colombia | 51.1 | 11/19/2019 |
| Czech Republic | 45 | 11/19/2019 |
| Denmark | 50.02 | 11/19/2019 |
| Egypt | 49.2 | 11/19/2019 |
| Euro Area | 46.9 | 12/19/2019 |
| France | 51.7 | 12/19/2019 |
| Germany | 44.1 | 12/19/2019 |
My problem here is this:
How can I "copy" the "range of data" from "Worksheet #1"(excel web) and automatically "paste it" separately "below" the "historical data of different ranges or rows" of each worksheet that represents the country's database?.
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
Why do you want to split data? It's best to keep it together, there are many reasons why splitting is a bad idea.
You can easily add a pivot table based on full data table, add those 3 columns in rows, add a Country slicer to see each country data one at a time.
Instead of clicking each sheet to see data, you will click a button in slicer to see the same thing. If you split data in sheets, you will not be able anyway to see more than one data sheet in the same time.
December 21, 2019
Offline
Catalin Bombea said
Why do you want to split data? It's best to keep it together, there are many reasons why splitting is a bad idea.You can easily add a pivot table based on full data table, add those 3 columns in rows, add a Country slicer to see each country data one at a time.
Instead of clicking each sheet to see data, you will click a button in slicer to see the same thing. If you split data in sheets, you will not be able anyway to see more than one data sheet in the same time.
"Why do you want to split data?
#1. To know the percentage change from last value.
#3 To create a chart
#2 To know average percentage of the last 12 months
How am I going to do that?
July 16, 2010
Offline
Attached is an example file with a dummy data set, PivotTable, Chart and Slicer that will allow you to choose which country you want displayed in the PivotTable and chart. I used 'Show Values As' to calculate the percentage change column. Try it out.
You might find it helpful to take my PivotTable Quick Start course that'll have you up and running with PivotTables in just over an hour.
Mynda
VIP
Trusted Members
June 25, 2016
Offline
This question looks similar to the question you asked here before:
https://www.myonlinetraininghu.....ble#p12035
Have you tried the solution that was given?
Sunny
1 Guest(s)
