I use a sheet that must be updated every two weeks. The macro copies the sheet, clears the data ranges, calculates the next pay period dates and renames the sheet to Time Sheet (2).
The macro works great for my needs though it probably is not as efficient as it could be but I'm only now trying...
Scenario (and this is the "simplified version."
Sheet 1 has the numerical date to be charted:
A B
1 Field No. 12
2 HEIGHT ppm (NO3-N)
3 17 20000
4 21 9000
5 29 17000
6 31 7100
7 36 3800
8 37 12000
9 39...
Ok the scenario is:
Column F Class Date (date of next class)
Column G Date Books Need to be Ordered (Wed approx, 2 weeks prior to class)
So no matter which day of the week the class is on (Mon-Sat); books have to be ordered Wed, two weeks prior.
I.E.
col F = 2/14/04
col G = should read...
I have a lady friend who has 5 PCs in her office connected through a router, all work fine and everyone can go weherever they please on the internet with one noticable exception:
All PCs can connect to a remote URL but hers. Hers gives a DNS error. I reviewed all the settings in TCP/IP and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.