How Do I Use Lookup To Find Data Based On 3 Criteria
I have a bit of a challenge. You'll have to take a look at the attached files to understand what I am trying to do. I am asking for your advice. I am creating multiple spreadsheets (QPPcompany.xls) that will refer back to a master data(QPPdata.xls) file.
I am trying to figure out how to best set up the data file so that I can do lookups on the data from the referencing files. Here's the challenge. I need to be able to find in the data page the company name in Column A and then how many L's (or C's or P's) they had in a specified month. So for instance I need to be able to find the number 3 in cell E6 and place it in B15 of the referencing file. The required criteria for lookup are Company Name, Month and then L, C or P.
So my question is, is this possible with how my data file is currently set up? I think it may be a problem to have the month/year in row 4 refer to 3 different colums for each month (L, C and P). I don't mind making changes to the data file to make these lookups possible and I think it may be necessary.
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Lookup Data In Another Workbook Based On Criteria
I have a work book with several work sheets, what I'm trying to do or find a a method of coping data from one sheet to another provided the data in any given cell matches a specific criteria. Example below: Work sheet 1 is the primary sheet in the work book on this sheet I have a cell with a text value (Bob). Ok on the next work sheet 2 I need to search for a cell that contains (Bob). When or if it is found I need information from other cells in that row (where Bob was found) copied to work sheet 1 in a specified row and colum. If it is not found a negative value can be placed in the specified cells.
View Replies!
View Related
Return Data Based On Lookup Criteria
I have an array in excel, 4 columns: Month, Day, Stock, Price. I dont know the most efficient way to handle arrays. I know i can loop through an entire array to find a specific value, but if i have a large array, this doesnt seem efficient. For example, I would like to find the price in an Array (or Range), when i know the value of two columns. If this were in a database, I would write sql like this: " select Price from TABLE where month = 1 and Day = 3". The result would be 40.21. How can i do this with an array? I have attached a sample spreadsheet with the example mentioned above..
View Replies!
View Related
VBA Lookup Function: Paste Data Into A Cell In Another Worksheet, Based On Criteria Specified In Sheet1
I'm looking to create a macro that will take data from an input sheet, and paste it into a cell in another worksheet, based on criteria specified in sheet1. Specifically in the attached example, the macro would copy the data in cells C8:C10 of sheet 1, then paste them into sheet 2 based on the data specified in cell B3 i.e. it would paste them into the column headed Mar-09. I intend to make this cell a drop down, so that the user can then select the next reporting month and run the macro again to paste the data into the Apr-09 column.
View Replies!
View Related
Find Data Based On Horizontal And Vertical Criteria
I have a spreadsheet that I am trying to create a formula for that will bring back the data found when you compare an X and Y axis. A sample is attached as the data is huge and I figured what ever you all created I could modify. I need it to bring back the data found when I run my finger down the column till I hit the appropriate row.
View Replies!
View Related
Lookup Based On 2 Criteria
I need to take a value from an adjacent cell and automatically enter that value in a specific cell in table on a second worksheet. The cell must match two criteria specified in the previous two ceels to the value. The table is made up of dates and colours, it seems simple in my head but I'm not sure where to start, i would like to use a macro so when a specific key is pressed the information is automatically entered into the relevant cell.
View Replies!
View Related
Lookup Value Based On Two Criteria
I have two pivot tables (for sales and purchases) with three columns each, ie: company 1, company 2 and amount I need to reconcile that for the internal purchases and sales the sale value is the same as the purchase. So in first pivot table (purchases) I have one row with internal transactions where company 1 = AZS, company 2 =YDR, value 100 In second pivot table (sales) I have one row with internal transactions company 1= YDR, company 2 = AZS, value 95 I would like to develop a macro that would check automatically the combinations of companies and find out if there are differences between sales and purchase. So in the example it should show that there is 5 usd more in purchases. Hopefully normally is zero
View Replies!
View Related
Lookup Multiply Based On Certain Criteria
I have two worksheets, one is setup with a part number only and the months Jan-Dec. The other worksheet has those same part numbers, but it also has the quantity and the months Jan-Dec. I need to do a lookup to find the part number, multiply it by the quantity on that given line, and then multiply it by the quantity in the month. I will show you how my worksheets are setup: Worksheet1: Qty P/N Jan 1 123456 100 1 123456 100 2 456789 50 4 123456 25 3 345678 500 1 456789 75 Worksheet2: P/N Jan 123456 Sum of ALL Jan Demand * the Quantity of each item 345678 Sum of ALL Jan Demand * the Quantity of each item 456789 Sum of ALL Jan Demand * the Quantity of each item
View Replies!
View Related
Result Based On Two Criteria Lookup
See the attached file. I think index and match may help me having done a search several times in these forums, but having been trying to do this for several hours I am just struggling to understand each part of the formula unfortunately. I have a list of data (cellsA1 to C33) which I need to use as my source for the information that is displayed in cell I2 based on the two selections made in cells F2 and G2. I can't use filter and data sort in this situation - I am creating a spreadsheet for someone who truly knows nothing about excel, so I need this to be as simple as pointing and clicking at cells F2 and G2 and the formula doing all other work. Is it possible to do what I am asking for (hopefully the fact that peoples' names are repeated and months are repeated won't cause a problem?
View Replies!
View Related
Two Page Lookup Matching Criteria Based On Cell Value
I have an items list on page 2. On page 1 I want to create a drop down menu in C2 that references the list on page 2. Then when I choose an item, I want the additional information in cells D2 and E2 to come in automatically. The list on page 2 will be expanding daily, and when I expand it I can simply insert a new row so I correctly alphabatize it instead of constantly having to resort it. With that said.... 1. How do you put in the drop down box that references information on a different sheet? 2. What is the best way to reference the information in my ever expanding situation: Index/Match, Vlookup, Lookup, or something I havent mentioned?
View Replies!
View Related
Lookup Based On One Criteria & Skipping Blanks
I'm looking for a formula for return a result only when one other criteria is met. I've looked at SUMPRODUCT and VLOOKUP as options but haven't been able to make them work. Here is what I need: I want cell E33 to look up cell B33 in 'Test Result Table' and return the 12th column of information, but only when cell C33 and 3rd column in 'Test Result Table' match. If the first result isn't a match I want the lookup to skip it and return the first available match. I don't want to add anything, I just need a match returned based on C33 and the 3rd column being equal (cell C33 is a VLOOKUP of the 3rd column in 'Test Result Table').
View Replies!
View Related
Lookup - Trying To Find First Unique Value Based
I have scoured the Excel boards but cannot find what I am looking for. Need to do a formula approach (No Pivot Table) lookup on a dynamic table that is not necessarily in order and may have blanks in some cells or whole rows. What I would like Excel 2003 to do is report (extract) the all first occurrences of each organization number that has at least one person with a "Yes" in a corresponding column in the same row. I also need the number of persons that have "Yeses" in each of those identified Org Nos . Data is laid out as such: Org No. Name Not in Compliance 8631Steve Yes 8631David 8631Nick 8631Tom 8631Susan Yes 8701Peter Yes 8701Diane Yes 8701Mary Yes 8879Don 8879Bernie 8879Wayne 8900David Yes The answer is In one row list the org #'s not in compliance ("Yes"). In the row just below it the number of persons: 86318701 8900 2 3 1 I have a helper column that counts the number of unique org nos, but cannot tie that to those that have Yes in the other column. In column before Org No i have =IF(COUNTIF(b$33:b34,b34)=1,MAX(a$33:a33)+1,"") copied down.
View Replies!
View Related
Lookup Formula: Find The Longitude And Latitude Data From My "lookup" Sheet
In my workbook I have multiple sheets but I'm attaching a very simple workbook to demonstrate what I'm trying to accomplish. In my "Lookup" tab/sheet. I want to have known Latitude and Longitude data that will exist in columns A&B. Columns C & D will have address numbers and Street Name. I would like my lookup formula to find the longitude and latitude data from my "lookup" sheet, when the matching address information is typed in, in my 2009 sheet. I have to keep the street numerics and street name separate on this worksheet as well. I believe I'll need two separate lookup formulas as I need these formulas to start in cell G4 & H4 in my "GeoCoding1" sheet. Is it possible to have four columns of data to be viewed in a lookup formula? I tried this formula in cell G4 (GeoCoding1 sheet)
View Replies!
View Related
Find And Sum Based On Criteria
I have a sheet with 3 columns - Line, Product and amount. I have to calculat the amount based on which line it is, and which product. I. e I want to calculate all the amount in Line 1 except if the product is 3,23,31 (just an example - the range can be longer). In workbook added i have shown the problem. I have tried the sumproduct formula, but cant get it right!
View Replies!
View Related
Find A Value In A Table Based On Other Criteria
I'm trying to find a suitable formula that looks at two cells (J3 and V3) in Sheet 1 (a person's employment grade (e.g. 18) and their performance percentage e.g. 92.5%), finds those values in a table on Sheet 2 and then places the corresponding value from that table in Sheet 1 at cell Z3.
View Replies!
View Related
Lookup Data Meeting Criteria
I am trying to include a series of vlookups to find products by a product code from a database, an example is attached. I want to type a code into the box at the top and find the results containting but not uniquely being the input. eg typing 15 in automatically finds 15 using "=VLOOKUP(TRIM($C$6),'Main Database'!1:65536,2,FALSE)" but my database also contains 15eurd and 15rf etc and i want these to appear too. can i do this with vlookups with some clause that excludes a previously chosen entry?
View Replies!
View Related
Find Closest Match Based On Two Criteria
I have a sheet of pump test results, placed in rows, where the test rig is set at a specific speeds and flow and it records pressure. At each stage of the test a number of snapshots will be taken (Usually between 3-5 at each stage), so I have 3-5 rows of very similar data. I only need to use the best row from the selection available, so I am hoping to find a formula or code (Don't care which) that can look at the results and select the row of readings where the speed AND the flow are closest to the targetted data. For example: In cells G6:G8 I have flow result values 0.129, 0.151, 0.156 and in H6:H8 I have speed result values 72.536, 71.82, 72.13. These are actuals. In cell N6 I have the target speed (75) and in O6 I have flow target (0.15), but these could be moved anywhere to suit really. What I was hoping to do, but am struggling big time, was to just flag up the row of readings where these two values are closest to the targets by placing a check mark in column L:L which I have formatted in monotype sorts and would like to place a "4" (Which gives me a check mark) on the 'best' row. From that I can do more with some simple IF statements. Is this feasible, or am I trying to do something beyond Excels capability, it is certainly beyond mine at the moment. I was looking at the check mark method, but that is not essential, so if anyone has any suggestions on an alternative means of identifying the best row of data, that might make it easier to do, then I am listening.
View Replies!
View Related
Find A Value Based On Criteria In Columns And Rows
I have a workbook in which I have two sheets. One sheet is a report and the other is a data dump. The data dump has headers in in column A starting in cell A6 and headers in row 5 starting in cell B5. There is then data going from B6:J20. In my report I then I have same setup with headers in column A and row 5. The difference is that the headers are not in the same order as the dump. What formula could I use that would look for the two headers in my report sheet and then match it with the value in the data dump that uses the same two headers?
View Replies!
View Related
Lookup With Multiple Criteria: Return The Amount Paid And Full Cost Based On The Person's Name And The Date
I would like a lookup that takes multiple criteria and that is not an array formula! Unfortunately I decided to use array formulae and my spreadsheet went to over 45mb!! Not good. I've searched the forum for an answer to my questions but couldn't find any! I've attached a spreadsheet as an example. The examples I am using have {Sum(IF)} formulae in it (array) and I would like to change those to others that will not increase the file size so much and will not take too long to calculate. Basically, I would like a lookup that will return me the Amount Paid and Full Cost based on the person's name and the date. the data and the results table are both on separate sheets. It would be nice to bring that file's size back down to less than 4mb!!
View Replies!
View Related
Lookup Row And Column As Criteria But Data Is Spread Across Columns
I need to bring in values into one worksheet from another worksheet using row 1 and column A as criteria. I have previously done this using Sumproduct. However the complicated issue with this new worksheet is the setout. The source worksheet (see attached) has the actual data spread across columns. How can I bring in the values to the 'Summary' sheet from the '0607' sheet using the Employee number and the seg code as 2 criterias to lookup and bring in the resulting data (which is spread out in the purple area in the '0607' worksheet).
View Replies!
View Related
Lookup Or Data Change Based Upon The Data Reported In Column
I need to pull info to additional tabs. The problem I am having is that the data is sorted daily based upon performance numbers, so the REP names in column A can change based upon the data reported in column C. What I want to accomplish: Pull daily data for each unique name in column A to a team tab/worksheet that will be used to report that team's daily data. Below is a representation of the data I need to break down by Rep Name and Team. Rep DATA DATA DATA DATA DATA DATA DATA 1 2 3 4 5 6 7 REP 2 27.5% 14 51 86 REP 1 33.3% 14 42 74 REP 3 19.3% 11 57 86 REP 5 19.6% 9 46 66 REP 4 33.3% 9 ...........................
View Replies!
View Related
Data Lookup And Email Based On Data Extracted.
I have a excel spreadsheet that has employee names, email address and DOB. The DOB format is 23/03. I need a program that will lookup the DOB row and when it matches the value I enter it extracts the employee name and email address. Once it has this information I need it to copy into an already created email template and send its off. On some days there are more than 1 person with a birthday so it will need to send multiple emails.
View Replies!
View Related
Find Data Depending On Two Criteria
I Have want two find the dates and the data of these dates depending on the two criteria i have note"the two criteria would be left(b3,4) and right (b3,4) ex in f3"date" i want to find the dates correspond with these two criteria and then find the data of these dates in G3 Depending on the two criteria too. Sheet1 ABCDEFG2DateData Criteria1Criteria2DateResult31/1/2008M111 GG1G M113 M191M1131/2/2008M191 G1GG M11341/2/2008M191 G1GG M113 1/5/2008M191 G78GG M11351/2/2008M111 GG1G M113 1/8/2008M191 G1G9G9 M11361/3/2008M141 GG5G M113 71/4/2008M118 GG6G M113 81/5/2008M191 G78GG M113 91/5/2008M141 GG5G M113 101/6/2008M111 GG2G M113
View Replies!
View Related
Return All Data Based On Lookup
How to return all possible values based on a single lookup ( or another condition / macro ) I have a table in B5:E100 In A1 I have a value I need to look in B5:B100 for the value in A1 then place the contents of B:E for those cells in G5:J5 downwards
View Replies!
View Related
Lookup Headings Based On Data
Assuming I have a table such as: APPLE BEANS CELERY DOUGH Will 5 10 15 2 Joe 1 3 7 11 Ben 9 6 4 8 What formula can I use to return a result like Celery by looking up Ben and 4 for example. In other words, how do I lookup the heading of the column based on the the first column and a data point on the same row.
View Replies!
View Related
Create Charts From Same Data But Each Based Ob Data Criteria
Hi, have a question regarding dynamic charts, specifically I am trying to create several dymanic charts based on data in a single column (So i can only say my first set of data will be starting a a set location in the chart, the rest has to shift down based chart data above it). This data should organized in charts depending on the data in several other columns. For instance, need to pull out values from column based some ID and some PartNumber. A sample excel or VBA would be much appreciated. I know VBA but do not know Excel VBA much.
View Replies!
View Related
Lookup Data Based On Cell Content
I am setting up a worksheet (1) with a full list of part numbers supplied, cost etc. ie: Part Description Price Qty 1234 Blah Blah £1.00 1 1235 Blah Blah £3.00 0 1236 Blah Blah £2.00 2 And I have set up a seperate worksheet (2) as an invoice. What I have been trying to do is when I enter a qty in worksheet (1), worksheet (2) will reconise an entry in the qty colum an copy selected fields/ cells. I can do a "=" or use an "if" statement looking at anything greater than "0". but is there a way I can get the invoice worksheet to ignore any lines with "0". So it will only copy over the information with only qtys for the invoice ?.
View Replies!
View Related
Counting Data Based On Criteria
I have a spreadsheet that has Leads in column H for eg Advertisements and Presentation dates in column K I need to set up a formula that will count the number of dates (Items) in column K that is applicable to the item in column H for eg Advertisements, Referrals etc . There can also be blank items in column K which can be ignored
View Replies!
View Related
Extract Certain Data Based On Criteria
I have a raw database that contains various data all in one column and I only want to extract certain data to a new column. All I want is to extract the time, like 14:00, 14:15, 14:30, etc...... from column "A" and populate column "D" if it meets this criteria. I have tried everything I can think of, very difficult yet it seems to be so simple. The "date" is really a date format but the "time" is really text. Here is what the data looks like: Column A has.... Name1: Name2: Name3: 10/16/2006 14:00 14:15 14:30 14:45 15:00 10/27/2006 16:30 16:45 17:00
View Replies!
View Related
Count Data Based On 2 Criteria
I've looked at the various examples in a search of topics simillar to my topic but I still can not get thsi to work. I have a work book that contains 2 sheets Sheet1 is called RawData of Multiple columns Sheet2 is a quick report basded on Sheet1 data. I need to find a way to do counts where 2 criteria are met. Example. Count the number of Times the phrase Major Victory appears in column M ( Range M1 to M50 ) of Sheet1 IF the value in Column L ( Range L1 to L50 ) of Sheet1 = USA I tried this: =COUNTIF(RawData!M1:M50,B1( AND(RawData!L1:L50=$A1))) I am using B1 and A1 ( from Sheet2 ) as search criteria but it gave me 0 ( and I know this is wrong ). Based on the reading I did on simillar topics it appears that I cannot use CountIF in this case.
View Replies!
View Related
Data Validation Based On Two Criteria
I need a data validation to prevent entries when they are > 50, but only if the value of another cell in col A is "Payment". The value of 50 is an example, I have another formula to get this number using VLookup. The idea is that if the value of the cell in col A is "Income", I don't want the entry to be rejected. But if the value in col A is "Payment" or "Transfer" and > 50, I want the entry to be rejected (if I only have $50, then the payment cannot be > 50).
View Replies!
View Related
Print Data Based On Criteria
I have a sales workbook, with three sheets. Ongoing, Won, Lost, all potential sales are entered onto the Ongoing sheet and Ongoing is chosen in a column that has 3 options - Won, Lost, Ongoing, until brought to closure by winning the sale or losing it at which point Ongoing is changed to Won or Lost. The products for sale are Audio, Video and System and at the top of the Ongoing sheet it totals those three categories as Won, Lost or Ongoing. What I want the workbook to do is when the status of the sale is changed from Ongoing to either Won or Lost, the entire row is moved off the Ongoing sheet and placed on the appropriate Won or Lost sheet, and the totals at the top of the Ongoing sheet calculated accordingly. One of the columns on the Ongoing sheet is 'Progress' in which a short abbreviated explanation is input of next steps of the sale. When the sale is closed, and hopefully automaticall moved to it's appropriate sheet, I'd like this text to be changed to either Won or Lost.
View Replies!
View Related
Auto-enter Data Based On Criteria
Here's a sample of a completed table I would like to have. Sheet2 *ABCDEFGHIJKL68*# ofSTART*wk #wk #wk #wk #wk #wk #wk #wk #69ACCTWEEKSWKRATE1234567870110181 $ * * * *10.00 $ *10.00 $ *10.00 $ *10.00 $ *10.00 $ *10.00 $ *10.00 $ *10.00 $ *10.00 71110242 $ * * * *10.00 * $ *10.00 $ *10.00 $ *10.00 $ *10.00 ***72120143 $ * * * *10.00 ** $ *10.00 $ *10.00 $ *10.00 $ *10.00 **73120272 $ * * * *10.00 * $ *10.00 $ *10.00 $ *10.00 $ *10.00 $ *10.00 $ *10.00 $ *10.00 74120381 $ * * * *10.00 $ *10.00 $ *10.00 $ *10.00 $ *10.00 $ *10.00 $ *10.00 $ *10.00 $ *10.00 75130151 $ * * * *10.00 $ *10.00 $ *10.00 $ *10.00 $ *10.00 $ *10.00 *** Excel tables to the web >> Excel Jeanie HTML 4 If given columns B and C, is there a VBA code that will look to those columns and auto-enter the payments across the week matrix based on that criteria?
View Replies!
View Related
Removing Data Based On Multiple Criteria
I need to remove any rows containing "EEE" in the size column. I also need to remove any discontinued ("D" in the "Type" column)styles that are currently not in inventory. For example 05-5490 does not have any available in either width "D" or "EW" and should be removed; however, 28-112 does have stock and should remain in the spreadsheet. Anything with an "F" in the "Type" column should be left alone.
View Replies!
View Related
Return Data To Another Sheet Based On Criteria
Sheet 1 Column A = Dates Row 1 = Filenames I enter a Y in the intersecting cells of the Filenames & Dates to show which files were downloaded. I need is a formula that will rearrange this layout onto Sheet 2 so that each ‘Y’ (downloaded) filename is inserted in a cell corresponding to the Date. (see attached sample)
View Replies!
View Related
Formula For Appending Data Based On Criteria
how to search for this so I'm just gonna ask. See sheet below I faked the resulting formula I need) for reference. We have an engineering database that spits out data. One of the things it spits out is a list of equipment tags along with its associate electrical drivers (I.e. motors) and details for each. I need to do some extra playing around with the official equipment list that we have to produce. In a nutshell, if an equipment tag only shows FIXED in any of it's drivers, I want the formula to show nothing (blank). However, if the word VARIABLE appears in any of that tag's drivers, I want it to show VARIABLE. I know there's a formula involving IFs and whatnot, I just can't figure it out. ******** ******************** ************************************************************************>Microsoft Excel - Book1___Running: xl2002 XP : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutA1=ABCD1Equip TagDriver NameSpeed TypeFormula234-AG-900Primary DriverFIXED 334-AG-918Primary DriverFIXED 434-AG-932Primary DriverVARIABLEVARIABLE532-AG-931Primary DriverFIXED 632-AG-910Primary DriverFIXED 732-AG-911Primary DriverFIXEDVARIABLE8 2nd DriverVARIABLE 9 Tert Driver 1FIXED 10 Tert Driver 2FIXED 11 Tert Driver 3FIXED 1232-AG-916Primary DriverFIXED 13 2nd DriverFIXED 1432-AG-918Primary DriverFIXEDVARIABLE15 2nd DriverFIXED 16 Tert Driver 1VARIABLE 1732-AG-921Primary DriverVARIABLEVARIABLE1832-AG-922Primary DriverFIXED 1932-AG-923Primary DriverFIXED 2032-AG-924Primary DriverVARIABLEVARIABLESheet1 [HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name boxPLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.
View Replies!
View Related
Summarize Data Based On Multiple Criteria
I have a worksheet with several columns of data that I have to summarize elsewhere on the sheet. Here are the columns: ID Status Joined Name Name can take on 4 possible values. For each value in Name, I want to count the number of cells in a column that fit certain criteria. Here are the counts I want to make: Status OK: Status is a date. Joined OK: Status is a date and Joined is a "1". There are going to be about 500 records to count. I've already implemented these counts in a Windows scripting language that interfaces with Excel, but I know there must be a more direct and faster way to do it entirely in Excel, whether with VBA or writing functions into cells.
View Replies!
View Related
Copy Data To New Workbook Based On Criteria
I have a workbook that is used to track job estimates. What I would like to have is a macro that would search through column N on the original file and if any of the cells have "No RFE" in them - generate a new workbook with only this list that would include any data from columns C-U copied from the original file. I've been seaching the forum, but so far have had little luck finding something that suits my needs.
View Replies!
View Related
Move Data Based On Criteria In Column
Here is the situation: There is a spreadsheet that I use that has multiple plans in one column for various members. You can see the plan for Robert James and Amanda James is plan 5. If all this information was in column A how would you move the plan type say column C for each member? For example Column A Customer Name Robert James Amanda James Plan 5 Nikki Martinez James Gross Plan 6
View Replies!
View Related
Display Data In List Based On Criteria
II have a list of football fixtures (see attached sheet - barclays premiership) each with a different status Win,Loss,Draw,Pending. I want to display the next team with a Pending status in a cell at the top of the list (cell T13/14) so the user knows at a glance what the next fixture is. I also want to display the days remaining to that fixture in the cells below this (cell T15/17).
View Replies!
View Related
Macro To Copy Data To Other Sheet Based On Criteria...
We're working with a large workbook with data from A5:P20000 on sheet1. I need to be able to pull data from sheet1 to sheet2 based on the invoice number in column A on sheet2. Sheet2 will have different invoice numbers in column A, some of these invoices numbers are in column H on sheet1. I need excel to find these invoice numbers and copy the data from that row on sheet2 to the row with that invoice number on column2. Example: Sheet2 A5 has invoice number 1234457 This same invoice number is located on sheet1 H3400 Need to copy to sheet2 (starting in cell B5) the following cells from sheet1 (B3400, C3400, E3400, G3400, H3400, I3400, J3400, K3400, M3400, N3400).
View Replies!
View Related
Copy Data Across Multiple Worksheets (based On Three Criteria)
I have data on a worksheet (“Interface”) that I need to copy over 7 other tabs for analysis. ("Module_1", "Module_2", "Module_3", "Module_4", "Module_5", "Module_6", "Module_7"). The linking Field on the Interface tab defines what row I need to paste the data to on Module 1-7. The column headers are the same on both the interface and other tabs (“YES, NO, N/A, BLANKS, STANDARDS MET, STANDARDS NOT MET, NOT APPLICABLE”) The tab is selected based on the row Module 1Medication Management Module 2Privacy Module 3Process Module 4Patient Safety Module 5Medical Records Module 6Infection Control Module 7Environment of Care I’m trying to modify code written for a similar purpose with no luck. This is the code I'm trying to modify. I know I'm not on the right track yet.
View Replies!
View Related
Macro: Copy Data Based On Criteria/Condition
Attach is a sample of my project. I have to loop through B9:B80 in sheet("Raw Data") and capture the value of each cell. EG: * if Value captured is 120A --> check with sheet("SP14F") from the row which contains the same value. * i have to check that the aperture, outer and inner values of Layer 120A and so on..of the Raw Data sheet is the same as that of in the SP14F sheet. * if the values are not the same, change the font to red i understand that this task requires looping and arrays.
View Replies!
View Related
Macro: Count Data In Range Based On Criteria
I have a list of several ranges defined in vba, and i am trying to find which range a cell containing word is in excel. Im am looking for help for a good way of doing this. For an example: Say I have 2 ranges defined, the first range corresponds to column A, the second to column B (just an example). The word "Dog" is written in cell B15. I want to find out in vba what range "Dog" is in. I would like some vba code to check and find either if it in a given range (boolean) or a way of checking a list of ranges and returning which it is in. The word will only appear once on the spreadsheet. I have played around with the find command (A=range.find(Pl), then check if A exists) but i havent had any luck (I get an 'Object variable or With block variable not set) I tried searching for a while, but was having trouble finding something related to what i am trying to do.
View Replies!
View Related
Copy Row Data To Another Worksheet Based On Criteria
Data exists in a workbook's sheet name "0293" in columns A, B, C, & D. If a row's value in column B exceeds zero, the entire row & formatting needs to be added to the bottom of data in a sheet called "Comprehensive" of the same workbook and put 0293 in column E of the same row. What would be the simplest VBA code to copy sheet 0293's data & add it to the "Comprehensive" sheet with the sheet name in column E of the same row?
View Replies!
View Related
|
TRACKER
