Search results

Dear Luftor, Apologies for the delay. This is to inform you that you are a ROCKSTAR. I tried the code & it does exactly what I was trying to do. Also I added ----Worksheets("Stock").Range("start of table", "P999").Delete---- at the start of code so that on each run it will act as refresh on...

Dear All, In the example file, there are 3 spreadsheets. The "Lot no. 1" & "Lot no. 2" sheets are used to enter all the information to manage inventory & as you can see, some items are not dispatch so the cell value is blank. Now, Can anyone please tell me a formula or macro from which i can...