I have two sheet in one excel file, column A, B, C available on sheet 1 and F,G,H,I,J,K available on sheet two, i want to get count on sheet 2 G to K column, but on sheet1 A column have multiple name of one, so that i need to use it for Vlookup formula, but with Vlookup formula not give me counting on sheet2.
i also need one thing that when i put OUT on Sheet1 status column on that time i need to automatically remove that product on sheet2.
i also need one thing that when i put OUT on Sheet1 status column on that time i need to automatically remove that product on sheet2.