Move row data to correct tab if Serial Number is not in the tab

[bigroo1958]

Hello,

Here's what I am trying to do with this spreadsheet project, please review the attachment for more detail and understanding!

On the "Master" tab, I would paste in the newest information received from our system weeklywhich is around 2600 rows.
I want to then compare the Master sheet to the other tabs and if there is a new Serial Number present in column I, then add that row of data to the next available row at the bottom to the correct tab.

The Orange tabs Fleet Volume PC, Fleet Volume BW, Fleet Volume Duplex will house all countries and all serial numbers but Fleet Volume Color tab will only have Color Serial Numbers for all countries, column J on the Master tab.

So, the same will goes for the USA Volume and CAN Volumes tab, only those serial numbers for that country will falls in these tabs and color only will go in the color tabs. There are 14 other tabs missing from this workbook with other countries, just removed to keep size of file within limits.

From my workbook, rows 29 to 33 on the Master tab are new serial numbers.

Also, I want to highlight the data on the Master, after comparing this Master tab to the other tabs and within the Master highlight in yellow the cells that have new updated information!

I hope I have explained myself well!!

[xladept]

Hi Bigroo,

I notice that the "tabs" column A has numbers in it - how are those numbers assigned??

[bigroo1958]

Hi XLAdept,

These numbers are used to return the rows back to original order when sorting is used, they have no other significance really!!

[bigroo1958]

Bump!
anyone??

[xladept]

@Bigroo,

So - do I leave them blank???

[bigroo1958]

Hi XLAdept,

Yes, that will be fine!!

[xladept]

Hi Bigroo,

Try this:

Please Login or Register  to view this content.

*I needed to Capitalize "CAN" on the penultimate sheet

[bigroo1958]

Hi XLAdept,

I really appreciate what you have done here, it works as expected and on the first go round, FANTASTIC!!

all the tabs update but the "CAN Volume Color" does not add the new serial number, this line 30 on the Master Tab.

[xladept]

Hi Bigroo,

You need to change that tab name so that "Can" is all caps - but I've been playing with it are you happy with the highlighting?

[bigroo1958]

Hi XLAdept,

Thanks, that did fix it!!

You need to change that tab name so that "Can" is all caps - but I've been playing with it are you happy with the highlighting?

I did not see any highlighting on anywhere, do you have it within the code block?

[xladept]

Hi Bigroo,

I've got a bad habit of editing my posts - but the highlighting on the current post is unsatisfactory shall I pursue it??

[bigroo1958]

Hi XLAdept,

Yes, I would like to see highlighting as I outlined within my original post!
Please pursue this very me!

[xladept]

Hi Bigroo,

This version satisfies this condition:

Also, I want to highlight the data on the Master, after comparing this Master tab to the other tabs and within the Master highlight in yellow the cells that have new updated information!

Please Login or Register  to view this content.

[bigroo1958]

Hi XLADept,

Thanks for the updated code block, very much appreciate your efforts.
The highlighting is still not showing on the Master tab, I see where you have added the coding for this part. I even changed the data on the Master tab to show there is a difference in the data but still not luck.

How do I change the code to look at additional tabs that do not have a country name within the sheet name.
For example CORP and GPS, is it a matter of adding the sub procedure to include the additional tabs.

Please Login or Register  to view this content.

Thanks again!!

[xladept]

Hi Bigroo,

The routine will ignore anything that has been processed - to test the new code you'll need to delete all the latest entries on every tab.

Where are CORP and GPS are they only in the tab name?

Maybe:

Please Login or Register  to view this content.

Here's what I've got:BigRoo.xlsx

[bigroo1958]

Hi XLAdept,

Ok, so I have being clearing out my data that was added to the bottom of each tab before running the code. OK, so I found what I was doing wrong, my bad. It works great.

No, these tabs were not on the workbook I posted, these were some the tabs I removed. The Tab name is the same as the others, Volume PC, Volume BW, Volume Color but with either CORP or GPS in the beginning of the tabs name.
The problem is CORP and GPS at the moment is not listed under the Region or Country column on the master so, I don't see how to populate these tabs with any new Serial Numbers. I will look into this, but I may just have to go with what you have put together for me.

[bigroo1958]

Hi XLAdept,

I have posted my workbook you have been helping me with. Since I am learning VBA, I understand a little, could you add comments to your code so I can understand your thoughts and methods, it will help me along!!

Thanks

[xladept]

Hi Bigroo,

Try this on your full book:

Please Login or Register  to view this content.

[bigroo1958]

Hi XLAdept,

Thanks so much, I am pleased with the end result, you have given me a time-saver option.
Thanks for your time and effort, really appreciated!!

[xladept]

You're welcome and thanks for the rep!

[bigroo1958]

It is showing as Solved!
You are not seeing this?

[xladept]

Hi Bigroo,

Sorry, I guess there was an inexplicable delay - yes, it shows as solved now

*I fixed that post