Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel adding blank rows when sorting
I have a list of customers our company sends birthday cards when they
come around. I am importing the list from Access to Excel and then using Sort to put them in order of month and then day, both descending so that I can delete everything but the month that I need. Excel puts all the customers with blank birthdate fields at the top just as it did before so I can delete them, but now below those fields it has blank rows from 2700-4139 before it begins with the January birthdays and continues on as normal. Does anyone know why this might be happening? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel adding blank rows when sorting
Wouldn't it be a lot easier to set up your Access query to extract only the
records you want? " wrote: I have a list of customers our company sends birthday cards when they come around. I am importing the list from Access to Excel and then using Sort to put them in order of month and then day, both descending so that I can delete everything but the month that I need. Excel puts all the customers with blank birthdate fields at the top just as it did before so I can delete them, but now below those fields it has blank rows from 2700-4139 before it begins with the January birthdays and continues on as normal. Does anyone know why this might be happening? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel adding blank rows when sorting
Well, of course it would! Sometimes I just do what I'm told and don't
think of ways I can improve things that were made before I got here. Thanks a bunch :) kassie wrote: Wouldn't it be a lot easier to set up your Access query to extract only the records you want? " wrote: I have a list of customers our company sends birthday cards when they come around. I am importing the list from Access to Excel and then using Sort to put them in order of month and then day, both descending so that I can delete everything but the month that I need. Excel puts all the customers with blank birthdate fields at the top just as it did before so I can delete them, but now below those fields it has blank rows from 2700-4139 before it begins with the January birthdays and continues on as normal. Does anyone know why this might be happening? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I delete blank rows from excel without selecting them? | Excel Worksheet Functions | |||
can I ad blank rows every other row to a whole excel doc? | Excel Discussion (Misc queries) | |||
(Unsuccessfully!) Unhiding Rows in Excel 2003 | Excel Worksheet Functions | |||
WHEN DOWNLOADING A TEXTFILE EXCEL DELETES BLANK ROWS - STOP THIS? | Excel Worksheet Functions | |||
How do I remove blank rows in Excel? | Excel Discussion (Misc queries) |