false

Hi everyone, I have a userform that has 2 textboxes to add data to a worksheet, this all works fine although i would like it to also search a worksheet called "Members" for a matching value entered into my first textbox called "txtMemFirst" if no matching name is found then it needs to show a...

I copy the following from a web page that was 4 column of rows. I pasted it in excel and showed up in one column. 9/26/2019 11:15 BTC 0.03142971 Completed 9/19/2019 12:01 BTC 0.02388444 Completed 9/10/2019 20:46 RVN 2414.582 Completed There are more than 100 of these groups in one column. I...

Below is the code I have now. I need it to be With Sheets("Cash Update Data") .Range("O1").AutoFilter 15, "12" Everything not including "#N/A" .AutoFilter.Range.Offset(1).EntireRow.Copy Sheets("QTD").Range("A2") QTD is in another workbook .AutoFilterMode = False End...

I need some help with the code below. On my "Leases" worksheet I have data in columns A through F. I am filtering on the word "Question" in column F then coping those rows into the first available row on my "Question" work sheet columns A through F. The code works fine provided the word...

I want to get 10, 20, 30 or 40 in F2 as: F2=10 IF B2=0 AND C2=TRUE F2=20 IF B2=0 AND C2=FALSE F2=10 IF B2=1 AND C2=TRUE F2=10 IF B2=1 AND C2= FALSE ELSE F2=0 How to accomplish. Thanks in advance. I am using Excel 2007 Sheet1 <colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col...

I have a code that hides the ribbons on top of my excel sheet and the code looks like this. Private Sub Workbook_Activate() Application.ScreenUpdating = False Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)" Application.DisplayFormulaBar = False Application.DisplayStatusBar = Not...

Hi, honestly i have no idea wich formula to use in excel2010 - to solve this problem. I need to check if deposit 1 is equal with deposit 2. it is easy when there is only one value in both columns (row 1) simple deposit 1 =deposit 2 to give me true or fale value in the check column. However the...

<tbody> IN AM OUT AM IN PM OUT PM Return 1 1 1 1 TRUE 1 1 0 0 TRUE 0 0 1 1 TRUE 1 0 0 1 TRUE 1 0 0 0 FALSE 0 1 0 0 FALSE 0 0 1 0 FALSE 0 0 0 1 FALSE 1 0 1 1 FALSE 1 1 0 1 FALSE 1 1 1 0 FALSE </tbody> how to make the formula with that kind of combination then will...

With ActiveSheet.PivotTables("PivotTable1").PivotFields("Assignment Descriptor" _) .PivotItems("CCR Review").Visible = False .PivotItems("CCR Review ").Visible = False End With There are numerous other fields listed, about 25 in total Question 1: Is there a way to just provide a wild card so...

I wonder if anybody can help, I have put some code together with a great deal of help from Fluff on this site. I have now moved onto the next stage, which I have working but not exactly as I need. I have the code copying and pasting to variable sheet name but I have two problems 1. Its copying...

Hi, I have got a spreadsheet which has our daily figures into. This has been working ok in an older spreadsheet but we need to recreate the spreadsheet in Office 365 due to compatibility issues. I've recreated the spreadsheet in the same format however I'm getting an error when I input this...

Hi folks, I am a bit syuck on the auto-filter syntax. can anyone tell me how to change this so that I am not copying and pasting the whole row, but only copying range "A" to "L" to usdrws and pasting into range "B" to "M", (same rows as below). ws.AutoFilter.Range.Offset(1).EntireRow.Copy...

Dear All! I've encountered a curiousity. A SAP download contains description within cells J to O. Both formulas, isblank and istext return "false". My goal would be to detect empty cells for deletion. All cells are formated manually as text and no value is shown when entering the cell...

I have a sub that prepares a sheet to be printed. Several sheets share this sub, as they all need to have the same Print Area, etc. This sub gets called each time one of the sheets needs to be printed. I've run across a problem that only happens when I'm stepping through my code. Here's the...

Hi! I need to Filter An array of data by a criteria(emails), then the filtered results has to be pasted in other sheet, at a specific row(the row corresponding to each email address), but if there are two or many rows that has to be pasted, excel has to add the additional rows in the sheet. I...

Hi all I'm trying to join SpecialCells(xlConstants) with SpecialCells(xlFormulas) and no matter what I try I can only one or the other to work never both. Sub Done() Dim NR As Long Application.ScreenUpdating = False Application.EnableEvents = False With Sheets("Your Quotation") NR =...

Hi all I'm about to have a genuine emotional breakdown over a spreadsheet I've created for work and I'm really hoping someone can help me work out wth is going on and how to fix issues I'm having please. In short, I work at a training company and have created a spreadsheet with multiple...

Hi Fabulous people! I am looking at removing duplicates if they contain False in a certain cell but only if they are duplicates <tbody> T U V W X Y 26707343702 TRUE TRUE 30 0 26707343702TRUETRUE 26707343702 TRUE FALSE 26707343702TRUEFALSE 26707343702 TRUE FALSE...

The following VBA Code is not allowing for user to copy pivot table from existing workbook to new workbook. Is it possible to edit code to allow this while maintaining the original function of the code? Private Sub Workbook_NewSheet(ByVal Sh As Object) Call DrillDownDefault End Sub...

Hi, I found an macro online that works perfect in splitting the data into multiple sheets based on Column "S". However I only need selected columns to go to the other sheets vs the current all data in Raw file. I only want the following column to be split "A:B" "E" "H" "J" "N:O" "R:T" only...