Populate Adjacent Cells From Single Dropdown

Aug 10, 2009

I have the need to create a spreadsheet that will populate multiple fields in the spreadsheet based on a drop down selection, i.e.:

In A1 I will have a drop down with 300 items. When an item is selected the next four cells will populate with predetermined data. Example:

For each person I have information that applies only to that person like so:
Bob Red Hair Blue Eyes 6' tall California
Jan Blond Green 5' tall Florida
Ian Brown Brown 5'5" Texas


If someone chooses bob from the drop down, I need the next four cells to display the information relating to bob.

View 9 Replies


ADVERTISEMENT

Populate Data In Non-Adjacent Cells (From Dropdown)

Mar 27, 2013

How to populate data in non-adjacent cells from information that is stored on another sheet. Sheet 1 is essentially setup to be visually pleasing to the user, but the data stored behind it is on another sheet stored in a more logical manner. I would like to auto-populate the nicely formatted sheet with information from sheet 2 when an item from a drop-down list is selected. I have found quite a few ways to do this using offset, etc. but in my case the values will be pulled into cells that are spread around the design sheet in no set order.

View 3 Replies View Related

Macro To Populate Cells With Formula Based On Adjacent Cell?

Mar 31, 2014

I have a spreadsheet with data populated down column B. This size will vary from day to day so is there a macro I can run that will populate Column C with a formula based on their being data in the adjacent cell.

View 2 Replies View Related

Conditional Formatting Of Adjacent Cells From Dropdown List?

Jan 9, 2013

In one column I have a drop down list of a dozen different initials with conditional formatting on those cells. I would also like to conditionally format an adjacent text string column based on those initials, but don't want to set up a dozen rules on each cell, one by one. If I set up the top cell with the correct rules I cannot fill the formatting in because the formula is not updated on a row by row basis, but en bloc for the range.

View 3 Replies View Related

Using Dropdown To Populate Cells

Aug 11, 2009

I am trying to populate cells based on dropdown boxes. The data is on one worksheet and needs to be populated in cells on the main worksheet based on information in the two dropdown boxes. I have included my worksheet for reference.

View 2 Replies View Related

Dropdown List To Populate Cells?

Mar 18, 2014

I have a drop down list with 6 recipes. When I select chocolate for example I want that to automatically populate different cells in the worksheet based on a standard I have created for that recipe. The recipes won't change they just have different ingredients and I want that to show up depending on what I select on the drop down list. I went into VBA and worked a little with this starting code:

If Target.Address = "$F$3" Then
Target.Offset(0, 1).Value = "1"

but It wouldn't populate separately based on what I had selected in the drop down it would just populate all 6 recipes the same.

View 4 Replies View Related

Auto-Populate Cells Based On Dropdown?

May 27, 2014

The file is attached here. I would like to be able to autopopulate cells based on a dropdown. The first tab has the final report and the other 2 tabs are the raw files.

KMPH_Inventory.xlsx‎

View 1 Replies View Related

Auto Populate Cells From Dropdown List

Dec 16, 2013

I am looking to auto generate a roster/schedule. I have a spreadsheet with shifts for each weekday that I need to populate every week with names to pick from a drop down list. the drop down list is made using data validation and looks at a dynamic named range to allow me to select only the people who are available to work a certain shift.

Is there a way to do this using vba?

View 3 Replies View Related

Automatically Updating Adjacent Cells Based On Dropdown List Selection Even If Changed

Apr 12, 2013

I have a workbook that has two worksheets. One worksheet is an input worksheet. A user will select a date from a drop-down list and type in the events that occurred on that date in 8 adjacent cells. The user selects a button that advances date and clears form. On sheet 2, whatever was typed into sheet one is saved via VLOOKUP formula. However, if I try to change something retroactively and select a previous date from the drop-down list, it clears everything in sheet 2 that was typed for any selected day.

View 1 Replies View Related

Excel 2010 :: Dropdown Box Choice To Populate Next 2 Cells?

Jun 6, 2014

But for the life of me, I can't get it to do what I need it to do. Excel 2010 user, and I've attached my file with the information, and descriptions.

View 5 Replies View Related

Copy Non-adjacent Cells In A Row From One Spreadsheet To Adjacent Rows In Another

Jan 5, 2014

I have a workbook with 30 worksheets. Each sheet has 84 rows of data (start in 15 columns (A to O). I would like to create a summary sheet that only shows the most important data from each sheet.

The summary sheet would have 12 lines of headers and formatted crap at the top.
The Summary sheet header columns would be:

Site (A), Date (B) Health (C), Status (D), Critical (E), Task (F),
Dependencies (G), Owner (H), T-Date (I), Task Date (J), Mitigation Date (I)

The data in the sheets are not in that order, of course.

That
1. puts the name of the sheet I am copying from in column A
2. the deadline date in Column B (that date is always in C10 of each worksheet)
3. and copies Cells from Column A,B,G,H,I,O in any row in which the value in A is not "good" into columns C through H. I would like to paste those rows into the summary sheet. I have code that loops through the sheets and rows in each sheet to find the rows to copy. I can copy cell values directly from the active sheet to the summary sheet, but because I am copying a cell at a time, it takes 7 minutes. Yes I am impatient :)

Here is the code snippet where the copying is done:

Dim sh As Worksheet 'current worksheet
Dim DestSh As Worksheet 'worksheet in which to paste summary
Dim Last As Long
Dim CopyRow As Long 'row to copy
Dim LastCopyRow As Long

[Code] ........

ExitTheSub:

Application.Goto Sheets("KMARollup").Cells(1)
End Sub

I think there must be a way to use ranges to build an array of cell values and paste only once but I am lost here.

View 2 Replies View Related

Populate Adjacent Cell Based On Pull Down Choice

May 14, 2008

I have three hidden columns (Text only) one column with Parts, then Description, then Cost. I have a pull down menu (i.e. Cell 3, A) listing all of the choices in the hidden Parts column. I want to automatically populate Cell 3, B with the corresponding Description when a Part is chosen from the pull down menu, and the same in another column for the Cost.

I am using Excel X for Mac, in OS 10.5.2

View 4 Replies View Related

Creating Dropdown Which Changes Adjacent Cell Data?

May 16, 2013

I'm revamping a key inventory for my company and would like to be able to track the history of each key (name of person who it was issued to, date issued, date returned). I figure the best way to do this for the 90 keys I currently have in circulation is to create drop down lists for each key that has been used by more than one person in its history and upon selecting a given person from the drop down list of keys used more than once, the adjacent cells would populate with the corresponding data of date issued and date returned. Some keys have not been used more than once so not every key will have a drop down. Here is what my key inventory spreadsheet looks right now.

View 3 Replies View Related

Attaching Row To Single Cell So That They Stay Adjacent On Worksheet

Jul 10, 2013

I've created an excel workbook with multiple sheets. One of the sheets is the "Master Sheet" and I used the formula =INDIRECT("'Master Sheet'!A"&ROW(A2)) so that columns A and B on every sheet match exactly what I input into the A and B columns on the Master Sheet. I used this formula because it would allow me to insert rows on the Master Sheet and have that reflected in the other sheets.

However, I've realized that this means the data I am inputting on the other sheets gets misaligned because if I make a change on the Master Sheet it the A and B columns on the other sheets, but all the rest of the columns on the other sheets stay where they are. How to make the rows shift up and down together on the other sheets.

View 3 Replies View Related

Comments In Dropdown Box Dependent On Number Selected In Adjacent Cell

Jul 8, 2013

I have been asked by my supervisor to make a performance review template a little bit more user friendly.

Basically what I have is a drop own list in cells in one column (various cells with the same drop down menu) that you select from either 0-10 in a drop down box.

I have another cell which I want to have a drop down box with text comments that you select from when. Only problem is the comments different dependent on the ranking score you give a person (the number selection in the previously mentioned cell from 0-10). So if you have a score between 9-10 in the cell then the comments box will give you certain comments to choose, 7-8 different comments and so on and so forth.

View 1 Replies View Related

Enter A Value In A Textbox, Search For It In An Worksheet, And Populate Other Textboxes With Adjacent Values If The Value Is Found

Jul 14, 2007

I want to enter a value in a textbox, search for it in an worksheet, and populate other textboxes with adjacent values if the value is found. Anyway, the problem is that if the value is not found, I get a debug error.

Dim test1
test1 = TextBox1.Value
Worksheets("data1").Activate
Find_Range(test1, Cells, xlFormulas, xlWhole).Select
TextBox2 = ActiveCell.Value
TextBox3 = ActiveCell.Offset(0, 1).Value

I'm sure there's far better code to do what I need, but I tried to keep it simple. With the above code, it only works if the value is found. If it's not, I get an error. So how do I make it so that if the value is not found, the value of the textbox2 is "Not Found" or something...

View 3 Replies View Related

Pick Table From Dropdown And Populate On Other Sheet?

Apr 10, 2014

From the excel spread sheet, while selecting from the drop down list (Deployment Model) from attached Workout sheet, the corresponding table should be highlighted from given tables and populate the same table in the Recommendation sheet from the same excel.

I am attaching sample sheet for your reference and easy understanding about the requirment.

Activities to be carried out:

Go to Workout (Sheet) --- > Select from drop down list (C2) -- > Based on Projection Volumes, list ----> It should highlight the corresponding table from below --> Pick up that particular table and Populate the same in Recommendation sheet (with out formulas, only values should come in tabular format)

View 10 Replies View Related

Simple Auto Populate Cell From Dropdown?

Dec 16, 2013

Every time a name is selected in column C12:C15, I need that respective row to populate with $10 in column J. When column C12:C15 is blank, I need that respective row to read $0 in cloumn J. It's either one (10) or the other (0).

There are rows above and below it as well that have nothing to do with this, so the formula/function would be specific to just this subset of rows (rows 12-15).

I get close, but can't seem to nail this simple formula/function down. I am unable to download any sheets due to my work's firewall.

View 6 Replies View Related

Populate Data Based On Dropdown Menu?

May 14, 2013

I have a list of staff in cell A1 in a drop down list. In cell A2, I would like Excel to populate automatically the branch from which the staff is from when I choose the staff name in cell A1.

View 3 Replies View Related

Auto Populate Multiple Dropdown Boxes

Apr 3, 2007

I have 3 dropdown boxes I created using the control toolbox which pull corresponding information from 3 different columns. I would like to be able to format them so that upon data entry in the first dropdown box, the subsequent two boxes auto populate with the corresponding data. Currently I have to select the information for each dropdown box manually.

View 6 Replies View Related

Populate Cell Based On A Dropdown Selection Of Another

Jan 25, 2008

I found many examples on this forum of how one can pull in data from closed workbooks, or copy it and have it stored in the active sheet. So far so good, but I need a solution which would do the opposite - I need the macro to take a range of data form the active sheet store it in a closed workbook and save any changes in the target workbook without opening it.

View 2 Replies View Related

Populate List Based On Single Cell?

Apr 8, 2014

When I enter a value for 'Number of Steps' from a drop down a table is generated with the x values changing accordingly.

For example:

Number of Steps 5

x x^2
------------
0 0
1 1
2 4
3 9
4 16

Number of Steps 9

x x^2
------------
0 0
0.5 0.25
1 1
1.5 2.25
2 4
2.5 6.25
3 9
3.5 12.25
4 16

You will notice that the number of steps is the number of x values that take us up to 4. The 4 is fixed. I would be able to work out the maths myself as I am a maths teacher but I was wondering how I could autopopulate the table based on a drop down box selection. If it involves going into VBA then don't worry my son needs to get to grips with what I have done.

Edit. The formatting does not seem to work above. On the left of each table is supposed to be the x value and on the right is x^2.

View 7 Replies View Related

Populate Data In Table Based On Dropdown Criteria?

Jul 7, 2014

I've been trying to get a table to populate based on a couple of criteria. However, I've not come-up with the solution yet.

I have my dropdown selections in cells C2 & C3. The objective is to populate the table below the dropdown with data from the sheet named (very unimaginatively) 'Data'. Currently you see the selection AA-11 & Mar-14 in the Contract ID & Month cells. If I change this, the table below should auto-populate.

I've attempted using Vlookup, Index-Match. But it does not give me the desired result.

Also, the number of Products can change each month (although the file shows 4 for each month & each Account).

View 4 Replies View Related

Remove Duplicates And Populate Items Based On Dropdown?

Feb 10, 2014

I have an excel sheet with data where I have column A index number, B company name, c empty, d data , e with item.

[Code] ......

What I trying to do is I made a dropdown for company list and i select comp1 then i want to populate items list with out duplicates .

View 2 Replies View Related

Auto-Populate Field Based On Dropdown Box Selection?

Jan 20, 2013

I have a dropdown list selection on the form for types of machines. The list of machines, their sizes and related noise level are in a chart on worksheet 2 and I'd like to automate the form so that when the machine is selected, the related noise level auto populates.

The dropdown box has been put in the form using the data validation function.

View 7 Replies View Related

Selection Using Dropdown - Auto Populate Another Cell With Information Associated Only

Feb 9, 2012

If I make a selection using a drop down, can I have it auto populate another cell with information associated only to the made selection? For instance, if I select January from drop down in A1, I want it to auto populate B1 with 100.

View 2 Replies View Related

How To Get Multiple Dropdown Lists To Populate Results In Named Cell

Sep 28, 2012

I was just given a task at the office of creating a in depth excel spreadsheet. Here is what I need:

I have one drop down list that represents the state a person lives in.
I have another drop down list that represents the the type of property it is.

If you select CA in drop down 1 and Multi Family in drop down 2 you get the end result in (specific) cell.

Then if you select AZ in drop down 1 and SFR in drop down 2 you get different end result in named cell.

How can I get items within 2 different drop down list to call up the end result in a 3rd cell?

View 1 Replies View Related

Auto Populate Fields Based On Model Number In Dropdown?

Mar 14, 2014

I have the catalog #s of some products in column A, and I have the brand in column B, Product name in Column C, and the model # in Column D. I want to create a formula that if I select the catalog # it should autopopulate the brand in column B, product name in column C and the model # in column D!!

And I have the brand/product & model # in a different sheet!!

View 6 Replies View Related

Populate Master Sheet Based On Dropdown Selection That Selects Other?

May 2, 2014

For example, I have a master sheet that has a drop-down list of the months January and February, which have their own sheets. I am trying to populate the sales of the week 1, 2 ,3 ,4 in the master sheet based on the same data for the month chosen.

View 2 Replies View Related

Auto-Populate Data Depending On Selection From Dropdown List

Jan 21, 2013

How to populate MTD data linked to the other spreadsheet file (monthly data) to the table on the left, depending on the month selected month from the dropdown list.

Attached files for reference :
Dropdown Month.xlsx‎
MONTHLY DATA.xlsx

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved