Cant Pull Data From Another Sheet After Drop Down List Selection From Another Sheet

Jul 31, 2009

I have an excel workbook with two sheets. Sheet 1 has a list of people names, rank, address, and phone numbers. Sheet 2 has boxes where a user can select a last name from all last names in sheet1. What I want to happen after the user selects the last name in sheet 2 is for it to automatically fill in the rest of the data (ie Rank, First Name, Address, city, Home phone number, Cell Phone number). What do I need to do in order for this to work?. Attached is a very small example of my much larger project.

View 3 Replies


ADVERTISEMENT

Pull Data From Others Sheets Using Drop Down List To Select Sheet Name?

Sep 29, 2010

I'm not including my spreadsheet because it has company information however, I will try to articulate my request as best I can. I currently have an Excel spreadsheet with about 20 worksheets, I would like to be able to click on the first worksheet, create a "Drop Down box" or "Data Validation" box or whatever I need to do to be able to view information in a range of cells on ANOTHER worksheet within the same workbook.

I've tried Data Validation, Drop Down Boxes, Define name ranges, all to NO avail. I'm missing a step somewhere, because I'm still not able to view the information on the first worksheet.

View 3 Replies View Related

Drop-down List Based On Selection In Another Sheet

Dec 4, 2007

how to get a 2nd drop down box to update the range (Not just use C6:C7)based on selection in 1st drop down box.

Example:
If Fat, Use range from C6:C7
If Skinny, Use range from D6:D7

Note: I tried putting an if statement in the input range for box2 but won't accept it.

View 9 Replies View Related

Return Cell On Separate Sheet Based On Selection From Drop Down List?

Mar 18, 2014

I am trying to create individualized worksheets based off a master worksheet. I have different committee names that I want to appear on the individualized sheets, based on whether the person is apart of that committee or not. On my master sheet, I choose the persons name under the committee and I want that committee name to show on the individualized sheet. For example, I want A1 on Master to show on Name 1, B3 and A10 on Master to show on Name 1, C3. Can I write a formula to achieve this or or am I asking too much? In my actual file, I will have about 10 names and 5 committees with one person being on up to all 5 of the committees.

View 1 Replies View Related

Copying Data To Another Sheet Based Upon YES / NO Drop-down Selection

Apr 30, 2014

I have a workbook consisting of 5 sheets.

Sheet 1 is the master sheet, and (among many other columns) it has a series of yes/no columns. The yes/no options are the equivalent of:

"Are you in sheet 2?"
"Are you in sheet 3?"

etc.

When this is the Yes option, I would like the rest of the contents of the row to copy into sheet 2.

These need to remain linked, so if I change stuff in Sheet 1 I would like it to change everywhere.

View 4 Replies View Related

Methods To Pull Data From Another Sheet Using Dropdown List

Jul 19, 2014

I am doing a spreadsheet where I have 1 main sheet and 2 sheets with data.On the main sheet I have a drop down list to select either one of the 2 sheets and upon selecting,all the data from that selected sheet will be displayed on the main sheet.

What i do not understand is the code given below

data:=IF($C$7='A2'!$A$2,INDEX('A2'!$A$6:$B$20,ROW( $A3),COLUMN(B$1)),
INDEX('A1'!$A$6:$B$20,ROW($A3),C OLUMN(B$1)))

How do i attach spreadsheet in this forums btw?

View 7 Replies View Related

Jump To Drop-down Selection On Another Sheet

Jul 16, 2009

http://www.excelforum.com/excel-prog...reedsheet.html . This is the original post.. and the original code was

Quote:

View 5 Replies View Related

Pull Data From Two Sheet And Paste Into Master Sheet With Desired Column Only

Aug 28, 2013

I want vba code to pull data from two sheet in workbook, code has to pull all data from first sheet , then pull data from second sheet and paste some particular column only below first column sheet

e.g i pull data from two sheet(ONSITE&CCI)

SHEET-1ONSITE CONTAINS HAVE 57 COLUMN
SHEET-2 CCI CONTAINS ONLY 19 COLUMN
FIRST I PULL 57 COLUMN DATA ONCE FINISH MOVE TO SECOND SHEET CCI CONTAINS 19 COLUMN BUT ITS HAS TO PASTE DATA BELOW DATA OF ONSITE TO PARTICULAR ASSIGNED COLUMN'S ONLY BUT COLUMN NAMES IN BOTH SHEET IS TOTALLY DIFFERENT

View 1 Replies View Related

Macro To Pull Data From Multiple Sheet To Main Sheet Based On Column Headings

Sep 13, 2012

I need a Macro which pulls the data from different sheets of excel (which is not formatted properly) to Main Sheet. Also some of the columns will not have the same names, so macro should handle this exception as well.

View 8 Replies View Related

Macro Pull Data From Each Sheet And Create A Summary Sheet

Jan 26, 2009

I need to create a macro that will scan a spreadsheet for the number of sheets and then pull data from the same places on each sheet in order to create a summary sheet. Let me try to explain a little better.

The spreadsheet I'm working with has a separate sheet for each new deal our company makes. Each of these sheets is in the same format - we use a template and fill in the data based on that whenever a new deal emerges. The sheets contain basic info about the deal in the first few rows and columns, then some narratives with dates describing the progress of the deal, and then a list of issues and whether or not they have been resolved. The problem is, each of these sheets contains too much info for a quick, high-level overview with the bosses so they've asked me to create something that will pull the basic info, the most recent narrative, and any unresolved issues from each sheet. This way, each time there's an overview scheduled with the bosses, the macro can be run and it will create a new sheet with data from each sheet in the workbook.

View 9 Replies View Related

Macro To Pull Data From 1 Sheet And Filter Into Another Sheet

May 14, 2014

I'm trying to get the data from Receipt log (sheet 1) to automatically populate into the Print Receipt (sheet 2) and to automatically filter and go to the Activity by account (sheet 3). I am so new to this and totally lost.

See attached sample : Student fees.xlsm

View 12 Replies View Related

VBA Code To Pull Data From A Sheet Based On Date And Add That Data To Another Sheet?

Aug 8, 2014

I use my workbook to track sales data from one store to the next. I use my workbooks to compare data from year to year. Each year's data is displayed on a separate worksheet. '2013' has 2013's data, '2014' has 2014's. On the 2014 sheet, I have a Prior Year's Sales that pulls data from the previous year's spreadsheet using a formula which I just drag down each day I enter sales. I would like to automate this process and have the VBA code check for today's date and automatically pull the previous year's sales data from the '2013' sheet and put it in the appropriate cell on the '2014' worksheet. I hope I have explained this well enough to understand. I've included a link to my workbook for reference.

I had to use dropbox since I can't post a file over 1 MB. The file size is around 1.25 MB.

View 5 Replies View Related

Drop CSV File Into One Sheet And Copy Data To Another Sheet?

Jul 8, 2014

update code based on a dynamic range of cells, which worked! I want to drop a csv file into one sheet, and copy the data to another sheet. However, if I drop a new csv file in, and there are fewer rows, the old rows aren't deleted. For example, if my first set of data had 10 rows, and the new has 8, the extra two rows are still there.

[code]
With Sheets("Raw Data")
.Range("A10", .Range("A" & Rows.Count).End(xlUp)).Copy ActiveSheet.Range("A12")
.Range("B11", .Range("B" & Rows.Count).End(xlUp)).Copy ActiveSheet.Range("B12")
.Range("E11", .Range("E" & Rows.Count).End(xlUp)).Copy ActiveSheet.Range("C12")
.Range("F11", .Range("F" & Rows.Count).End(xlUp)).Copy ActiveSheet.Range("D12")
.Range("H11", .Range("H" & Rows.Count).End(xlUp)).Copy ActiveSheet.Range("E12")
End With
[code]

View 2 Replies View Related

Updating Cells Based On Selection From Drop Down List Data Validation

Dec 13, 2009

I'm using Excel 2007. I would like to seek some advise on how i may update cells after selecting a month from a drop down list.

i have created a simplified version of what i intend to have. One the 1st tab 'Cash Budget 2009', i have filled up a table with numbers, sorted by months. On the 2nd tab 'Dec09', i would like to create an expense table, to be able to be selected by month. So i have created a drop down list based on the months that are created in the 1st tab.

Upon selection of the month from the drop down list, i would like the cells to display (fetch) the data from the 1st worksheet. It would also be helpful if the name of the 2nd tab can be updated to read as the month that is being selected.

View 4 Replies View Related

Drop Down List On The Front Sheet

Jan 16, 2008

I have a number of macro's which correspond to shift numbers 1 - 23

I would like to have a drop down list on the front sheet so that the user can select the number at the end of the shift which activates the corresponding macro

View 9 Replies View Related

Generate Drop Down List From Another Sheet

Jan 4, 2008

I am trying to create a list, I know how to do this on the same sheet, I need to be able to have the list informaiton on a data sheet that contains other information that I need to have to populate other parts of the sheet. then I need to add this list data so that I can have drop down options so that users can pick from selected work descriptions

View 2 Replies View Related

Drop Down List For Sheet Navigation

May 1, 2008

Split off from
Dependent/Linked Drop Downs In Cells


Originally Posted by Dave Hawley
Try it now. You hadn't named the cells that the Validation lists are Dependant on. Not bad for a "moron", hey?

Things get pretty stressed around here, especially when your commander depends on you as much as mine, and just between the two of us, it is twice as hard when your commander is younger than you. Let me try it real quick. Auto Merged Post Until 24 Hrs Passes;Ok, that works great, now I have to go back and add all the real units and soldiers. Fun, fun, fun. BTW, you wouldn't happen to know how to add a first worksheet that would have buttons to take you to the different sections? I know how to do the hyperlinks, but I think I read something on here about comboboxes?? If I need to post this somewhere else, then just push me in the right direction. I am use to pushing in the Army, it's our life!!

View 9 Replies View Related

Write A Reference From A Drop Down List To Another Sheet

Feb 4, 2006

How do I write a reference from a drop down list to another sheet and have
the formula do the if function so that it can do several arguments and return
"direct" if true and "indirect" if false.

View 14 Replies View Related

Drop List Value Auto Copy To Another Sheet

Jan 3, 2013

I have A dropdown list (form control combo box) ...in that the values are jan,feb,mar,apr... property of cell link is given as C4..... now my doubt is suppose if i select mar from drop down, in sheet the cell C4 should Show Mar only.....

View 6 Replies View Related

Add Drop List Box Or Combo Box In Yearly Time Sheet

Aug 1, 2009

how to add drop list box or combo box in this yearly time sheet so every employee has his own record in this time sheet so when ever i select name from drop list all info changed, i did include table in sheet 1 as an example.

View 4 Replies View Related

Drop-List: Populate Dates In Cell Range On Same Sheet

Oct 8, 2006

I'm need to add a droplist with periods 1,2,3,4 etc... that references a cell then populates that same reference in a cell raange. Example: cell E1 contains the droplist with periods 1-4 as choices to select from, when you select period 1 it populates the dates jan 15 in cells E4:E7, if you select period 2 it populates dates jan 31, etc. how to add the droplist, how to expand the list, show the formula and how to expand it as I will have more data than this short example.

View 3 Replies View Related

Macro For Copying A Row From One Sheet To Other On Selection Of Dropdown List

Feb 20, 2009

I am working on Excel document(Microsoft office-2007) with 2 sheets(Sheet1,Sheet2).
In sheet1 i have a dropdown list and the respective data is saved in Sheet2.On selection of dropdown lists in sheet1 ,respective rows should get copied from Sheet2 to Sheet1.

I am having trouble with the macro command. This is a first for me and I am stuck. I just dont know the how to write the Macro for this.

View 9 Replies View Related

Pull Data From One Sheet To Another

Mar 11, 2014

I am trying to get the starting point for this new sheet going but I am not able to formulate the required code. I will explain what I want to do

In the attached sheet, I have three tabs

Over 20K
Under 20K
PartNumList

This is what I want to do...In PartNumList tab if Annual Rev (Col O) is less than 20K then value in Col (A) i.e Part Number should be copied and pasted in Under20K tab... it has to pasted in either B18, B24,B30,B36, if B18 is populated then B24 if that too is populated then B36 and so on..

I want to do that same for Over 20K but if I have a starting point for Under 20K I can work on it offline too..

View 5 Replies View Related

To Pull Some Data From One Sheet Into Another

May 1, 2007

I need to pull some data from one sheet into another. Here is an example of what I am trying to do if anybody know hows to do this? I need a formula that will look in sheet 1 look at the idnumber, match it with the idnumber in sheet 2 ande fill in the serial.

sheet1
idnumber serial number
12345 66181
12346 66182
12347 66183

sheet2
idnumber serial number
12345 insert serial number here
12346
12347

View 9 Replies View Related

Pull Data From One Sheet To Another

Dec 16, 2011

How to pull data from one sheet to another. I have 2 sheets Sheet 1 and Sheet 2. I have data in cell A1 in sheet 1 and i need that same information onto sheet 2 in cell C10. I know on sheet 2 cell C10 i can type in this formula ='Sheet1 '!A1 and it works great.

The problem i'm having is if i clear sheet 1 data it is also clearing out the data in sheet 2, the formula remains but the data is gone. I need that data to remain on sheet 2. Is their a way to do this?

View 2 Replies View Related

Create Automatic List In Excel Sheet With Filtered Data From Another Sheet?

Dec 27, 2012

So I have a guest list workbook. There are two sheets. On the first one is a list of names on Column A. On Column B is a classification: 'C' if confirmed; "D" for declined; "I" for pending. I want to have all the names with "C" on sheet 1 appear on sheet 2 automatically.

View 4 Replies View Related

Created Validation Drop-down List - Can I Make The Row Now Change To The Colour That Relates To The Selection From The List

Jan 13, 2009

I am trying to create a fairly simple spreadsheet with about 8 columns and about 400 rows. One of the columns features a drop-down list with about 8 or 9 different options. Dependant on which option is selected, i would like the entire row to change colour with that option.

For example:
FAILED - whole row changes red
SUCCESSFUL - row has no fill
Tested - row changes to orange

etc.

Is this possible within Excel 2003?

View 9 Replies View Related

Using Dropdown To Pull Data From Another Sheet?

May 9, 2013

I have a drop down that provides all of the sheet name in the workbook. When the user selects a sheet name, I would like specific cells to pull data from the sheet name selected. What I thought would work is =Sheetname(A1)!E3 where the cell would pull data from cell E3 from the drop down sheetname in A1

View 7 Replies View Related

Pull Out Information From Main Sheet To Summary Sheet?

Mar 1, 2013

I am trying to create a summary sheet from the matrix to do further analysis. I want to pick out the welds done everyday with weld inches as you will see in the summary sheet. How can summary sheet be automatically updated when I enter the inspection date rather than copying and pasting? I can use vlookup to get the weld dia once I get the weld numbers on that date. I have attached the file.

View 3 Replies View Related

Do VLookup And Pull Data From 2 Or 3 Sheets To Another Sheet

Dec 18, 2013

I have a "main data"Test.xlsx sheet wherein I have to populate 4 columns from 2 other sheets.

E.g.: In master data tab, I have (PID,EMP ID,Name,Address,Join Date, Exit Date). Now i am trying to get the PID & Address from another tab called "PID,Address". To get the PID & address, i will use EMP ID as reference to fetch data.

Similarly, I have to pull Join & Exit dates from the tab "Dates Sheet" with same EMP ID.

I have a home tab, wherein I have a button which is assigned a macro to reconcile the data.

I know that I can do this with simple vlookup for all the columns, but the actual data is very huge and it may vary daily. So its time consuming process. So i want to this reconciliation (consolidation) using macro. How to generate a macro.

I am attaching the sample sheet : Test.xlsm‎

View 11 Replies View Related







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