Insert a blank row

[anon]

Hi,
I need some help to insert a blank row in a range where column A has a
series of dates. There will be several of the same dates and I need to both
sort the dates and then insert the blank row at the end of each sequence. In
the blank row I need to total figures that will be in columns B through to
G.
Thanks,

Jim S

 

[Frank Kabel]

Hi Jim

maybe an easier solution
1. Sort your data (use 'Data - Sort', e.g., column A ascending)
2. Use 'Data - Subtotals' This will insert a row after each date and
calculate subtotals automatically for you

HTH
Frank

 

[David McRitchie]

Hi Jim,
Frank's answer is essentially he same as you got in another newsgroup,
meaning many people whether they answered or not read your question
twice and either Frank or Harald might have made better use of their
time doing something else had they known the question was already answered.