N
NickDangr
There's a nice booksamillion right down the street - I'll be checking
that in the next week or so.
Does anyone have some good online references for vbscripts in Excel?
I'm somewhat familiar with programming - here is what I wish to
accomplish.
Below is some table data - I've added the rows and columns for
reference.
----------------------------
A B C D
Negative Date
Quantity Last
1 Location On Hand < 0 Leader Upd
------------------------------------------------------------------
2 Store 01 0 2 Date
3 Store 02 33 |
4 Store 03 85 |
5 Store 04 2 1 V
6 Store 05 6 2
7 Store 07 18
8 Store 08 15 1
9 Store 10 32
10 Store 11 1 2
11 Store 20 24
12 Store RO 184
13 Warehouse 12
------------------------------------------------------------------
14 Total Negative Quantity Items 412
Once per day, I refresh the data of the table (which updates the
negative quantity on hand counts). The negative quantity leader (NQL
from here on) column does not change with the refreshing of the data
(yet). I'm physically incrementing the NQL by 1 each day. I just know
there's a way to automatically update that column's count with some VB
scripting... I just am not familiar enough with that side of excel to
impelment it.
Here's the algorithm I put together.
-----
Refresh the worksheet data at 11:00am
Negative quantity counts update to reflect current numbers
Check to see if the date in column D reflects today's date
If not, Update Column D to reflect today's date, if
so end.
Check to see whether values in column B2-B13
are less than or equal to 10
If not, color the contents of the cell
black, if so, add 1 to the count in column C color the text red
-----
Mainly I want to be able to refresh the table any time during the day to
show how many negative quantity items exist at each store (this checks
inventory counts through a database), but once a day (at 11am) I want to
have the worksheet refresh the last column so I can send out a pat on
the back to my stores through e-mail.
Is this fairly simple? Complex? Any help of course would be
appreciated.
that in the next week or so.
Does anyone have some good online references for vbscripts in Excel?
I'm somewhat familiar with programming - here is what I wish to
accomplish.
Below is some table data - I've added the rows and columns for
reference.
----------------------------
A B C D
Negative Date
Quantity Last
1 Location On Hand < 0 Leader Upd
------------------------------------------------------------------
2 Store 01 0 2 Date
3 Store 02 33 |
4 Store 03 85 |
5 Store 04 2 1 V
6 Store 05 6 2
7 Store 07 18
8 Store 08 15 1
9 Store 10 32
10 Store 11 1 2
11 Store 20 24
12 Store RO 184
13 Warehouse 12
------------------------------------------------------------------
14 Total Negative Quantity Items 412
Once per day, I refresh the data of the table (which updates the
negative quantity on hand counts). The negative quantity leader (NQL
from here on) column does not change with the refreshing of the data
(yet). I'm physically incrementing the NQL by 1 each day. I just know
there's a way to automatically update that column's count with some VB
scripting... I just am not familiar enough with that side of excel to
impelment it.
Here's the algorithm I put together.
-----
Refresh the worksheet data at 11:00am
Negative quantity counts update to reflect current numbers
Check to see if the date in column D reflects today's date
If not, Update Column D to reflect today's date, if
so end.
Check to see whether values in column B2-B13
are less than or equal to 10
If not, color the contents of the cell
black, if so, add 1 to the count in column C color the text red
-----
Mainly I want to be able to refresh the table any time during the day to
show how many negative quantity items exist at each store (this checks
inventory counts through a database), but once a day (at 11am) I want to
have the worksheet refresh the last column so I can send out a pat on
the back to my stores through e-mail.
Is this fairly simple? Complex? Any help of course would be
appreciated.