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?

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?

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?