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.
27 freelancer menawar dengan rata-rata $28 untuk pekerjaan ini
Hello I am with more than 3 years experience and I can help you to do your job accurately, quickly and with high quality, available 24/7 to support you and promise I will meet your expectations. Regards
Hello, I am interested in your offer and I am ready to cooperate. I have experience in creating programs for entering information Excel, CSV. I have experience in writing macros Excel.