Excel VBA - Import File and Compare Sheets

I've making some changes and reached out this far... alone, which is nice
Although some help might be needed...

Please Login or Register  to view this content.

The code reads each row and goes to the sheetname based on cell value. Compares rawName cell value with sheetname cell value. If is not present, its copies B:J from rawName to C:K in sheetname and adds an "Added" value to last column L for reference purposes.

Aside the obvious, one of the issues is that lastrow on rawName is different than lastrow on each strName

Any ideas?

Thanks for the tip, it helps on selecting the right sheet however its still causing issues

The rawName sheet contains 2k rows, which contains devices that are or will be stored in the other 5 different sheets.
When I run the code it shows the 2k-ish rows that are stored in the rawName.range and then for each strName sheet shows 1048576 rows, instead of the 800 or 300, or 20 rows that each different sheet has.

Also I'm experiencing an issue when copying the values on "c.Range("B" & i & ":J" & i).Copy" its only retrieving rows E:J
Tried to change it to:

Please Login or Register  to view this content.

With no luck at all...

File is attached for a little more in depth approach
Thanks again for the assistance!

Excel file

Hello folks,

I'm still working on this, I was able to figured out the addition of new items and went all the way thru to items being removed and a tracker process.

However rows are now being duplicated and not properly updating (on either adding or removing process).
I've hardcoded the worksheet.count to avoid working outside the range, but still getting issues with others sheets of the same workbook

This is the code for the items being added, the idea behind this is that each sheet name is stored in a column of rawName then reading and cycling thru each row and each sheet, reviewing values from rawName towards the other sheets, if missing then copied and labeled as added.

Please Login or Register  to view this content.

This is for the items being removed, same as before, sort of reverse engineering all sheets values againts rawName, if missing then labeled as removed.

Please Login or Register  to view this content.

And this is the comparison process that reads all L column values, copy the row and removes when required.
Cycling thru sheets, reviewing L column values from sheets 4 to 8 that excludes rawdata and 2 more sheets.
If any "Added" value is found the cells are copied and arranged to the tracker, and the label is cleared.
If any "Removed" is found, then as before the information is copied and the entire row is deleted from source sheet

Please Login or Register  to view this content.

Attached is the current work file, with dummy values on all sheets, which after I run the process that calls all subs, several rows get duplicated by the end of it.
I know this is not rocket science, but maybe a fresh look will help me see thru the issues.

Work, Updated File

Thanks in advance for any tip! And as always, sorry for the trouble...

Sadly I'm having a code that works partially ok, meaning that the code reads and is able to copy some of the needed rows.

Please see code below

Please Login or Register  to view this content.

This code will read the rows being added from NIKE towards the rest of the workbook and add them if not present, afterwards I will copy them to the tracker sheet (Currently adding all to their respective sheet but not copying'em all to the tracker sheet)

And below is the opposite code..

Please Login or Register  to view this content.

This one will do it backwards, comparing the currently existing rows and if any of them is not present in NIKE sheet will remove it from its current sheet and copy to the tracker sheet. (This is almost not working at all... dunno why!)