Hello Excel Fans.
I am working on a plan and I want you to feel comfortable rejecting the plan and feel free to give me your ideas, that's best for all of us.
My problem here is this:
On "sheet 1". I am receiving multiple "data from excel web" AUTOMATICALLY on "Column A (Countries)", "Column B (Dates)" and "Column C (Values)"
In "sheet 1", how can I copy individual row at the same time and paste each row values into separate "worksheets" to create historical data.
Or to create a historical list for each country.
See example below.
Sheet1: A1, B1 & C1 values paste into Sheet2 A1, B1 & C1
Sheet1: A2, B2 & C2 values paste into Sheet3 A1, B1 & C1
Sheet1: A3, B3 & C3 values paste into Sheet4 A1, B1 & C1
Sheet1: A4, B4 & C4 values paste into Sheet5 A1, B1 & C1 Sheet1: A5, B5 & C5 values paste into Sheet6 A1, B1 & C1
Also See Pic. Example. The color codes represents where the historical data is storing.
Every new data is paste in the next available row.
How can you help me?
NB: SHEET 3 ON THE PHOTO SHOULD HAVE BEEN SHEET 1 IT'S AN ERROR
14
Hi,
You can use events to detect when new data is entered into the sheet, and then use VBA to copy that data elsewhere.
Rather than use a separate sheet for each country I'd use a single table for everything. This will make the adding of new data easier and will simplify reporting as your data will be in a tabular format in a single location rather than dotted around the place in different sheets.
Regards
Phil
Quote: "You can use events to detect when new data is entered into the sheet, and then use VBA to copy that data elsewhere."
Thank you for your swift reply.
The problem is. I have a little over of seventy countries, in total.
And i understand what you are saying, I also have thought about it that way as well. But this is what apply:
Each worksheet have a chart that represent each country data. If I follow your suggestions.
How am I going to work around that?
You can consider creating a Pivot Table for each country in different sheets and then create the chart from them.
What are the steps to get this done? How I am going to do that?
In each country specific sheet, create a pivot table for that country. Info on creating and working with Pivot tables here
https://www.myonlinetraininghub.com/pivot-table
then create your chart(s).
Regards
Phil
