Insert Row and Countif Macro
On Wednesday, March 14, 2012 8:09:13 AM UTC-5, SalientAnimal wrote:
Hi Guys/Gals,
I am a bit stuck with this Macro. And I have no idea really where to
start. I am looking for a Marco to do the following and I am hoping for
some guidance:
Insert a 2 New Rows after a specified time is exceeded.
In the first of the New Rows I the marco to performe the countif
formula
The problem I am having is the data sheet has 5 Columns. Column 2 has
the time starting from 08:00:00 running till 22:00:00. The values in the
time column however are not consistant. I need the new lines to be added
after 12:00:00, but before 12:00:01. The second row needs to be added at
17:00:00 and the third at 22:00:00.
The Countif formula for the first section should then only be done for
time 08:00:00 - 12:00:00, second 12:00:01 - 17:00:000, and third
17:00:01 - 22:00:00.
Can anyone help here? Thanks guys.
--
SalientAnimal
If you send this msg, your file, and a explanation with examples, I'll take a look dguillett1 @gmail.com
|