include

I have a table of data where the user will select data at the body of it ... . then a UI will showup and will include the selected columns headers and allows user to swap headers sequence order then proceed to paste into new sheet with the new order For Each rng In Application.Selection.Columns...

My current formula works within its own sheet. I'd like to modify it to include all the sheets in the workbook. Current: =SUMIF(I:I,M2,H:H) Sheet names are: Citi 2009, LL Bean 2009, Mileage Plus United 2009 Thanks Doug

Hello I am having difficulty with the Get Save FileName below. It carried out the code until the very end. I have difficulties Saving the file. Also, if I want the dialog box to open with a dafault folder, how do I include the syntax within the code below. Thank you Dim Ret...

short of combining all worksheets on one.. I'm assuming there is a way to include multiple ranges for the reference data. they're all formatted the same. thanks kindly for any help

Hi, Keep on getting error "you tried to execute a query that does not include the specified expression" My SQL looks as follows: UPDATE TblField LEFT JOIN TblTempStats ON TblField.DomainCatID = TblTempStats.DomainCatID SET TblTempStats.EmptyFields = Sum(IIf([fieldname] Is Null,1,0)); Any...

Hello, I have a VBA change event that inserts a v-lookup as follows: cell.Value = "=VLOOKUP(""C""&(TEXT(RC[-1],""0"")),'Summary by Project- exBR'!R4C3:R200C4,2,FALSE)" I need the formula to be modified to include an iferror function (or something similar), so that if the value is #NA , it...

Good morning. I am expecting the answer to this question to be no based my current knowledge but someone her may have better advise. I want to do an concatenate with an if. something that looks at a2 to see if the font is "strike thorough" and if it is then don't include in the concatenate...

I am not totally certain these are the formulas I need to be using, but I have a list of entries of days (which most days used numerous times), and sales per day. How can I get these totaled? A problem I have encountered is when I have used a SUMIF and include 11, it totals anything with those...

A monthly workbook contains a worksheet for each day with a section that contains a differing number of rows each day. I have an array formula which finds the first blank row in a range:- {=MIN(IF(R7:R50="",ROW(R7:R50)))} and wish to include it as part of several other formulas on same sheet...

This line of code (below) is NOT working as a normal IF statement. If I include the "End If" line I get an error message. I also get an error if I try to use a line starting with "else". I need the functionality of a regular IF statement so I can apply code for those situations where my cell...

Hi, I have a worksheet with 20 columns, the below code copies my data in the first 10 columns. However, I would like to skip columns 11-15 but include columns 16-20 in my range copy; what would be the best way to do this? With Workbooks(rFile).Worksheets("Master List").Range("A1")...

Hello, need help and struggling with a multiple If statement on a vlookup =IF(VLOOKUP(A7,'Stock Planning - All Orders on MOM By Line Not Shipped.csv'!$C:$F,4,0)="BO","No","Yes") I want to also include if the vale in the lookup is PB as well as BO, How do i do this?

Hi All, In column D I have a person's name along with their unique ID so for example the format would be in "Bloggs, Joe (12345678)", what I want is in column E to include the unique ID for each person without the brackets (), is there a quick and easy way to do this? Thanks

I have a tab in a workbook which contains Recoveries. In that tab, Column B may contain values such as "March 2016" or "April 2016" etc..." I am working in my tab called "June 2016 and I only want to include the values from the Recoveries tab if the values Match. Is there a way to do...

I feel like my request should be simple. Here is what my macro does: 1. Copies range from 'Job Type vLookup' tab 2. Opens files from folder listed in A2 3. Adds new tab to opened workbook 4. Paste the information 5. Rename new tab: Job Type vLookup' 6. Save and Close Workbook 7. Loop for each...

Hello!What I have:At the moment the inserted filter that I can put on a column has a list of things in the column, and by choosing an option I can filter for that *exact* option.What I want:I have a column of cells that contain various words. Examples: "tree", "tree fish", "tree apple smile"...

Hi, I'd like to define a range and include only the entries that have a certain code in the cell next to them. So my data looks like this: A B C D E 4 x 3 y 2 x 1 y 5 x So I need to define a range in vba and have the range be equal to the collection of cells in column A that have an "x"...