Results 1 to 12 of 12

Data validation how to drag and auto fill

Threaded View

  1. 04-17-2014, 08:42 AM #1
    brad999
    brad999 is offline
    Registered User
    Join Date
    09-30-2013
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    85

    Data validation how to drag and auto fill

    Afternoon, I have data validation in a cell which has a list of strings, 1 of which references another cell. I would like to drag this across so the formula updates to a3, b3, c3 etc. However currently even if the data validation is a relative reference, when dragging across it stays at a3.

    Anyone know how to auto full the data validation??
    Thanks!
    Last edited by brad999; 04-17-2014 at 09:43 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Data Validation, drag and drop, auto population questions
    By Phouthavongc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-18-2013, 10:08 AM
  2. Auto Fill / Drag with multiple vertical rows refrencing single horizontal row
    By the4aces in forum Excel General
    Replies: 0
    Last Post: 03-21-2012, 10:18 AM
  3. Auto-Fill selection when using Data Validation?
    By duugg in forum Excel General
    Replies: 2
    Last Post: 07-31-2007, 10:34 AM
  4. auto-fill a data validation drop down list
    By carsto in forum Excel General
    Replies: 1
    Last Post: 04-11-2007, 11:56 AM
  5. drag down/auto fill
    By jeremy via OfficeKB.com in forum Excel General
    Replies: 4
    Last Post: 06-08-2005, 07:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1