I have Sheet1 and Sheet2 tabs in my excel spreadsheet.
Sheet1 has data in columns A & B.
Sheet1 column-A1 has a column header named Food
Sheet1 column-B1 has a column header named Weight
There are ten items under the headers in each column (Sheet1 A2:A11,B2:B11).
I'd like to create a data validation list drop box Sheet2 A1. When I click on Sheet2 A1, I'd like to see the data list showing both columns in Sheet1 (A1& B1), and have it populate Sheet2 A1&B1 with the data selected.
Can this be done only in Data Validation and without Combo Boxes?
I'm open to any suggestions making it as easy as possible.
Thank you in advance!
Sheet1 has data in columns A & B.
Sheet1 column-A1 has a column header named Food
Sheet1 column-B1 has a column header named Weight
There are ten items under the headers in each column (Sheet1 A2:A11,B2:B11).
I'd like to create a data validation list drop box Sheet2 A1. When I click on Sheet2 A1, I'd like to see the data list showing both columns in Sheet1 (A1& B1), and have it populate Sheet2 A1&B1 with the data selected.
Can this be done only in Data Validation and without Combo Boxes?
I'm open to any suggestions making it as easy as possible.
Thank you in advance!