true;

Hi, in the code below I am trying to reference the column number within setColumnFilterCriteria from the named range AttendeeStatus so that this piece works no matter where this column is. Any ideas on how to do so? function FilterAttendees() { var spreadsheet = SpreadsheetApp.getActive()...

Hello, I'm looking for formula that look at value in A3 and if that value is a whole number OR equal to value in A1 OR equal to value in A2, TRUE; otherwise FALSE. Thanks!

heyy please help i have a table with 4 columns. the first column is the name and the other, info than belongs to the firs column . i have try to make a macro for this but its not possible becouse the name dosnt appear in the same row. exp: Itay (my name) appear sometimes in row 3/6/7/12, but...

Hi there. <tbody> GRADE / LEVEL / XXHRS / FF/RU HRS / - XX / X / 4 / - / - RU / X / - / 4 / - </tbody> I have 3 columns. column "GRADE" is a "DATA VALIDATION" containing inputs XX,RU,FF. I wish to tab or enter over the cell that needs no input (-) when the certain input in...

Hi Guys, Please help. I am trying to count the number of days the adjustment user worked from a data set with multiple records for any given day. <tbody> ADJUSTMENT USER POSTING DATE KXE KXE KXE KXE KXE KXE KXE KXE KXE KXE KXE 1/01/2018 1/01/2018 3/01/2018 3/01/2018 3/01/2018...

Hi Mr. Excel users, I have a simple problem that needs to be corrected. Here is my code: ~~~~~~~~~~~~~~ For Num = 1 To TotalDuplicatePerCase Rows (1) .Find (What: = "New Value"). Select ActiveCell.Offset (Num, 0) .Select On Error GoTo...

Each day I enter my weight in a cell running across the sheet Sunday - Monday 7 cells D3 - J3. I want to have the 8th cell K3 tell me each day how much I have loss since Sunday D3?

I have quantities in cell D3 thru J3. D3 cell has the count of items at the beginning of the week. Each day the new inventory count is in the next cell. I want to be able to total at the end of each day how many items were sold?

Hi All, i have problem with my excel table. I have table(sheet BA11) with almost 4k row and in this table are subtable repeated every 30-36 row. Every subtable has same layout but not same number of row. I need extract from table 2 value and this is Name and Total. Name alwas start NAME: xxx...

Hi All, i have problem with my excel table. I have table(sheet BA11) with almost 4k row and in this table are subtable repeated every 30-36 row. Every subtable has same layout but not same number of row. I need extract from table 2 value and this is Name and Total. Name alwas start NAME: xxx...

HI, I HAVE DATA INPUTS IN CELLS A1 TO A5. I WANT VALUES IN "INPUT CELL "TO CHANGE BASED ON UNIT SYSTEM (METRIC SYSTEM OR BRITISH SYSTEM) IF SELECTED AT FIRST. it is important to consider that that values in CELL A1 TO A5 ARE "INPUTS" FOR EXAMPLE...

Whether I convert a number to "text" format, or use the apostrophe to indicate a text string that consists of numbers, I can still perform calculations on those strings. Why is that? Even crazier, I changed the number converted to "text" format to a string of letters, and my IF function still...

Hello I’m new to this and hope you may be able to help. I regularly get two columns of figures which I want to import into columns B and C in a worksheet. The goal is to end up with both columns the same. I therefore need to identify the differences between the columns. The problem is that...

Hi there :nya: Need some help. Currently this macro only finds cells containing the exact text entered into the text box Search_OrganName. I would like it to find any cell from the range that contains that text rather than just exact matches. I'm thinking there is a really obvious solution...

I have a TAB called KITTING. This TAB has the totals from 7 other tabs. The TABS are labeled STN, MDF, BACKBONE, CCTV, FIRE, ACCESS-IDS, PATH. Each of these TABs have the top row with PART NUMBER (B3), DESCRIPTION (C3), MANUFACTURER (D3), QUANTITY (E3), UNITS (F3). I would like to also add a...

If I have 5 arrays that have same dimension, can I combine them into one array with 5 subarrays. va = ws1.Range("A2", ws1.Cells(Rows.Count, "A").End(xlUp)).Value vb = ws1.Range("D2", ws1.Cells(Rows.Count, "D").End(xlUp)).Value vc = ws1.Range("F2", ws1.Cells(Rows.Count...

Hello All, Could you please help me with below issue. I have to check each recipient's email ID in the To, CC & BCC and validate if domain falls under @gmail then it should add Confidential in front of subject line to encrypt it, however if its any other domain. it shouldn't add Confidential...

Hi Folks. I trade stocks. I just created a macro in a "template" file called CIA Trade Blotter Template.xlsm to paste value the trade date from a range that contains "today()" and then save the file (downgrading it to xlsx) with a datestamp appended to the filename [i.e. CIA Trade Blotter...

I have a (model portfolio) macro enabled workbook with 3 company-focused sheets and 2 client-focused sheets. When changes are made to the portfolios on sheets 1-3 they flow to the nicely formatted sheets 4 and 5 via cell and name references. Then I ... 1) copy the last 2 sheets into a new...

I am trying to total project amounts that we have "WON" On tab BID STATUS in column "D" I have the salesperson ID "FRE102". In column "F" I have the status "WON, LOST or WAITING" and in column "G" I have the $ value. On the TOTALS tab I have a cell I want to give me each salespersons total is...