Populating Worksheet With Date From Another Sheet If Criteria Met?
Aug 5, 2014
I am trying to save 'double keying' with a template I use for event RSVP's.
Basically I have one sheet that has a list of invitees for a particular event (can be anything from 5 to 500) along with a bunch of data about them (e.g. address, firm, dietary requirements etc.)
I want to have a SEPARATE sheet that auto-populates its rows with the name and only some of the other data related to each person that accepts the invitation. Sort of like collating the guest list. If at some point they accept and then decline, I need them to be automatically removed (and vice-versa).
I have attached a simplified version of my spreadsheet for reference.
Event Summary Template v1.xlsx
View 1 Replies
ADVERTISEMENT
May 22, 2013
I have two sheets in one workbook; one has a list of names in column A (136 of them) and another is a master list with all the names of people who work for the company (over 2000). Sheet 1 and Sheet 2 respectively. I need to populate columns B-E in Sheet 1 with the data in columns B-E in Sheet 2, but only for the names that match in column A. I've tried applying filters but can't get to the data I need for some reason. The names are formatted the same way in both sheets (Last, First). In Sheet 2 the names are links but in Sheet 1 they aren't; not sure if that's important.
View 7 Replies
View Related
Jul 28, 2009
I've been trying for some time now to figure out how to have one sheet automatically fill in another based on a larger data sheet. I'm trying to find a way to take a monthly calendar which contains a row for each employee and column for each day and use that to create smaller lists on another sheet. Basically if someone puts in for a day off, or has a medical appointment etc, that person has a coded single letter for that day for tracking and planning purposes. I want to have a second sheet that references those codes and makes individual lists (the following people are on vacation, these people have a medical appointment etc.)
View 3 Replies
View Related
Oct 29, 2008
I am trying to total up by a Range of Dates some information from one page to another through VBA. I am having a tough time with this one, I can't seem to get the correct information over to the other page.
I have successfully been able to transfer the data via a series of SUMIF statements, but it really is very inefficient and takes a while when the data repopulated by another program. So I am trying to do it via VBA.
View 5 Replies
View Related
Jun 18, 2013
Here is an example of my spreadsheet: Excel example.xlsx
I would like to get all the bid/ask quotes for the different currency pairs in sheet 2 into sheet 1 sorted by the right date and time.
I need a formula which recognize the time + the currency from sheet 1 and search for it in sheet 2 then brings the right bid/ask quote back into sheet 1.
View 2 Replies
View Related
Mar 14, 2013
i'm having in excel- I'm looking to populate rows in 2nd tab based on the data entered in the 1st tab. The rows to be populated in the 2nd tab resides in the 3rd tab. So a match has to be made on the data entered in the 1st tab. When a match is found on the 3rd tab then the corresponding rows from the 3rd tab should be listed on the 2nd tab.
I have an example.xls attached for clarity.
example.xls
View 4 Replies
View Related
Jan 29, 2010
I am adding a sheet with a graph I made. There are two sheets, the first with the graph, the second with tables. What I would like to do is populate the graph based off what is entered into the tables. My main goal is to get the cells in the cells in the graph for each day to fill in color between the given time frame entered in on the table. Obviously I would be rounding up or down to make the time end in ":00."
The color I would like to fill the graph with is shown on the graph sheet. Also, if anyone can actually get this to work (I honestly wouldn't know where to start) Is there a way to have multiple colors and a possible overlay of colors?
Lets say on tuesday I have 10:00-15:00, and 12:00-18:00. Can I have two colors populate the cells and a thirs color populate the cells in the overlay which would be 12:00-15:00?
View 4 Replies
View Related
Mar 31, 2008
I have two worksheets. The first contains a list of software (some having duplicate listings) in column A and a list of comments in column B. None of the software titles that have duplicates will have comments.
The second worksheet contains a condensed list of software (the previous list without the duplicates) and a column for the comments.
I need to have a formula that populates the second worksheet comments cells with the corresponding comments from worksheet one only if:
(1) The software title in worksheet two matches the software title in worksheet one
(2) The comment cell in worksheet one contains a comment (or text)
I have had only partial success; my obstacle being the duplicate software titles in worksheet one.
View 10 Replies
View Related
May 6, 2013
I am attempting to populate multiple rows in one column with data from another table. I need to get the correct street address using multiple values, i.e. first name, last name and city, as some of the names double up.
Is there a way to do this? I have pasted below an example of what I need done as reference.
Last Name
First Name
Address
[Code]....
View 4 Replies
View Related
Dec 14, 2012
Below is the code for completing Sheet 1 using various comboxes on a User form. There are only 15 lines to which values can be entered on sheet 1. After the 15 lines have been completed, I would like to begin adding new data to sheet 2. However, I'm not really sure where to begin in terms of setting up a counter and then calling sheet 2 once the counter hits my limit. Sheet 2 is exactly identical to sheet 1 in layout and also has 15 lines.
Private Sub btnAdd_Click()
' This button will add medication info to excel worksheet
'RowCount will help find next empty row
[Code]....
View 1 Replies
View Related
Mar 28, 2014
I'm trying to populate a table based on two different criteria in a another table. On is based on a date and the other the number of a unit. I'm trying to get the data in sheets Week 1 and Week 2 into the format in sheet Example. Is there a way to create a series of functions, filters, etc that I could use to create a macro to do multiple sheets or at least a whole sheet at once? I've been trying to think through it with my limited knowledge of filters and functions
Here is the file with an example and I'm using Excel 2007: Example.xls
View 2 Replies
View Related
Jan 7, 2014
Please see the attached sheet, Im trying to get it to populate the first page with the column data in the datasheet1 page by using the dropdown menu in N1. This is for when people ask questions about the data, I can quickly and clearly show them the differences from one month to another
How I would go about doing this?
Digital Delivery reports.xls
View 5 Replies
View Related
Jul 28, 2013
I have a master list. I want to create an excel sheet that will follows when I key in the code number according to the master list all the rest of the value in the master list will automatically populate accordingly into their respective sequence into the created excel sheet.
Eg.
Master list
A B C D
0001 Lucy 8 Walton primary
0002 Rachel 9 Dermouth primary
The created excel sheet
Code 0001
Name Lucy
Age 8
School Walton Primary
I want to key in the code 0001 and the rest of the value will auto populate from the master list into the created excel sheet. The master list data go in accordance row by row. That means the master list is listed in a sequence where all the related value for the particular code into one row only.
View 14 Replies
View Related
Mar 24, 2009
I have two worksheets. One worksheet is pulling in data from an OLAP cude. I have it configured as a pivot table. The other worksheet contains my dataset. Both worksheets are in the same file.
In my datasheet worksheet I would like to pull in data from the other worksheet. I would like to be able start a few cells and then drag so that it autopopulates the values. Here is the formula I'm using
='Affiliates Pivot'!$F10
='Affiliates Pivot'!$F11
='Affiliates Pivot'!$F12
it poulated with the values
23
45
64
then I select the 3 cells and drag so that I can autopulate the remaining values. It enters the formulas
='Affiliates Pivot'!$F10
='Affiliates Pivot'!$F11
='Affiliates Pivot'!$F12
='Affiliates Pivot'!$F10
='Affiliates Pivot'!$F11
='Affiliates Pivot'!$F12
='Affiliates Pivot'!$F10
='Affiliates Pivot'!$F11
='Affiliates Pivot'!$F12
what I really want is
='Affiliates Pivot'!$F10
='Affiliates Pivot'!$F11
='Affiliates Pivot'!$F12
='Affiliates Pivot'!$F13
='Affiliates Pivot'!$F14
='Affiliates Pivot'!$F15
='Affiliates Pivot'!$F16
='Affiliates Pivot'!$F17
='Affiliates Pivot'!$F18
Is this possible? How can I do this?
View 12 Replies
View Related
Mar 26, 2009
I have the following simplified example:
Table with three columns with a growing number of rows. The user enters data into each row, once user enters the last value and hits "Enter" on the final cell (column c) I want a script to evaluate the row and copy the entire contents of the row onto an existing different worksheet. The first column (A) contains the attribute that will be the condition that determines which sheet to paste in
For example, in my attached file, the first row contains the value "Square".
I want that row be copied and pasted into the 2nd tab of the worksheet (reserved for "Square" data) on the next free line. Simiarly, Triangles should be pasted on the thrid tab. Note however that i think the data should be copied line-by-line as the user enters it, which obviously isnt the case for the example dummy data, its just there to simulate my setup
View 4 Replies
View Related
Sep 3, 2009
I have a userform with comboboxes and listboxes etc. The comboboxes have drop down lists which are populated from data in columns from a worksheet.
1.) During the execution of the userform, a value is selected from the combobox, which is place in a column on another worksheet. So far so good. If I select the same value again, nothing shows up in the row below the first selection. If I choose a different value it shows up. I have tried using different properties of the combobox but have not been able to get around this.
2.) I would like, when the excel file is opened that the userform is ready to go, ie enter data. I have tried putting the
Private Sub Workbook_Open()
UserForm1.Show
End Sub
in "ThisWorkbook" module but have had no success with it.
View 12 Replies
View Related
May 10, 2007
I have a list of six digit codes and I want to use these to populate a listbox based on the selection of a value in an existing listbox.
I have managed the following code by osmosis from various places:
Private Sub ListBox1_Click()
Dim Cell As Range
Dim Test As New Collection
Dim Item
Dim i As String
So what I'm trying (and failing) to do is add a clause that will increase i by one, add that to the collection "Test" and then add one again etc., etc.; until it reaches the maximum value for i in the list - in this case 187410 - but some codes run into the 20s. Other cases will give a different value for i.
View 9 Replies
View Related
Feb 28, 2014
I am trying to adapt a macro which deletes all rows in Worksheet 1 where the date in column K differs from a date in Worksheet 2. The date in Worksheet 2 will change each day.
I think the macro below could be used, but don't understand how to replace the "Value = ":70:" with a reference to the master date in Worksheet 2.
Sub test() Dim lr As Long, i As Long lr = Range("A1").End(xlDown).Row
For i = lr To 1 Step -1 If Cells(lr, 1).Value = ":70:" Then
Cells(lr, 1).EntireRow.Delete End If lr = lr - 1 Next i End Sub
View 2 Replies
View Related
Aug 31, 2009
I currently have a huge data sheet with multiple columns of information. It contains a list of projects organized by columns with information pertaining to each project. I've named this worksheet data.
On another sheet I've named Present, I'm trying to find a way to reference a single project at a time using a drop down list. The Present Sheet has a list of characteristics fields that need to be filled with information from "data" worksheet. I want the characteristics to change whenever I choose another project name from the drop down list.
View 2 Replies
View Related
Sep 11, 2009
Column M of Sheet 1 contains either "y" or "n". I'd like Sheet 2 to populate with data in cells A-D but only for rows where column H = "y". I can figure out the condition easily enough: =IF('Sheet 1'!M2="Y",'Sheet1'!A2,"")
Repeat for each column to display. But I'd like to suppress the blank rows for both display purposes and the possibility of using in a Word mail merge.
View 2 Replies
View Related
Jul 25, 2014
I'm trying to do some userform development with multiple dependent comboboxes, but I am having trouble populating the third and last combobox. First, I populate the 1st combobox on the userform initialization. I can get the first 2 comboboxes to populate correctly, but I can't seem to get the 3rd combobox to populate correctly.
The 3rd combobox takes the selection from the 2nd combobox and searches column "A" in the worksheet "Chassis Specs" and populates the 3rd combobox with data from column "B", there will be repeat items in column "A", but all those occurances should populate the 3rd combobox with the data from "B".
I am attaching my whole workbook.
Chassis Specs Info_Build_REV B.xlsm
View 14 Replies
View Related
Nov 6, 2012
I have an ActiveX Combo box - and Im trying to fill from a 2nd sheet (same workbook). I can get the box to work if the data is on the same sheet but what to I put in the ListFillRange to get it to populate from another sheet ?
View 2 Replies
View Related
Mar 1, 2007
I am trying to populate a combobox located in sheet1 with data from sheet2.
View 3 Replies
View Related
May 1, 2014
I have a userform which requires the user to enter the date a training course was completed. Initially I used DatePicker as I was running Excel 2010 and had that working, however the workbook I am creating will be used on about a dozen machines, all of which have different versions of Excel. To avoid needing calendar Add-ins to be downloaded and installed for this feature I decided to go the vba created calendar route. I am using one I found on this forum: [URL] .....
It works well for me using the example spreadsheet provided in the post but I am having some difficulty incorporating it into my code. I believe I have imported the appropriate forms and modules because I can get the date populate to the Label Box on my userform but when I try to put the Date into the spreadsheet along with other data such as name and course duration, the name and course duration populate but the date cell remains blank and execution completes without error.
I have tried playing around with the data type thinking I had some issue using the .Value attribute with a String but .Text gives me an error as does converting from String to Number format.
I will attach the workbook but for a quick look, the portion of the code I believe that is not working is in here:
[Code] .....
Training Classes Example Workbook.xlsm
View 3 Replies
View Related
Nov 17, 2006
Basically i am trying to auto populate cells using two dates as the parameters, set up is
A1 - Start Date
B1 - Finish Date
C1 - Jan 07
D1 - Feb 07
E1 - Mar 07....and this carries on across till the end of the year.
What i am wanting excel to do is to be able to put in a start date and finish date in to the relevant cells.....this then populates a fixed figure across in to the correct month.
Eg
start date 05/07/07
finish date 17/10/07
This then puts in the figure 0.2 in to each cell that correspond with each month....July 07/Aug 07/Sep 07/Oct 07.
So in effect it is giving a gantt chart but with data in it.
One more thing....the start and finish dates could well be out of the range.....
eg
so start could be 07/08/06 and end could be 18/04/07 which would mean that all of the fields would need populating.
View 9 Replies
View Related
Jul 11, 2013
I'm attempting to build a large (let's be honest for a second this is going to be enormous) spreadsheet for a project I'm working on and TBH I'd rather not do it by hand. With the scale of numbers I'm working with I'll miss something and it'll take forever.
Here's the deal:
I have 5 variables. They must add up to 100. I need to populate their area with all combinations/permutations of said variables in steps of 10. I'd like to do it in steps of 5 but I'm afraid that'd be too large.
Like so:
A
B
C
D
E
Sum
100
0
0
0
0
100
[Code] ....
It's been a while since I was in a math class dealing with combinations and permutations, so one of my questions is, how exactly would I phrase this mathematically?
View 3 Replies
View Related
Jun 22, 2012
I have a workbook with two sheets. Sheet 1 has raw data that contains contacts with multiple statuses. I need to pull out only the contacts that have a positive status and put them into Sheet 2.
I would like there to be no spaces between the contacts in Sheet 2. I'd also need all of the data pertaining to each positive contact (so not just their name, but all of the data in the row that relates to the contact).
View 3 Replies
View Related
Aug 28, 2013
I am trying to auto-populate a table with data looked up from another sheet. The functions I have used are: Data Validation, vlookup, ISerror and if functions.
Cell B4 in sheet2 uses Data Validation to pick data from sheet1 (in this case "tax") and auto populate the table with the information- Job type, Name, employee type and Job title. If i change from Tax to HR, the table should get auto-populated with the correct information.
I have setup vlookups but I am unable to get it working. I am a novice at using vlookups (I learn it just 2 days ago) and am struggling to get it work. I am not even sure if vlookup is the right tool to get this job done.
View 12 Replies
View Related
Jan 14, 2010
I need help to create a formula that would grab data from one sheet and populate another sheet based on the employee that is selected from a drop down list.
Attached is a draft of what I am looking to do.
Basically this would allow us to enter employee variances from several employees on one sheet and get a detailed break down of their history on another sheet.
View 8 Replies
View Related
Apr 22, 2013
I have a workbook that contains data on a different sheet that I would like to populate on a different sheet by selecting a value from a drop down list. The format of the data is identical just different numbers. But are broken out into different projects... I am incredibly new at this and just barely learned how to make a drop down list.
View 7 Replies
View Related
