I created a product price list with different headings within columns in
workbook1 sheet1. (The reason for this was because I wanted to be able to
easily print the price list without having a rediculous amount of pages.)
So, for example, the data under one heading may be in column A and go to the
end of the page and then start back up againin column D at the top of the
page. I want to create a dropdown list using data validation in workbook2
sheet1 using data from two or more lists in workbook1 sheet1. I keep getting
the error: "The source list must be a delimited list, or a reference to a
signle row or column." Is there a way around this? The data I want for this
drop down list could come from multiple columns, rows, etc., and not
congruent. Can I achieve this without creating a new list in workbook1 from
the data I want? If I have to do that, I feel I might as well rewrite the
entire list.