Update Query

[SHAWTY721]

I have an excel spreadsheet that contains many records and I was wondering is there a way to do an Update Query in excel like can be done in Access to update a couple values from a column.

 

[SkipVought]

Yes. Check out...

INSERT INTO table
(column-1, column-2, ... column-n)
VALUES
(value-1, value-2, ... value-n)

UPDATE table
SET column = expression
WHERE predicates

using MS Query or ADO, which will take VBA.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}