auto insert a row

mapakunk · May 20th, 2002, 07:42 AM

Here's what I have.
A_________B_________C_
Name_____Date_____Time
Joe _____05/14____7:37
Pat _____05/13____4:32

how can I run a macro that will automatically
sort by column b, then by column c. Then insert a row before each unique date with the weekday name in it.

To end up looking like
A______B______C
______MONDAY_____
PAT____5/13___4:32
______TUESDAY______
JOE____5/14____7:37

Any help has been greatly appreciated, and continues to be.

sann0638 · May 20th, 2002, 08:37 AM

Hi,
a clunky way of doing it would be to insert subtotals at each change of date, then replace the subtotals with a formula to give the date. This doesn't involve macros, though

, and I'm just thinking off the top of my head.

Rgds,Mike

mapakunk · May 20th, 2002, 09:07 AM

That's not quite what I had in mind, but thanks for trying. I know I can assign the sort macro to a button, I just really need to know how to do some (GULP) VBA scripting to locate each unique date
insert a row before each unique date
assign the Weekday name for the date
with fill color gray, font color white, and centered.

Thanks to all

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 20th, 2002, 07:42 AM	#1
mapakunk New Member Join Date: May 2002 Posts: 40	Here's what I have. A_________B_________C_ Name_____Date_____Time Joe _____05/14____7:37 Pat _____05/13____4:32 how can I run a macro that will automatically sort by column b, then by column c. Then insert a row before each unique date with the weekday name in it. To end up looking like A______B______C ______MONDAY_____ PAT____5/13___4:32 ______TUESDAY______ JOE____5/14____7:37 Any help has been greatly appreciated, and continues to be.

May 20th, 2002, 08:37 AM	#2
sann0638 Board Regular Join Date: Mar 2002 Posts: 175	Hi, a clunky way of doing it would be to insert subtotals at each change of date, then replace the subtotals with a formula to give the date. This doesn't involve macros, though , and I'm just thinking off the top of my head. Rgds,Mike

May 20th, 2002, 09:07 AM	#3
mapakunk New Member Join Date: May 2002 Posts: 40	That's not quite what I had in mind, but thanks for trying. I know I can assign the sort macro to a button, I just really need to know how to do some (GULP) VBA scripting to locate each unique date insert a row before each unique date assign the Weekday name for the date with fill color gray, font color white, and centered. Thanks to all