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.
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 ?
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:
<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 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.
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.
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 Relatedi'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 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'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 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 " ".
I am trying to do is populate one worksheet (in the same workbook) with data from many (ie 500) separate tabs. An example is as follows:
On the summary data worksheet, we will call Price Highs, I am trying to return one column of data from each of the 500 worksheets (aka their Price Highs). This is so that I can have each tabs (symbols) data next to one another for easy formula dragging and analyzing. Up to this point I have been using the Find/Replace function, but with this many worksheets I would obviously have to do it 500 times!
I have a work book with prob close to a thousand individual work sheets in it. I have a goup of cells that are the same in ever work sheet that I would like to pull and place into a master work sheet. I dont want to copy and paste each one, I'd be a hundred before I finished and I dont have that kind of time. Im thinking a macro might be what I need but Im not very good with useing them let alone making one to fit me needs.
View 2 Replies View RelatedI am building a workbook for small group of people in my office to use. I have 7 tabs, the first one is called Main Sheet and the other tabs are the names of each person using the excel workbook. Every tab looks the same, I have the columns labeled: date - job number - job name - contact # - comments
My desire is that each person will be able to input their data on their tab as they receive new jobs, and the main sheet will be a compilation of everyone's sheet. So to clarify, as new information is added to one tab this entire row of information will automatically be added to the next available spot on the main sheet. We are all on the same server so we can all work off the same file. Is this possible to accomplish?
I would like the following columns to show on a new worksheet if column Z and AA (which show a date and time) are the same as todays date, the columns of info I would like it to pull through are Column C,D, Z, AA. The row numbers could be different daily? is this possible?
View 7 Replies View RelatedI'm trying to automate some documents we use on a regular basis so that we don't have to re-enter the same information over and over again. Basically I can get some cells to work and some will not. My first sheet is a contract. So I want Customer and Contractor info to show up on the rest of the sheets. I'm assuming something is messed up in the formatting of the cells but I can't figure out what.
So on my Job Book Cover Sheet I first want the GC's name and the code =Contract!G8 works perfectly. In the cell just under this one I want the Customers Name, but =Contract!C8:D8 (the cells on the contract with the Customers Name) returns #VALUE!
That said, the code =Contract!C8:D8 on my project detailer sheet returns the customer name like I want it to.
If column F, G, H says PAP then I want it to return information from column A, B, C, D, E respectively into another worksheet. I have attached a sample
View 6 Replies View RelatedI'm trying to find the coding to be able to do the following.
If Manufacture = Dimond in Cell C3 then in C5 show list from database Worksheet, of A4-A9, if C3= Steel & Tube then show list for A13-A18
Cell C3 is a Data Validation List
I keep getting name errors etc.
I want to create a macro that will take information from one worksheet to another. The problem is that the first worksheet has an autofilter and i do not know how copy information only from the cells that were filtered with the correct information without copying it manually.
View 3 Replies View RelatedI want to setup an excel spreadsheet that will list employees and when exams were completed on them. The exams need to be completed once a year. I want the excel spreadsheet to send out an email to their corresponding supervisors when is within one month or so of an exam needing to be completed so their exam can be scheduled accordingly.
I have searched this forum and read through some of the other posts regarding exporting data from excel to outlook. This seems like what I need to do but I wanted to see if anyone has an advice on what way is better than the other?
Also, if excel is setup to push the data to outlook, does the excel file need to be open? In other words if Jimmy comes within one month of his exam but no one opens the excel file will it send out the email to outlook?
Is it a better option/ or possibility to have Outlook pull/check to see if the condition exists where an employee is within a month of his exam and then let the supervisor know?
I'm using a v-lookup to pull information from one worksheet to another. I know that each of the cells has a match on the second sheet, but the calcuation is resulting in a Value Not Available error. The only way I've figured out to get past the error is to go into each cell, hit F2 and then enter.
View 2 Replies View RelatedFor some reason I need to display quite a few computer's installed software from system information in to separate worksheet.How can I copy all installed programs and paste into new worksheet with a code?
View 1 Replies View RelatedI'm trying to fish information from one worksheet to another.... Here's my sub, what's my SUBcranial problem?
Private Sub bt_PopulatePage_Click()
' Inventory Data Transfer to Report Structured Page
Sheets("Liquor Data").Select 'Switch to Liquor Data Sheet
Dim x 'Line Numbers x = Liquor Data Line
For x = 2 To Last_Row("B") 'Start at the first Liquor Entry Line
Sheets("Liquor Data").Select
t_liq = Cells(x, 2) ' Liquor Name in Starting in B,2
t_Class = Cells(x, 4) ' Class starting in B,4
t_type = Cells(x, 5) ' Type Starting in B,5
t_dist = Cells(x, 8) ' Distributor Starting in B,8
Sheets("Inventory Form").Select 'Select Inventory Page
Cells(x + 7, 1) = t_liq
Cells(x + 7, 2) = t_Class
Cells(x + 7, 3) = t_type
Cells(x + 7, 4) = t_dist
Next x
End Sub
In one worksheet there is a code for every customer and their details e.g. Name, medication they are on, what they are alergic to etc then in another new worksheet can we just type in that code and their individual information comes up automatically?
View 4 Replies View RelatedI am a complete amature at Marco's and formulas. I have been trying to create what i need but i am unable to get it to work. I have a worksheet named "Course dates incl. pursuit" which has a table which runs from B7 to J144 in the table it has date, number, name, location, job, area, notifified, on system and passed?. in that order. I want if the passed column which is in J if that has a Y in it to copy and paste into another worksheet on the next avaliable line, worksheet name "Master."I would like it in a slightly different order if that is possible they have the same titles on the table but would like it to go number, name, location, job, area and date. Running from B5 to G(end of spreadsheet). That is the main part i would also like to to copy and paste into another worksheet if the answer is "N" but the above part is the most important part. Due to the computer settings i am unable to attach it
View 6 Replies View Relatedwhen I reference the information in worksheet 1 with worksheet 2, and I have no info in worksheet 1, I get zeros in worksheet 2. is there a way to have the cell show up empty until there is information worksheet 1?
View 9 Replies View Relatedhow to reference cells in 1 page from another and understand basic formula's, and would appreciate any input on how or if i can acheive what i'm trying to accomplish.
I have a worksheet with say 100 rows of information, it is a list of materials to go into a construction job. the columns to the right of the description calculate volume/quantity etc and produce a cost for the item. what i want to do is have a summary page that only lists the items that are being used, not all 100 items are in every job and i dont want to have to print the whole list with a bunch of empty values, which will just waste paper and ink. I'd like to enter a value in a cell or setup a check box or something that i could somehow use to then list that row or a part of that row of information on a seperate sheet, for a nice concise, easy to read list of job materials. i would like to do produce 1 sheet with the cost associated with the item, and one without cost.