data validation when list is on a different worksheet? 2003
-- Please help, I am trying to use data validation on sheet1 but the list is on sheet 2 In sheet1 b1 column name is account code. In sheet2 colume A are Account code and sheet2 Column B are the corresponding Account names. What need to do is before I encode on Sheet1 Column C the invoice numbers I need to select first the correct account code and account name. Please help. joromajr |
data validation when list is on a different worksheet? 2003
You need to name the range on sheet2, InsertNameDefine..., and use that
range name in the DV. -- __________________________________ HTH Bob "joromajr" wrote in message ... -- Please help, I am trying to use data validation on sheet1 but the list is on sheet 2 In sheet1 b1 column name is account code. In sheet2 colume A are Account code and sheet2 Column B are the corresponding Account names. What need to do is before I encode on Sheet1 Column C the invoice numbers I need to select first the correct account code and account name. Please help. joromajr |
All times are GMT +1. The time now is 02:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com