about uscontact usnewsthe teamcareersresourcessite map
   
 
question from Daniel
question asked by Daniel
date asked 07 December 2001
subject Excel lookups accross worksheets
description Chris/Bartman Remember me! Hope you're doing good. Got an Excel test for you if you don't mind. I'm trying to get a dropdown in a cell which will lookup against a row in another sheet in the same workbook and allow you to select from the values in this row. Once I've managed that bit I want to alter the the rest of the cells in this sheet to match the contents of the row in the other sheet. Does this make any sense? Drop me a line even if you haven't got a clue what I'm on about and you never know the guy here who wants this done might be prepared to fork out some cash for getting it done properly. Cheers, D

Microsoft VBScript runtime error '800a01f4'

Variable is undefined: 'sUserName'

/support/showanswer.asp, line 305