I'm not sure why the offset formula isn't producing the result you want. I

have 50 names on sheet 1 and they all come in to sheet 2 OK. Just make sure

that you have "$" around the address of the first name in sheet 1 i.e.

Sheet1!$A$1. Also make sure that all your merged entries contain 3 rows, if

they don't, the formula will not work.

To explain (Row()-1)/3,0):

The zero tells OFFSET not to move across any columns becuase the names are

all in the same column on sheet 1.

(Row()-1)/3: Because we have our cells separated into 3's we have

inadvertently created an arithmetic series. So to correctly reference sheet1

we must correct the offset. ROW() returns the top-most row number of the

merged cell range, then we always need to subtract 1 to ensure that the

result is always devisible by 3 because a spreadsheet starts at row 1 not row

0. Using an example. The second name which is in row 2 on sheet 1 must appear

in row 4 (top-most row of the merged cell) of sheet 2. So to achieve this, we

take 4-1 = 3 then divide by 3, now our offset formula offsets the original

cell A1 by 1 row to A2. The next name is in row 3 on sheet 1 but must appear

in row 7 on sheet 2, so 7-1 = 6 then divide 3 gives 2, so OFFSET must move

two rows down from the orginal cell of A1 to A3 and so on.

When you get the data from Access you should see a screen to "link" to the

database. This screen also gives you the options to specify how the

spreadsheet updates from the database. Not sure what else to tell you here,

there's no need to write a macro.

If this helps please click "Yes"

<><><><><><><><><><>