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?.
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.
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?
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
This question looks similar to the question you asked here before:
Have you tried the solution that was given?
Sunny
