dependent data validation

Dear MrExcel-Community, once again an dependent dropdown question, but I haven't seen a solution (no VBA) for my problem. I've seen a couple of approaches putting values into separate ranges and refering then with INDIRET in data validation, but vor some reason I require the format you see in...

<tbody> TOM CANADA PANCAKE MACK ENGLAND HOTDOG HARDY USA BURGER TOM CHINA MOMOS MICK CANADA PIZZA </tbody> Hi, I have 3 columns , in column A I have around 220 line items which are unique words, in column B there are 433 line items which are unique. All the items in one...

Hello all, I am trying to put together a sign-off sheet of responsibilities within my organization. To do so, I've created two cascading drop-down lists via Data Validation: Independent Drop-Down: Department within the organization Dependent Drop-Down: Position in the corresponding department...

Image of (2) workbooks: https://drive.google.com/file/d/0B7BUBKK8yXCUV2c3V2NSMTlNLVE/view?usp=sharing I want to be able to compile parts data in one workbook. "MASTER PARTS LIST.xlsx" https://drive.google.com/file/d/0B7BUBKK8yXCUMnFBZDV1alFNQ2c/view?usp=sharing Then I want to create a list of...

Hello folks, I have a list of students and the classes they are taking (Sheet1) and I have a ledger (Sheet2). Sheet1: <colgroup><col><col><col><col span="3"></colgroup><tbody> Student ID Student Name Class Total Amount Total_Paid Balance 101 Student Name 1 Math 150 101 Student Name...

i want to create dependent data validation. for two different item from two different sheet, on a sin gal sheet , i have a example file with me. but i dont know that how to attached it in i am using this form first time.

So I may not be explaining my issue in the clearest way possible, and this may have been asked and answered before, but here goes. I'll try to use images to communicate better. Basically, I'm trying to create a time card for my company in Excel. Employees will need to first select a category in...

Hey Everyone! I am new here and am an intern this semester and have been tasked with something but I don't know if it is actually possible. It seems like it would be but I don't really know how to do it. I found a guide online on how to set up dynamic drop downs generally, but my supervisor is...

Hello Friends, I have two tables in one sheet. first table includes three columns and many rows and the second one also has some rows and columns. In the second table headers are "Product Name", "Price 1" and "Price 2" In first table I want to make a drop down list in first column of a row, in a...

Hi, I am still interested to know if there is a way to use 3 references for dependent data validation. Anyway, here are my predicaments: 1. I have 3 out of 10 categories that need dependent validation. For example, Present, Half-Day VL, Half-Day SL, Off, Holida, etc. 3. I need Present...