J
JMageeirbc
Sorry that the subject is vague but, I was wondering if the following
is possible. I have a spreadsheet that I maintain that holds a years
worth of data. It is very similar to the following:
Name QTY Item Status
Name, one 1 Item one
Name, two 2 Item one
Name, three 1 Item two
Name, four 2 Item one
What I would like to be able to do is to count the items that have
come in and place that figure into an input box. And then mark that
particular amount as being received.
So let's say that 1 item one has come in. I would like to put
received
in the corresponding Status cell. It would get tricky if only 3 Item
ones came in. I would like to based on a total in the qty column
place
received in the corresponding cells as shown below:
Name QTY Item Status
Name, one 1 Item one Received
Name, two 2 Item one Recieved
Name, three 1 Item two
Name, four 2 Item one
Is there a way to do this via VBA? One more note is that I am using
autofilters.
If there is a way to do this I would greatly appreciate the
assistance.
is possible. I have a spreadsheet that I maintain that holds a years
worth of data. It is very similar to the following:
Name QTY Item Status
Name, one 1 Item one
Name, two 2 Item one
Name, three 1 Item two
Name, four 2 Item one
What I would like to be able to do is to count the items that have
come in and place that figure into an input box. And then mark that
particular amount as being received.
So let's say that 1 item one has come in. I would like to put
received
in the corresponding Status cell. It would get tricky if only 3 Item
ones came in. I would like to based on a total in the qty column
place
received in the corresponding cells as shown below:
Name QTY Item Status
Name, one 1 Item one Received
Name, two 2 Item one Recieved
Name, three 1 Item two
Name, four 2 Item one
Is there a way to do this via VBA? One more note is that I am using
autofilters.
If there is a way to do this I would greatly appreciate the
assistance.