autopopulate

I have two worksheet. One worksheet is a form where in the Field Door No. should be a dropdown list. The list will be retrieve from worksheet Source. Now upon selecting a specific Door No. it should also autopopulate the respective Type, Brand, Serial No., and Type. First thing i need to know...

Really needs some help. I have 2 worksheet in excel, first worksheet called "inventory", and second worksheet called "consumption". The inventory worksheet is the big list of items that we have in store(ex: apple, mango, grape, orange, carrot, banana etc up to 200 items). In this worksheet...

Hello, I need help. I am creating an excel sheet where I have a list of names and dates to correspond with each of those names. Now, I have another sheet where I want an autopopulated list of those names and dates that are within a range of days since the original date. For example, I own a...

Private Sub Command44_Click() Me.Comments = "Workflow" End Sub None of these options have worked. I could have so many uses for this functionality; however, I can't get it to work... right now. I really want to do this with a button (not a query, if statement on the text box, etc.). Any...

I have a 500 row Excel table that I need to figure out a script for. Column 1: First Name Column 2: Last Name Column 3: Employer Column 4: Email (I want this to autofill based on a VBA script) Assuming a known given email syntax for "COMPANY" - firstname.lastname@company.com, and my columns...

Hey there, I'm trying to make a dependent list auto populate based on the first selection. I understand how to make dependent lists. How do i make the list in column a, auto populate columns b & c based on a? Example: If column a is named Dept and lists: Science, Engineering, Communications...

Hey folks, I've run into a bit of a conundrum, and I'm hoping you can help me. I have a chart that lists various employees, and how much they charge for 3 different types of clients. The three types of clients are large, medium, and small businesses, and each of 14 different employees bill...

PLEASE don't shoot me if this is a repost... Searched the threads and didn't get any hits back on this particular issue. I have a Userform which I've managed to get to Populate my worksheet perfectly... i was also able to get it to repopulate back onto the userform for editing. (the sheet...