copy data from worksheet to another worksheet without overwriting

[gandalf72]

Hi Folks,

Looking for some help and advice, please. Difficult one to explain, Essentially I have 2 worksheets. For simplistic sense, let's call one Raw Data that gets updated daily and the other live reporting.

Raw data contains lots of information and is updated with new people every day.

Live reporting takes the data from certain cells consistently of the rows in the raw data and uses it.

As each day goes by new people are added to raw data, that contains various different information that stays consistent in the live report worksheet. This data cant be overwritten or moved to a different location.

My question is how can this be done.


Raw Data day 1
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]location[/TD]
[TD]start date[/TD]
[/TR]
[TR]
[TD]smith, bob[/TD]
[TD]Smithfield[/TD]
[TD]21/5/18[/TD]
[/TR]
[TR]
[TD]jones, alias[/TD]
[TD]Jonesland[/TD]
[TD]15/5/18

[/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]location[/TD]
[TD]Start Date[/TD]
[/TR]
[TR]
[TD]smith, bob[/TD]
[TD]Smithfield[/TD]
[TD]18/5/18[/TD]
[/TR]
[TR]
[TD]jones, alias[/TD]
[TD]Jonesland[/TD]
[TD]15/5/18[/TD]
[/TR]
[TR]
[TD]bloggs, Joe[/TD]
[TD]bloggsphere[/TD]
[TD]22/5/18[/TD]
[/TR]
</tbody>[/TABLE]

****** id="cke_pastebin" style="position: absolute; top: 433.333px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]15/5/18[/TD]
[/TR]
</tbody>[/TABLE]



</body>Live Reporting worksheet
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Start Date[/TD]
[TD]Comments[/TD]
[/TR]
[TR]
[TD]Smith, bob[/TD]
[TD]18/5/18[/TD]
[TD]updated with relevant comment[/TD]
[/TR]
[TR]
[TD]Jones, Alias[/TD]
[TD]15/5/18[/TD]
[TD]updated with relevant comment[/TD]
[/TR]
</tbody>[/TABLE]

I want to be able to take the data from the raw data and populate the live working data sheet without losing what is in the comments section. I am happy if it writes all new starts at the end but it cant take same value or add a new one and overwrite an existing cell on live reporting worksheet if that makes sense. The other key point is I won't be taking the entire row but only parts of the row say name and start date from raw data and not location.


thanks in advance

 

[pmich]

Some experts may understand your posting.
But, I need some clarifications.

You have given the table of 'Raw Data day 1'
The next table is not given any Title.

In 'Raw Data day 1' the Start date of 'smith, bob' is 21/5/18.
But in the second Table it is 18/5/18.
Is it okay?
Does this date column change day after day?

There is another table with '15/5/18'.
Why is this posted here?

You say : "I want to be able to take the data from the raw data and..."
Which Data? I mean, data from which column or row or cell?

You say : " ... and populate the live working data sheet without losing what is in the comments section...."
Do you mean to say that you are overwriting the cells in the live working data sheet except the Comments column?
You have also mentioned that overwriting should not be done.

You say : " ... I am happy if it writes all new starts at the end but ..."
If you want to write at the end 'losing what is in the comments section' does not arise, isn't it?

You say : " ... but it cant take same value or add a new one and overwrite an existing cell on live reporting worksheet if that makes sense."
Do you mean to say that the 'same value' refers to the existing names on Day 1 and the 'new one' means the data on Day2?

You say : " ... The other key point is I won't be taking the entire row but only parts of the row say name and start date from raw data and not location."
This can be done.

Please give an example of how the end result will look like.
This will help experts to reply you. If no one replies you, if possible, I will try to give you a solution.

 

[gandalf72]

Thanks for the reply, sorry I didn't call it out very well. Its kind of a difficult thing that I am doing as there is no unique identifier.

"You have given the table of 'Raw Data day 1' The next table is not given any Title."

Ok so what I have is raw data that will dump new learners and their data every day. The second worksheet is going to be the course that they are on and all assessors that are going to be assessing that course. For simplistic sake lets call worksheet 1 Raw Data and Worksheet 2 course.

In 'Raw Data day 1' the Start date of 'smith, bob' is 21/5/18. But in the second Table it is 18/5/18. Is it okay? Sorry this was an error on my part. The data is just an example date does not change.

Does this date column change day after day?
On the Raw Data the date is called Pot Data but on Course Data it is called Start Date.

There is another table with '15/5/18'.
Why is this posted here?

This was an error that I could not fix. Please ignore.


You say : " ... and populate the live working data sheet without losing what is in the comments section...."
Do you mean to say that you are overwriting the cells in the live working data sheet except the Comments column?
You have also mentioned that overwriting should not be done.

What I mean by this is that the raw data is always going to change and I cant be sure that the raw data stays in the same location. What is important is that it takes the assessor and the course and then takes the data it needs from the raw data tab and populates the relevant section but at the end of course it has a column called comments and I cant have that been replaced / overwritten or the data from that entire row changed by different data for each new data it should locate the first free row and then populate from there.

You say : " ... I am happy if it writes all new starts at the end but ..."
If you want to write at the end 'losing what is in the comments section' does not arise, isn't it?
Correct

You say : " ... but it cant take same value or add a new one and overwrite an existing cell on live reporting worksheet if that makes sense."
Do you mean to say that the 'same value' refers to the existing names on Day 1 and the 'new one' means the data on Day2?
Yes, I need to ensure the existing data stays the same.


[TABLE="width: 577"]
<tbody>[TR]
[TD="class: xl65, width: 64"]Name[/TD]
[TD="class: xl66, width: 64"]Start date[/TD]
[TD="class: xl66, width: 64"]Status[/TD]
[TD="class: xl66, width: 64"]Level[/TD]
[TD="class: xl66, width: 64"]Assessor[/TD]
[TD="class: xl67, width: 64"]IQA[/TD]
[TD="class: xl66, width: 64"]Employer[/TD]
[TD="class: xl66, width: 65"]Target Completion Date[/TD]
[TD="class: xl68, width: 64"]Course
[/TD]
[/TR]
</tbody>[/TABLE]









You say : "I want to be able to take the data from the raw data and..."
Which Data? I mean, data from which column or row or cell?



I have done the tables again due to errors that I made on original and put a text box with a better description which I hope helps

This table is the raw data

This Table is the course table

[/IMG]




I thank you for your help in advance and sorry I was not more clearer.