+ Reply to Thread
Results 1 to 3 of 3

Copying validation lists and missed references

  1. #1
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Copying validation lists and missed references

    hi Guys,

    i have 2 worksheets (ValSheet and SourceSheet) in 1 workbook.

    One of them (ValSheet) has dynamic tables with validation list like:

    SourceSheet!A1:A3

    Now i am opening 2 workbook, deleting SourceSheet from 1 workbook and copying SourceSheet (the same name) from 2 Workbook to 1 Workbook.

    Now i have ref error in my validation list in Valsheet like this:

    dartavalidation.PNG

    why is that?
    How can i move all this references together?

    Only using ranges or dynamicTables?

    Thank you for helping me,
    Best,
    Jacek

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,613

    Re: Copying validation lists and missed references

    It appears already when you delete the SourceSheet. And remains if you paste new one into workbook.

    So way to go is: Select contents of sourcesheet from workbook 2 and copy it into sourcesheet in workbook 1 (overwriting old contents).
    Best Regards,

    Kaper

  3. #3
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: Copying validation lists and missed references

    thank you !

    you have right but i have to rebuild my whole model because of it.
    Better will be place here ranges or dynamic tables.

    Best,
    Jacek

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Three Data Validation Lists: Third List works from first two Lists BUT...
    By em1335 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-07-2016, 12:46 AM
  2. Get the number of missed payments and missed payments of interest
    By chergian in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-01-2016, 08:37 PM
  3. [SOLVED] data validation lists - drop down lists too small
    By reglook0736 in forum Excel General
    Replies: 3
    Last Post: 04-24-2015, 12:49 PM
  4. Validation Lists - Multiple dependent lists with unique values
    By Lewigi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-16-2013, 06:42 AM
  5. Copying Validation Lists with VBA
    By Mmcq16 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-17-2013, 12:14 PM
  6. how to ignore blank cells in creatig dropdown lists (validation lists)
    By Elainefish in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-02-2013, 07:45 AM
  7. Excel 2007 : Copying Data Validation Lists.
    By criticalbill6966 in forum Excel General
    Replies: 3
    Last Post: 11-23-2010, 04:13 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1