I have a spreadsheet with info about students in a summer program. I need to pull out the students who have allergies along with what their allergy is and their emergency contact phone number. I would like this new info in a new spreadsheet.
Here is an example of the spreadsheet:
allergiesnamephoneallergy type
nobob410.555.1234
nojim410.555.5843
yesmeg410.555.7458nuts
nolex410.555.1159
yeswill410.555.5005fish
I have a list of cities, counties, and schools with dates for each account. I want to put these into a workbook with tabs along the bottom for each one, then I want to be able to select all of the accounts that have a Jan 1st effective date and show them on a list in the first worksheet.
I'm copying and pasting data from a PDF and need to eliminate some unnecessary data. The original .pdf has 4 columns: Account, Dollar Amount, Name, Notes
When I copy this to an excel document, it copies the row from all 4 columns into column A. The two columns I need are Account and Dollar Amount. All account numbers are 8 digits so I was able to create a formula to weed that out with this: =left(A1,8)
The problem I'm running into is obtaining the dollar amount within the cell. For example:
A1 contains: 11112222 $1234.56 Sample, Name Sample Note
I pull the 11112222 with =left(A1,8) in column B but not sure how to pull dollar amount to column C.
Further, the dollar amount varies from $1.01 to $10,000+
I have a regular table of data and dependent on the info within a column of cells I would like the info to appear within one of 3 new sheets. BUT.... I can't figure it out because the info forms an irregular part of text within the cells in a specific column - Obviously if it was dependent on the whole of the text I could use Vlookup but it's not.
If it needs further clarification, a column of cells may have, say, "blahblah234/PLblah" -> If this cell contains within the text "PL" then it should have the whole of the row in the new sheet, if not then blank.
I am trying to pull info from Access into Excel using Data, Import External Data, New Database Query. I follow the menu and when I get to the end for the info to be pulled to Excel I get an error.
I have monthly reports of sales by client number. I am now trying to pull the annual sales info by month for one client by name. Eg. each month, XYZ ltd has sales figures for various products. Is there a way of me grabbing all his sales info for the year with out having to open each spreadsheet
I am accustomed to using filters to find a lot of my information in large datasets.
However, now I am trying to use formulas to return specific values. For simplicity's sake, I have included a sample below with a couple types of scenarios I am looking to solve through the use of formulas. Would this involve sub-arrays perhaps?
I have found a code to pull outlook calendar information from outlook to excel. I am trying to determine how to pull from Shared Calendars. This code looks as if they calendar has a number (9), but I can't figure out what the other calendar's numbers would be. How to pull from Shared Calendars and how to pull the month for which the calendar is on. My shared calendars are under Calendars>Shared Calendars in outlook. So for example, I would need to pull John Doe's calendar information for January if the calendar was on January. My code is listed below.
Sub ListAppointments()
Dim olApp As Object Dim olNS As Object Dim olFolder As Object Dim olApt As Object Dim NextRow As Long
i have this spreadsheet that has 2 tabs titled "master" and "unique". "master" has a list of ingredients (8 each), a number associated with it and a store number associated with it. for example (basil-136-r5). now, each store number has a different number associated to the ingredient. for example (basil-136-r5, basil-235-r6). on the "unique" tab/spreadsheet, im supposed to create a formula that calculates the number of times (ex: basil) is used and what number is associated with it to the store number. here is a pic:
What I am trying to do is pull data from one spread sheet into another. The Data spread sheet has 2 columns. Date and Price. What I need to do is enter a date in to row b2 (example 2/13/2013) Then Cells c2-v2 fill in with the data from the 20 days prior to 2/13/2013. Also note that I use only dates from weekdays.
Hi folks, I got great help just now on the first part of this project and am hoping to get lucky again. I attached a workbook. This is traffic count data. I need help pulling information from spreadsheet named HourTotals.
The data is in cells H2:AE366, it is 24 hours wide by 360 days long. I need to search that range for the highest number and in addition to the number get the corresponding date from the date_ column and the hour from the corresponding hr_X column and paste that information into another spreadsheet and repeat that process for say 500 values.
I get excel files containing information listed by store for the entire company. How can I sort and pull out only the information pertaining to the stores that are in my area?
I have a "surplus inventory" sheet and a "inventory shipped" sheet. How can I input how much I shipped in the "inventory shipped" sheet and make it take away from my "surplus inventory" sheet automatiaclly?
Here is what I am trying to do with no luck so far.
If I type RS23U1R109000 in a cell A1, I want B1 to read the 5th letter or number and fill B1 with E86.
Example A1= RS23U1R109000 B1=E86 A1= RS23V1R109000 B1=E87 A1= RS23R1R109000 B1=E84
As you can see in my example, the 5th letter could be U,V,R or whatever, but I need cell B1 to read that letter and populate B1 with E86, E87, E84 or whatever.
How do I keep all the info entered onto a form intact even if it has been entered so that someone can click a back button to review what they have entered? In other words even if a user closes the form is there a way for that info to stay on the form?
Private Sub cmd_Enter_User_Input_Click() Worksheets("PowerAnalysis").Activate 'Make Power Config_Draft_New 2.xls.xls active workbook before entering data
Workbook 1 has 2 spreadsheets. Spreadsheet 1 contains Item and Pass/Fail Columns. under the item column is the serial number of the item tested. the Pass/fail column has the serial number duplicated if it failed tested. what is the formula is to have spreadsheet 2 pick the items from the pass/fail column on spreadsheet 1?
I have attached a document paralleling a document I am working on. The dollar amount in each spreadsheet represent sales. I have entered in values into the candy, soda, and chips spreadsheet. I have also linked values for candy into the total spreadsheet. My question is can I somehow type something or drag the formula down to populate the other cells in the total spreadsheet?
The idea I am thinking but which I don't know how to implement is to list all the items (as in column G) and list all of the relevant cells (e.g. B1 in the Candy spreadsheet) as in columns H and I (Note that all items will have the same cells but the cells will have different values...e.g. all three items have a cell B1 and B2 in their spreadsheet but these cells contain different values). I then try and fail to create a formula in cell B3 of the Total spreadsheet. I am trying to create a formula of the following nature:
='(Spreadsheet Name From Column G)'!(Cell Name From Columns H and I)
The Second half of the formula doesn't really concern me (i.e. the cell name from column H and I). However I am perplexed as to how to achieve the goal in the first parentheses above.
I have two spreadsheets, one gives me the beginning and end of civil twilight as a measure of day vs. night. The spreadsheet has Date/Time in the first column, and the value 45 in the 2nd column when it is night. The second spreadsheet has also 2 columns with date/time and body temperatures of a squirrel. I want to get basic statistics (mean and standard deviation) of the squirrel's nocturnal body temperature, that is for times when it is night (value 45). The tricky part is that Date/Time of both spreadsheets are different. The procedure has to recognize that the date/time of body temperature lies between the beginning and end of the value 45 blocks of the first spreadsheet.
I have a spreadsheet that I have a lot of macros that are attached to a customized toolbar saved in the same spreadsheet. I saved this is a read-only file. When I open as read-only and run my macros (testing), I save it as another file. When I then open the "template" to do the same thing, the toolbar/buttons now reference the file I previously saved as something else. Help please? Is there a macro that would delete all macros before saving the file as something else?
Often I need to add data from one spreadsheet to the appropriate places on another spreadsheet. For example:
Sheet A has 10,000 records with these fields: id#, name, address, place of employment.
Sheet B has 5,000 records these fields: id#, GPA, college major, type of degree.
Some of the records in B contain information for the same id#'s as sheet A. I want to add this information together so that a Sheet C will have these fields: id#, name, address, place of employment, GPA, college major, type of degree.
I have noticed that the basic problem I have is a common one on this forum with different varibles for different people. I have attached a dummy copy of the spreadsheet that I am using.
I need to copy cell information for one spreadsheet to one of 2 other spreadsheets depending on a dropbox condition. The master spreadsheet is the Issues spreadsheet, and depending on whether the user chooses Transferred Complaints or Transferred Offences (in Column K) I need to transfer certain cells to the Complaints or Offences spreadsheets.
The information I need to transfer from Issues is: .....
I have 2 sheets in my excel spreadsheet. One tracks data for a number of projects five different employees are working on. The other sheet is where I want to total up the number of minutes each employee has worked on their individual projects. I tried writing an IF statement like below but I am only getting the total in the first field even if the employee's name is not Employee 1....
[Code] .....
How I can write this so their totals show up in the correct row?
I have a Main Customer Spreadsheet. I want to Auto Populate FROM the Main Customer Spreadsheet to a New Spreadsheet. I want to be able to key in a customer name on the New Spreadsheet and take the info for that customer from the MAIN Spreadsheet and fill in the blanks. I need to be able to do this several times a day.
It also renames the CommanBarPopop with the new filename.This allows the user to open both Projectworkbooks/files (If required) and load each CommandBarPopup for different filenames .Therefor opening the Userforms and worksheets for the CommandBarPopup clicked ...
This example is A1 to F4. There are two inputs; A10 and A11, and one output (formula) on A12. A10 will be the column I choose, and A11 is the row I choose...but it's chosen if the number is >= column A and < column B.
Example: I input A10 as 2, and A11 as 87, A12 will output 4. If I input A10 as 0, A11 as 85, A12 will output 6.
I kind of understand how to use VLOOKUP for this, but I am unable to check column A and B to choose the row.
I created a macro that opens a page as an excel sheet, grabs data from it, and inserts it into a cell.
My problem is that one of the cells has an abundance of data that I don't need.
The data that it puts into the cell looks like this: 0849940222,* Bill Myers ,* Thomas Nelson,*1997-10-02 The only thing I need is the first name that shows up.
The number at the beginning is always the same length, so I thought about using a trim function for that, but since names are not always the same length, how to do the other end. Maybe get the value for commas and delete everything before the first and after the second...I also don't know how to do that in VBA.
