Excel Questions | Forum profile

Nicole I'm sorry but that makes no sense at all.

Try this... In the formula: Table refers to your 5 row x 8 column table Result refers to the column of results =INDEX(Result,MATCH(1,MMULT(--(Table=A2),{1;1;1;1 ;1;1;1;1}),0)) Copy down as needed.

Try Code: Sub Concat() Dim LC As Long, LR As Long, j As Long LR = ActiveSheet.UsedRange.Find(what:="*", SearchDirection:=xlPrevious, SearchOrder:=xlByRows).Row LC = ActiveSheet.UsedRange.Find(What:="*", SearchDirection:=xlPrevious, SearchOrder:=xlByColumns).Column For j = 2 To LC Range(Cells(1, j), Cells(LR, j)).Cut Destination:=Range("A" & Rows.Count).End(xlUp).Offset(1) Next j ...

http://www.mrexcel.com/forum/showthread.php?t=8935 6

Faster Way to Delete Rows? My spreadsheet is a contract file that includes a list of part numbers being sold. Each part number refers to a lookup table of ALL about 20,000 valid part numbers and prices. Once the contract is finalized, I want to make the contract sheet smaller by deleting all rows in the lookup table that are not ...

Hello You forgot the ' in the formula: Code: "=Vlookup(A3,'" & CustomerSummary & "'!$A$3:$B$65536,2,0)" (after the first comma and in front of the double quote ". I also had to add a space in front of "Summary" in: Code: CustomerSummary = Left(ActiveSheet.Name, Len(ActiveSheet.Name) - 7) & "Summary" By the way, do you really need such long ranges in your lookup?...

Quote: Originally Posted by mucah!t Range C6:AJ6 will be a little bit more complicated it should place a 2 in each cell, starting from 10 cells prior the 3th last number in range C5:AJ5. That would be impossible (not enough columns) if that 3rd last number was in the range C5:J5. What should happen in ...

look at vlookup using the part number as the lookup value

What help procedure did you try?

Help; I have a (work sheet) that contains two "name" cells, and I need to gather that information into one cell on the mailing list (work sheet.) How? Anthon

Faster Way to Delete Rows? My spreadsheet is a contract file that includes a list of part numbers being sold. Each part number refers to a lookup table of ALL about 20,000 valid part numbers and prices. Once the contract is finalized, I want to make the contract sheet smaller by deleting all rows in the lookup table that are not ...

How about =AND(MOD(INT(A1)/100),100) < 35, ISEVEN(INT(A1)/100))

functions and formulas for Dummies This formula is functional , provided by a programmer for a charting program written on Excel Worksheets. I copied it directly into my Excel workbook and it obtains an error message. =AND(C

Re: Excel called from VBS does not fully exit Your code looks ok to me. Although you do not seem to be doing it, the only other time I have seen problems is when something has been selected, when this is required before the shutdown :- Code: Application.CutCopyMode = False You can get your Sort code by ...

HOW TO stop #NA appearring in index and mATCH function? Hi I have this equation =(INDEX(abc!B8:D18,MATCH(Sheet1!C39,abc!A8:A18),M ATCH(Sheet1!D39,percentiles,0))) it gives me this #N/A. I'd rather have it show $0.00. Can someone help ?

First you need to create the DAO database ( similar to access .mdb file ) Don't forget to: - Dim your database and recordsets ( record sets are individual tables within the database ) - VBA Window -> Tools(TAB) -> References -> Checkbox "Microsoft DAO 3.6 Library" - VBA Window -> Tools(TAB) -> References -> Checkbox "Microsoft Access 11.0 Object Library" Code to place in ...

I need a pro!!!!!! Hello, I currently have this code that allows me to print a word document on one of my drives with the click of a button in excel. I need to modify it because one of the files I want to print as well is a pdf file. Does anyone know how to modify it so I can do that? Thanks! Set appWrd = CreateObject("Word....

VBA - Change posting to diff worksheet.. Hi All. nice easy one for the start of the week Please would anyone be able to adjust this code to output the differences in WS3 instead of WS2. I'm having trouble changing the worksheet in the code. Ta in advance. Chuf Code: Sub CompBelowCol() Dim ...

Can you clarify Step 1?

Proper Syntax to delete non-contiguous rows? I am drawing a complete blank. If in a macro I have determined and built a string list of non-contiguous rows that need to be deleted (e.g. rows 3, 5, and 7) from a range of rows named "Prices", what would be the correct syntax? For example, I know it isn't.. Code: Prices("3...