Here is an easy way from John Walkenbach...
http://spreadsheetpage.com/index.php...ies_in_a_list/
--
Jim Cone
Portland, Oregon USA



"Manky"

wrote in message

I have a database that has only the user id field on the 1st record and i
need to fill in the user id on the subsequent records. until it hits the next
User ID, in the following example i need user ID 100 to be copied into the
next 2 rows
-snip-