Question Locked

Insert row in Excel

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have column A which is a series of dates and I want to know if there is a formula that will insert a row when the date changes. EX:
10/1/2007
10/1/2007
10/2/2007
It would insert a row between 10/1/2007 and 10/2/2007.
Also if it could insert the word "Monday" I would be thrilled. (10/1/2007 is a Monday)

2 replies

by thumbsup2

There is no formula that will do that. But, if you are so inclined, you could learn VB script and write something that will. See the HELP features for more info.

This discussion is closed to new replies.