+ Reply to Thread
Results 1 to 3 of 3

data validation between 2 workbooks is possible?

  1. #1
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    data validation between 2 workbooks is possible?

    Hello to all.
    Data validation between 2 workbooks is possible?
    max

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: data validation between 2 workbooks is possible?

    Did you try it?

  3. #3
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: data validation between 2 workbooks is possible?

    I added data validation between cerca_search and cartel1
    When starting search_search, you open cartel1/2/3/4.
    At this point I stuck to do this type of copy paste between the various workbooks


    in search_search in c2 a drop-down menu linked to Cartel1 column A range A2: A30

    here I choose example "collo2" of Cartel1 (line 3) and must paste the values of row 3 C3-F3 in search_find in D9-E9

    in search_find in D10- F10 must paste the values of line 3 of cartel2 D3-I3

    in search_find in D11- F11 must paste the values of line 3 of cartel3 F3-J3

    in search_find in D12- F12 must paste the values of line 4 of cartel2 B3-L3

    practice you must paste the data highlighted in yellow from Cartel1/2/3/4 in cerca_search

    Attach zip file with the 5 files.
    I hope I explained myself
    max_max
    Attached Files Attached Files

+ 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. Replies: 1
    Last Post: 01-14-2018, 11:04 AM
  2. how to do data validation across workbooks
    By dmcgov in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-08-2017, 10:52 AM
  3. Data Validation between Workbooks
    By slumeet in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-20-2011, 05:50 PM
  4. Excel 2007 : Data validation between workbooks when moved
    By Severnfisher in forum Excel General
    Replies: 1
    Last Post: 04-26-2011, 09:03 AM
  5. Validation across already created Workbooks
    By dshilan in forum Excel General
    Replies: 3
    Last Post: 03-29-2011, 06:27 AM
  6. Problem:Data validation using if statement in two workbooks
    By apoorvagala in forum Excel General
    Replies: 1
    Last Post: 05-25-2009, 03:12 AM
  7. Data Validation between open Workbooks
    By caldog in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-04-2005, 09:55 AM

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