Any Excel experts?

Big Mike

I am Big, I am Mike
Staff member
Supporting Member
Joined
Dec 16, 2003
Messages
33,896
Reaction score
1,853
Location
Edmonton
Website
www.mikehodson.ca
Can others edit my Photos
Photos NOT OK to edit
At work here, we use an Excel spreadsheet to keep track of the drawing numbers we assign to certain customers or projects.

It's up to around 3500 entires, so we use the Auto filters to quickly seach the columns.

We just found out that the auto filters are not searching the whole data base. For example, each line has a number cell, If I click the autofilter pull down above the number collumn, it only shows me the first 1000 numbers or so.
 
OP
Big Mike

Big Mike

I am Big, I am Mike
Staff member
Supporting Member
Joined
Dec 16, 2003
Messages
33,896
Reaction score
1,853
Location
Edmonton
Website
www.mikehodson.ca
Can others edit my Photos
Photos NOT OK to edit
Thanks :thumbsup:
 

Most reactions

Top