Hello there
I am trying to realize a procedure to obtain a quick search for some codes I have I a small warehouse.
Basically, I have six worksheets where I have, on two different columns each,
the code, the quantity, the shelf
where it is stored.
what I have been asked for is:
given the shelf, to have got back all the codes and quantity that there are in this shelf.
My Idea is:
in a sheet called <<initial>>, create a cell where I write the value of the shelf (this value in a text).
Then, with a VB procedure, start activating first worksheet, start reading the first column.
if the shelf value corresponds to the required shelf, then activate a sheets called "Results" and write there all the value corresponding to code and quantity.
Then, when ended the column, I would move to the second column.
Once ended the second column I would activate the second worksheet.
But I am having some problems since the beginning, since I have problems in reading the value of the shelf column.
question 1
I am attaching how I have started to wrote the procedure
Please can anybody tell me why I can read the value of the cell ?
question 2.
If anybody has a simpler or smartes way to solve this topic, it is welcome !
Thanks !
Bookmarks