Insert a blank row

  • Thread starter Thread starter anon
  • Start date Start date
A

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
 
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
 
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.
 
Back
Top