Notifications
Clear all
Dashboards & Charts
2
Posts
2
Users
0
Reactions
61
Views
Topic starter
Hello Excel World.
I have a problem.
Hear the thing.
1) I am extracting data automatically from excel web, in sheet #1 on Cell A1.
2) I want to transfer data from sheet #1 on Cell A1 to Sheet #2 beginning in Cell B2.
Now. Everyday excel web automatically update new data into sheet #1 in Cell A1.
However, I want to create a historical data on sheet #2 in Cell B2. Look at the example below.
1st Day
Sheet #1
| Cell A1 Data is: 100 | Cell B1 (Sheet #1) | Cell C1 (Sheet #1) |
|---|---|---|
sheet #2
| Cell A1 (Sheet #2) | Cell B1: 100 (copied from sheet #1) | Cell C1 (Sheet #2) |
|---|---|---|
2nd Day
Sheet #1
| Cell A1 Data is: 55 (Sheet #1) | Cell B1 (Sheet #1) | Cell B1 (Sheet #1) |
|---|---|---|
sheet #2
| Cell A1 (Sheet #2) | Cell B1: 100 (copied from sheet #1) 1st day | Cell C1 (Sheet #2) |
|---|---|---|
| Cell B2: 55 (copied from sheet #1) 2nd day |
How can I do this?
Also Include the dates as well
Thanks in advance
Posted : 27/11/2019 3:43 am
Hi Corrie,
Welcome to our forum!
Can you please upload a sample Excel file as I'm not following your tables above as the cells are empty. I suspect this is why others haven't helped yet either.
Kind regards,
Mynda
Posted : 28/11/2019 6:47 pm
