software

Hi

is there a formula to remove all blank rows in a sheet all at once

Dear All,

I have a spreadsheet with 4660 rows and AutoComplete does not pick up
anything before row 4007.

I've working with two different sheets in the same workbook. The first

I want to be able to edit records in the source database that are returned to my excel spreadsheet from an access database using MSQuery. While in the the MSQuery window I can choose under records allow edit, I then can edit my records. Once I return the query to excel I lose that functionality. Is there a way to edit records using MSQuery?

I have several errors that occurs in both excel 2000 and excel 2003

I'm trying to get the cell address, not the contents, of a cell referenced
using VLOOKUP. I've tried '=CELL(quot;addressquot;, VLOOKUP(5,Table,2,false)', but

Anybody with assistance please.

I am creating an external data query in excel to reterive data from a SQL
database, one of the fields in the db is a date. When I run the query I want