matrix
New member
Hello excel supporters
I have a concern that is troubling me, which I’m having problems to fix.
I am not sure if "Mr. Norms" or " Mr. Masterswordz" or anyone out there can help me…
I am asking for your time and patience and your knowledge, as this may sound complicated to understand…
I have a worksheet tab name: “NEWS”.
There are “18” different data “news summary”.
Each news summary represents “one (1) cell”, beginning on:
Cell B3, Cell B4, Cell B5, Cell B6, Cell B7, Cell B8, Cell B9, Cell B10, Cell B11, Cell B12, Cell B13, Cell B14, Cell B15, Cell B16, Cell B17, Cell B18, Cell B19 & Cell B20
Individual data news summary is updated at random days and it is pasted over the current cells in cell B3 to cell B20
My problem here is this:
I have created different worksheet tabs for each cell that the news is in to present as a log sheet for the different sets of news to be pasted into: Please see what I am trying to do below:
Example #1 My concern is:
How can I copy NEWS tab from Cell B3 and pasted it into PMI tab in Cell B3? But always moving down the last data in PMI tab into Cell B4 and so on. Always keeping the latest data without duplicates on Cell B3.
How can someone point me to the right direction? And how can I do this?
Is there an easily or effective way I can use to get the end results. And If so, what do you suggest I do?
Please note. as new data should be updated every time...
Thanks in advance
Cheers.
Please view file link here: https://drive.google.com/file/d/1UdwdpNRUNnmxEz5T1UKk52uCrSDkzkke/view?usp=sharing
I have a concern that is troubling me, which I’m having problems to fix.
I am not sure if "Mr. Norms" or " Mr. Masterswordz" or anyone out there can help me…
I am asking for your time and patience and your knowledge, as this may sound complicated to understand…
I have a worksheet tab name: “NEWS”.
There are “18” different data “news summary”.
Each news summary represents “one (1) cell”, beginning on:
Cell B3, Cell B4, Cell B5, Cell B6, Cell B7, Cell B8, Cell B9, Cell B10, Cell B11, Cell B12, Cell B13, Cell B14, Cell B15, Cell B16, Cell B17, Cell B18, Cell B19 & Cell B20
Individual data news summary is updated at random days and it is pasted over the current cells in cell B3 to cell B20
My problem here is this:
I have created different worksheet tabs for each cell that the news is in to present as a log sheet for the different sets of news to be pasted into: Please see what I am trying to do below:
Worksheet Tab of News Summary | Cells of News Summary | News to be pasted into | Worksheet Tab | Cells (News to pasted into) |
News | Cell B3 | paste into | PMI | Cell B3 |
News | Cell B4 | paste into | Non_PMI | Cell B3 |
News | Cell B5 | paste into | B_Confi | Cell B3 |
News | Cell B6 | paste into | B_Permit | Cell B3 |
News | Cell B7 | paste into | Retail-S | Cell B3 |
News | Cell B8 | paste into | M2 | Cell B3 |
News | Cell B9 | paste into | IR | Cell B3 |
News | Cell B10 | paste into | PPI | Cell B3 |
News | Cell B11 | paste into | CPI | Cell B3 |
News | Cell B12 | paste into | Unemply | Cell B3 |
News | Cell B13 | paste into | Employ | Cell B3 |
News | Cell B14 | paste into | G_Debt | Cell B3 |
News | Cell B15 | paste into | G_Revenues | Cell B3 |
News | Cell B16 | paste into | G_Spending | Cell B3 |
News | Cell B17 | paste into | GDP | Cell B3 |
News | Cell B18 | paste into | Bond_10y | Cell B3 |
News | Cell B19 | paste into | Bal_Sheet | Cell B3 |
News | Cell B20 | paste into | Jobless_Claims | Cell B3 |
Example #1 My concern is:
How can I copy NEWS tab from Cell B3 and pasted it into PMI tab in Cell B3? But always moving down the last data in PMI tab into Cell B4 and so on. Always keeping the latest data without duplicates on Cell B3.
How can someone point me to the right direction? And how can I do this?
Is there an easily or effective way I can use to get the end results. And If so, what do you suggest I do?
Please note. as new data should be updated every time...
Thanks in advance
Cheers.
Please view file link here: https://drive.google.com/file/d/1UdwdpNRUNnmxEz5T1UKk52uCrSDkzkke/view?usp=sharing