How can I copy data from different cells from one tab into different tabs in one cell

M

matrix

New member
Joined
Dec 21, 2019
Messages
28
Reaction score
0
Points
1
Location
Usa
Excel Version(s)
2019
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:

Worksheet Tab of News SummaryCells of News SummaryNews to be pasted intoWorksheet TabCells (News to pasted into)
NewsCell B3paste intoPMICell B3
NewsCell B4paste intoNon_PMICell B3
NewsCell B5paste intoB_ConfiCell B3
NewsCell B6paste intoB_PermitCell B3
NewsCell B7paste intoRetail-SCell B3
NewsCell B8paste intoM2Cell B3
NewsCell B9paste intoIRCell B3
NewsCell B10paste intoPPICell B3
NewsCell B11paste intoCPICell B3
NewsCell B12paste intoUnemplyCell B3
NewsCell B13paste intoEmployCell B3
NewsCell B14paste intoG_DebtCell B3
NewsCell B15paste intoG_RevenuesCell B3
NewsCell B16paste intoG_SpendingCell B3
NewsCell B17paste intoGDPCell B3
NewsCell B18paste intoBond_10yCell B3
NewsCell B19paste intoBal_SheetCell B3
NewsCell B20paste intoJobless_ClaimsCell 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
 
You must log in or register to reply here.
Back
Top