I want to compare current stocks with new stock counts. First page is my current stock list(Page name "Eldeki"). Second page is new counts(Page name "Sayim"). I want a macro that checks first “Seri numarasi”, if serial number is find on the Eldeki page, it checks the Madde kodu, then Ambar, then Konum, then Fiziksel stok.
If all item is found and correct on the Eldeki page, open a new page called "Dogru Stok" and write the details to that page. If item is not found on the Eldeki page, open a new page called "Eklenecekler" and write the details to that page. If item is not available on the Sayim page but is available on Eldeki page, open a new page called "Cikartilacaklar"and write the details to that page(fiziksel stok number multiplied by “-1”)
If everything is correct but fiziksel stok number is different;
[(eldeki page fiziksel stok) – (sayim page fiziksel stok should be made)]x-1 and details should be written to “Cikartilacaklar” page.
An example is in the attached excel file please see it.
20 freelancer menawar dengan rata-rata $25 untuk pekerjaan ini
Hello, I am Excel and VBA expert. I can complete this project for fixed price $30. Please note that I have 100% completion rate and 5-star feedback on 60 projects.