I just tried recordin the macro again and this time it worked.

I end up typing it in several different columns, in several different
worksheets every day, looking for information on different sheets, typically
dragging it down anywhere from 300 lines to 6500 lines, depending on the
sheet I'm working with.

"ward376" wrote:

You only have to enter them once... then you can copy or fill the
rest. Are you typing/using the function wizard to enter the vlookups?

Cliff Edwards