I have created my main spreadsheet in a form format - one form per student in a row downwards (30 students) and then a row for each of 4 terms.
On a separate sheet I want to pull particular entries. I have done this for Term 1 and can continue and do Terms 2 - 4. However, I have to wonder if there is not an easier way. If not, then I'm good to continue - just takes a couple of hours to create the second sheet section for each term.
I've got a bit of a quandary here that my novice programming skills can't seem to solve.
Here is the scenario. I work for a photographic library. We have a spreadsheet that contains 5 or so columns, and a couple of thousand rows. Essentially each row contains an imagine code (the number we use to file away the imagine, ie. US_NY_NYC_1 ) in the first cell, and the image information in the following cells (ie metadata, keywords, photographer, date, etc).
so a typical row would look as follows:
Filename | Keywords | Photographer | Metadata | Location |
all the keyword, photographer, metadata, and location information can only be tied to the one image code whose cell begins the row.
Now, here is my dilemma. This sheet (lets call it the master sheet) contains all the images we have in a given batch. However, when a client orders images, we will send them most images in that batch, but not all, and we may send a few additional. So I have a separate sheet that contains only those image codes that the client requested. What I need to do is essentially take a code from the second sheet, find that same code in the master sheet, and copy over all the cells associated with that code's row. If the number does not exist in the master sheet, simply leave that row with only the code in the first cell, and the rest blank, and move on.
so for example, in my second sheet lets say I have the following A_B_C . I would like for excel to find that same code in the master sheet, and then copy over the metadata, photographer, date, etc, associated with that code, and paste it into the second sheet, so that that row in the second sheet now looks identical to the row with the same image code in the master sheet . If A_B_C does not exist in the master spreadsheet, then I would like excel to simply leave that code in its own row, leave the rest of the row blank, and move on to the next code.
i'm have a master spreadsheet of contact details and categories. i want to be able to pull contact information onto other sheets within the same workbook, based on category. example attached.
View 5 Replies View Relatedi 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:
<img src="http://img.photobucket.com/albums/v105/SeaDonkey/pic1.jpg">
I have a worksheet that lists all employees (past and present) (Worksheet A). I have another worksheet that I am sent from our training department that lists monthly test scores (Worksheet B). The worksheet containing the test scores only contains current employees, and the employee list changes from month to month.
Is there any way to have Worksheet A match up employee John Q. Public with the row for John Q. Public's in Worksheet B? I would like to be able to import the test scores automatically regardless of which row the employee in on in Worksheet B.
I am trying to create a simple ticketing system, just using the excel with no other PL.
I am trying to transfer the other in formation that I have create from 1 worksheet to another. If I input a particular number that I assigned I want that the other info along side with that number will automatically transfer to another worksheet.
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.
My goal is to create a pair of validation lists. The first will allow you to select what craft you are using (i.e. Alchemy). That will bring up the second list which will allow you select what recipe you are using (i.e. Black Ink). From here, I want the spreadsheet to automatically fill out what ingredients are in the recipe, the skill levels needed to complete the recipe at 100% success, and what the yield is each time successfully complete the craft.
The first part is easy, using the INDIRECT function to pull up a second list from the first. I have no idea how to make the other cells fill out, or even how to structure the data to make it accessible.
This is a simple question but I just cant get the right format. I have a userform which saves info entered into the form into a worksheet. I have one cell in anoth worksheet (sheet2) which I would like include in the info from the form.
I already have the column entered in the database I am now trying to figure out how to include this in the save.
I would need to identify this cell in my VBA.
DIM "cell" as ?
Take a work book, In one spread sheet you have data containing information about a user in the cells going across. In Sheet 2 I need to pull certain information into a comment section belonging to that user. Is there a way to do this?
I am trying to tie two worksheets together. If text found in one cell in sheet1, make the same cell on sheet2 different color.*
There is a catch... no formula can occupy the cell in sheet2.*
My question is, is there a way of have a formula in completely different cell that will eventually fill the cell on sheet2 with proper information?
To explain a little better, I am trying to tie the sheets together, same cells and everything so when information gets put inside the cell on sheet1 the same cell on sheet2 will change color or display different information, and vice versa. That is the reason no formulas can occupy those cells.
Is it possible to pull the subject and from information from the folder "ESITS" in my Outlook email into an excel spread sheet?
View 1 Replies View RelatedImagine I have 2 columns of information that look like this:
Column A
Column B
AS
Dog
AS
Cat
AS
Hamster
FT
Fish
These are my key columns. The letters are initials of people and the animals are the pets they're responsible for.
Now, I have 3 more columns that look like this:
Column D
Column E
Column F
These columns can go on for hundreds of rows.
What I want to do is pull out the information from columns D, E and F where the initials and pet match those in the key list, then paste that elsewhere (say to columns J, K and L).
So, for instance, the first entry would be copied across because, according to the key list, AS is responsible for a Dog, but the bottom entry for AS wouldn't because he was looking after a fish, and that pet isn't listed as one of his animals in the key list (Fish is listed alongside FT). Likewise, the entry for AH wouldn't come across because AH doesn't appear on the key list at all.
I have created a userform that allows input of information and then deposits the information on a specific sheet. I am looking for a way to have that information not only deposited on the specific sheet it is already set to but also to another sheet based on a selection made from a combo box.
here is my current
I am trying to pull titles out of a text string but its quite difficult because of how the data was originally inputted. I need titles that appear in the following different formats
" title"
title/
title"
These titles were not inputted consistently and it could show up in the middle or at the beginning. I have attached a sample of the data that i am working with and a sample formula that i was trying to use to obtain my information. The formula that i have is a nested formula of find and mid formula that searches for the text within " ".
Basically I am trying to create a worksheet in which everytime I input information into Sheet 1, it is copied into Sheet 2. I want to have each entry in succession on Sheet 2 such that my first entry would be on Row 2, second on Row 3, third on Row 4, etc. However, everytime I put something new in Sheet 1, it just overrides the information in Sheet 2.
Basically I type in ticket sales in sheet 1, it calculates the prices and keeps a transaction log in sheet 2. But everytime I do a new ticket sale, it just overwrites the previous transaction witht he new transaction information. I've pasted my VBA below:
Sheet 1 VBA:
Code:
Option Explicit
'Form level variables - used in more than one event
Dim intAdult As Integer
Dim intStudentSenior As Integer
Dim intBalcony As Integer
Dim intChild As Integer
Dim sngAmountDue As Single
[Code] .......
Sheet 2 code:
Private Sub cmdSummary_Click()
'Declare Variables
Dim intCount As Integer
Dim i As Integer
Dim intAdult As Integer
Dim intStudentSenior As Integer
[Code] ......
I have a master document that I want to break apart into sections. How can I pull data from the Master document (sheet1) to sheet 2 without having to make changes to both parts?
If this is hard to understand I will try to explain better....I have addresses on the first page and want to make a separate group from that original document on sheet2. My main goal is to be able to only update the first sheet and to have the changes go on to the sheet2 document.
I have two sheets....one sheet has a all the detail I need on it. On the second sheet I am trying to pull all the detail by category but want to eliminate any zeros in between. Anyone know how to do this?
I feel like I am being very vague so if I need to give more detail just let me know.
I don't think this may even be possible, but what I am trying to do is pull only certain information from one worksheet to another based on whether there are entries on certain dates for employees.
A sample is attached.
On the first worksheet I have a drop down menu for all employees on the second sheet. (the drop down menu pulls the names from the second sheet)
The second worksheet has all employees in Column A and to the right has all their variances by date. Most dates will be blank as they didn't have a variance.
What I would like is on the first worksheet, is to select their name from the drop down menu and have all the dates that they had variances and the variances show up.
If you take a look at the attached excel file it might explain what I am trying to do better.
I'm building a personal budget that looks a lot like a set of business financials (really just an exercise to learn excel techniques).
So, I have one sheet that acts as a register -- in column A I have the date of the transaction, column B is the amount, C is from which account the money came, D is the use of the money, and E is a code (1 for paycheck, 2 for investment income, 3 for food expense...etc).
On another sheet I have an income statement. I want the income statement to pull code 1s from the register sheet for the month indicated by column A in that sheet into the proper month column (B is january, C is Feb....). I then have a cash flow sheet which uses V-lookups to pull the information from the income statement, and that seems to work fine.
Right now, it pulls a sheet from another workbook, and saves it to this workbook. It works great. My problem is that I want it to keep what it pulls in, and not change when the other workbook changes. The other workbook has a macro that clears its cells every morning, so new info can be entered.
I want the old info that the code below pulled over to stay the same, so that I can keep a running history of what was entered everyday. At the moment, if I run the clear cells macro in the other workbook, it also clears all in this workbook. What needs changed in the code to make it work right?
SampleEOD.xlsm
I was wondering how to input data on one sheet, then have specifics from that first sheet get sorted and put on the second and third sheet according to it's value. I have attached an example with my comments in red.
View 3 Replies View RelatedExpand the explanation for the previous thread? [URL]....
I am trying to do basically the same thing, I have a long list of clients and need to separate them by date they contacted us. I am using Excel 2008 on a mac, which does not allow micros. the previous thread does exactly what i need to do, but i cant get it to work.
I am working on a project for a monthly report. My back sheets have (or will have) 12 columns of info for monthly income/expense for multiple companies. The front sheet will have 2 columns, one for the past month & one for cumulative.
Obviously the cumulative is an easy one to pull off, but how can I make the correct column show up for the current (last) month I am working on.
Rather than make it tied to the actual date of input, I have used an approach in the past with a "sum if" formula for a single reference where =sum if(b6:b6,a2,a6:a6) but I'm not sure how to make it work for 12 references. Can this be done?
I have a file which has a number of sheets each relating to a different project. Each project has a line for each milestone starting at the same row but each project has a different number of milestones.
I would like to create a summary sheet that either pulls through each row relating to a milestone from each project sheet or ideally each milestone that relates to a certain month from each project sheet (each milestone includes a completion date).
Basically, I run a DJ Management company, arranging bookings for 6 artists. What I'm trying to do, is have data be auto populated from the Master sheet, into separate sheets. The aim, is to create 1 master with ALL the dates for the month in, and the each of the separate sheets to only populate data relating to that artist.
For example!
Artist
Event
Location
Fee
Date
Tony
Tomorrowland
Boom, Belgium
5,000
01/05
[code]....
Now, I need to send the artists their individual schedules for the month, but I do not want to copy and paste individual rows to their new sheets as this is a pain. I know i can sort by artist and copy it easier, but really i just want to put in the info once and not multiple times.
So the master is sheet 1, on sheets 2,3,4,5,6,7 (each one assigned to a particular artist) i need the artists gigs for that month.
I have a workbook for a category of academic journals. It contains the journal name in the first column, the year it was published in the second and various bibliometric stats in the next twelve as follows: ....
View 9 Replies View RelatedI am creating a spreadsheet for mutiple clients, which has around 5 columns. This spreadsheet will have 7 sheets on it. 1 sheet for each client, and the 7th will be to display all of the information together.
Basically I am looking to find out if this is possible?
I will try and explain a bit more, as above is just beifly what I am loking for.
I Have Client.xls
On my Tabs I have
Client1, Client2, Client3, Client4, Client5, Client6, All Clients
In Each individual spreadsheet, I have the following Columns
Incident Reference; Description; PMDB number
Each Day data will be entered into each client sheet, and I would like this information to be populated into the All Clients Tab. I am not sure if this is possible, and if it is, would I then be able to put it into the All Clients tab, and have it auto sort by the incdient reference column? As this is an autogenerated reference for all of our clients.
I have created a comparison sheet and compares my old one from last week to the new one I create for this week.
It populates cells with the differences and shows me the data from the new sheet. But since my they are so massive A5:AZ20,000 so you can imagine how many blanks there are.I want to create an auto summary or something from the non blanks.
Column A has each properties Unique Identifier And the rest is various info for the property. I would like it to return my unique ID and then the columns with new data that has showed up from the comparison some are text and some are numbers.
Also I am using Excel 2010.
I have an identical worksheet for all the days of the month - i.e. the May workbook has 30 identical worksheets. I am wanting to pull only certain rows from each worksheet onto a master. Something like - copy row from all worksheets where that rows cell "D" has any value other than " ".
I have used the following macro to pull all the data from every sheet onto a master - but i don't want all the data - just the qualifying data.
Sub Combine()
Dim J As Integer
On Error Resume Next
Sheets(1).Select
Worksheets.Add ' add a sheet in first place
Sheets(1).Name = "ALL"
I am not sure what the range "A1" is - i am thinking i can modify it to only grab certain rows.