I have two columsn of data, a1 = left (b1,6). Column b comes from an
ODBC query.

So, the data will look like this:
A B
1 F12345 F123456
2

But when I click the query in column b and updated the column,
column A will not automatically go down one row and copy the
formula, it will look like:
A B
1 F12345 F123456
2 F234567

How to make A2 automatically update itself?