match columns

  1. Z

    Macro to Copy Entitre column of Matching Column Header & Paste to Matching Column Header

    Hi There, I need help building a macro that copies entire columns from one workbook over to another based on matching column names in row 1. These copied columns would then need pasted in another workbook based on the matching column names. Another way of saying this is to use macros to do a...
  2. J

    Copy data from worksheet A to worksheet B - if column headers match

    Hello, I am working on being clearer/more concise when referring to code, so I've put notes within the code to help tell a story... please let me know if you have any questions. The code I've been able to pull together is great, but I can't quite get the last step down which is killing me! I'm...
  3. M

    Userform - Find Matching Date in column then send data? If data exists, error message?

    Hello everyone, I have a UserForm which allows staff to pick individual workers, choose a job, then enter a quantity. The script will find all matching names that were selected and then sends the quantity to the next open column in that row. The problem is if data is entered more than once a...
  4. H

    Get 1 column values by matching 2 columns from 2 worksheets

    In my Excel workbook, I have 2 worksheets: tab named "C2" & "M". In C2: B2:B100 contains names & C2:C100 contains numerical values. In M: A2:A50 contains names (same as of C2 ws). Output column U2:U50: should be from C2:C100 of ws C2 for names matching. Thanx in adv
  5. I

    Find and mark the row matching the numbers

    Hello Everyone, I would like to create a rule that finds a set of numbers in a table and highlights the rows that matches the exact numbers: - All numbers must match in a row in order to highlight the rows. - Numbers order is not important. - Advanced: ability to control how many of the...
  6. F

    Multiple MATCH

    Hi, how can I add second MATCH into below function: OFFSET(Sheet2!$BS$1,MATCH(Sheet1!$H$9,Sheet2!$BR$2:$BR$402,0),0,COUNTIF(Sheet2!$BR$2:$BR$402,Sheet1!$H$9),1)) example: If in one field I select Austria, and in second field I select Wien, I want to have in third filed ALL STREAT for Wien...
  7. N

    Comparing columns & returning values

    Im going crazy trying to figure this out, help please! I have data that looks like this: _A__|_B__|_C__|_D__ 123…………….234….$12 234 …………..236….$56 236 …………..123….$11 654 …………..764….$87 001 …………..654….$98 002………………………….. 764 …$87…………………. 670………………………….. Columns A & C are sku's. Column D is the...
  8. C

    Finding closest value in a non sorted column (equal or greater)

    Hi Excel Masters, i am trying to come up with a formula that can give me the closest value in a non sorted column (equal or greater). I can not use a simple match as my column can not be sorted.. I am using the below formula but doesnt work all the time... Any help would be greatly...
  9. M

    If A, B, & C are the same in any order across any row, and D = "text" then copy to new table.

    I have data exported to Excel from Sharepoint showing projects that are dependent on each other, the type of dependency and which is is dependent on which. <TBODY> Project with Dependency</SPAN> Project it has dependency with</SPAN> Type of dependency</SPAN> Relationship</SPAN>...
  10. C

    data, column, cells matching

    let say i have 2 sets of data in sheet 1. Column A and E is date, B and F is invoice number, C and G is the amount due. A, B and C is issued, and E, F and G is received. some of the data in column ABC will not have in EFG, as the payer will have omitted some payment. what im trying to do is to...
  11. T

    matching multiple columns

    I have data in columns c,d and e on sheet 1 (with each row representing one entry) that I add to periodically and I have a fixed set of data on sheet 2 with 4 columns (a,b,c and e). I would like to match column c with column a on sheet 2, column d with column b on sheet 2 and column e with...
  12. M

    vlookup to sum different columns....BUT....

    HELLO EXCEL fans & pro's i have a have a matrix in a separate sheet a9:bb70 [where columns c9:bb9 are the 52 weeks of the year] each row [9 to 70] represents totals [hours] of a particular project in any of the 52 weeks i have another sheet where a user can select a period of time [start...
  13. D

    Match for a single Column using the same Column header in 2 different worksheets

    <colgroup><col span="4"></colgroup><tbody> Worksheet 1 Posted Worksheet 2 Worksheet 2 John ? John Ben Matt ? Mat Scott Ben ? James ? </tbody> I need to return a match to worksheet1 if the names exist in either worksheet 2 or worksheet 3. The formula I normally use is...
  14. C

    Match data in two columne and return header

    There's probably a simple way to do this but I keep tripping over something. I have two columns with team abbreviations, one simply says whether they are AL or NL the other is the result of a search with multiple occurrences of the team name. I need to match the long list with the short and put...
  15. P

    How to sort and match three columns w/ some blank cells

    I am using Excel 2003 and I need to sort and match three columns: Column A: Column B Column C About Column A: Column A contains 40 rows of data (numerical codes in each cell). I would like to sort Column B and Column C according to the sequence of data in Column A. For instance, if there is a...
  16. S

    Spreadsheet Compare

    Hi, I am in process of creating a spreadsheet to track all maintenance activities on a piece of plant. The tracker I have now has approx. 1000 entries for each maintenance job. I now recieive a weekly plan for future maintenance and am looking for some routine that I can compare the two...

Some videos you may like

This Week's Hot Topics

Top