Refrashing Data

[judge]

Hi, I am hoping someone can help me with an issue I am experiencing wit
Excel.

I have a spreadsheet that is connected to an SQL database, this i
extracting certain information. However, I have created my own colum
so I can add further information, but every time I press the refres
button and a new record(s) has been added then all the rows move dow
expect my “manual column” – example below.

Column A > C - automatically updated
Column D - manual

Column A | Column B | Column C | Column D
1 John Day 35 Employed
2 Bill Dugmore 23 Contractor
3 Fred Ross 55 Employed
4 Matt Miller 20 Contractor
5 Simon Campbell 21 Employed

When I press refresh it looks like this:

Column A | Column B | Column C | Column D
1 John Day 35 Employed
2 Bill Dugmor 23 Contractor
3 Frank Coughlin 35 Employed
4 Fred Ross 55 Contractor
5 Matt Miller 20 Employed
6 Simon Campbell 21

As you can see above, Col A > C has moved down correctly (once).
Unfortunately Col D hasn’t moved so the data is now incorrect. This i
OK (but not ideal) to manage when you have 1 or 2 records but when yo
have 100+ being added in various positions it becomes "very" hard t
manage and creates incorrect information.

So my question is this, is there are why of associating manual column
(Col D) to the other three columns – I want to be able to press refres
and then all (including any manual cols) move down all together.

I hope this is clear

 

[mrice]

Here's one way.

Create an extra column which contains the concatentated values in th
first 3.

e.g. = A1 & B1 & C1

Create a copy of this column and adjacent to this add the column o
your own comments.

Then use the VLOOKUP function to tie the comments back to their correc
lin