Cycle Count Help

Hey all,

I'm new to the forum but I have been reading post for a very long time.

I have decided to change the way we do cycle counts to get more of a flow. I'm just now learning about Visual Basic in Excel so I'm looking for some pointers.

I pull data into excel which includes last date cycle counted in A2. We use VOL rules with V being the fast moving product and L the slowest. I have the VOL split into a sheet of there own. V's we count 4 times a year. O's twice a year and L's one time a year.

I'm using networkdays to find how many working days we have in a quarter. I want the program to take the Last Cycle Count date - Today's date and if the sum => 1st quarter it will copy that row to a new sheet. This would be on the V's of course. Each quarter it would need to look at the next quarter for updated days.

The same would apply for O's and L's just using a little different =>

I'm having to use text to columns each time I refresh data because the date is coming in looking like 20111112. We are using an old AS400 system.

Anyway thanks for any help offered. Visual Basic seems to be very powerful and I'm sure I will figure it out once I read a few books.