Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have an xls sheet with 500 rows and 4 columns. In column B is the date for
that particular record. Is there a way that I can have xls insert a blank row everytime it encounters a change in date in colum B. For example I may have 10 records with the date 01-Sep-06, then after those 10 records that date wil be 02-Sep-06 and that may be 5 rows. I want a blank row automatically inserted after each change in date. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using COUNTIF to search for existence | Excel Worksheet Functions | |||
Date formulas | Excel Discussion (Misc queries) | |||
Automatically inserting a column | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) |