Adding lines when data in a column changes

Cindy · Feb 18th, 2002, 09:21 PM

How do I write a macro to insert a line at a change in value of one column?

Derek · Feb 18th, 2002, 11:35 PM

Cindy
What do you mean by "at a change in value of one column" - the total for that column, a change in a value of one cell in that column?
Where in your sheet do you want to insert your new row? Insert below the cell where the value changed?
Derek

Cindy · Feb 19th, 2002, 02:15 PM

If I have a column with employees' names, and I sort by the employees' names, I want to be able to insert a line where each employees' section ends.

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

Feb 18th, 2002, 09:21 PM	#1
Cindy New Member Join Date: Feb 2002 Posts: 16	How do I write a macro to insert a line at a change in value of one column?

Feb 18th, 2002, 11:35 PM	#2
Derek Board Regular Join Date: Feb 2002 Location: Perth Australia Posts: 1,567	Cindy What do you mean by "at a change in value of one column" - the total for that column, a change in a value of one cell in that column? Where in your sheet do you want to insert your new row? Insert below the cell where the value changed? Derek

Feb 19th, 2002, 02:15 PM	#3
Cindy New Member Join Date: Feb 2002 Posts: 16	If I have a column with employees' names, and I sort by the employees' names, I want to be able to insert a line where each employees' section ends.