skip

I can't use the RowSource option to populate a comboBox. I need to only populate it with values based on another column's value. Scenario: ComboBoxRoom should only be populated from values in Worksheets("PrinterDatabase") C2:C200, if the corresponding column on that sheet, H2:H200 value is...

Hello, I have an existing formula that copies the entries in one column to the next column. These columns represent days of the month. What I need is for the formula to skip weekends and holidays. Here is the current formula: =IF(OR(L802="",M802="",COUNTA(L3:L799)=0),"","→") Formula is entered...

<tbody> Hi, All the expert people out there. I am stuck in a problem and have tried lots of option but no success.I have two sheets in one worksheet and I am comparing 2 columns to retrieve the value from one into another. screenshot attached The problem is that the sheet I am retrieving the...

After the last update, excel 365 has been skipping blanks regardless of the checkbox in the paste special dialog. I can't seem to find anyone with this issue on the internet. So, I have resorted to seeking assistance here, in this forum. Additional info: This problem is a huge p.i.t.a. when...

Hi! I am wondering if someone can help me find a macro that will skip another macro based on another cell's value. Currently I have the following macro: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) If Sheets("Sheet1").Range("D15").Value = "" Then...

Hello,need help with something simple but rather complex for me. i have a large list of 3 digit numbers in Column A. ex.(123)..I would like each digit separated in its own column (text to column) i would like these copied in a series of 3 with a space of 2 rows in between each series. Each...

So I have an export table of data, I can't change this, so the formulas in the second sheet all relate to looking up data from the first. I need to somehow get the data from the first table below (on sheet one, without altering it at all) On to the second table below, on sheet 2 (without...

Hi Friends, I have five spreadsheets in which each spreadsheet contains 100 rows of text(instead of text I put a1, a2, a3 row names to easy construct formula but its kind of confusing to me). looking for a formula which can skip every: 1 row in sheet1 2 rows in sheet2 3 rows in sheet3 4 rows...

I have programmed some conditional formatting using VBA, comparing the values of 2 cells in many iterations. The issue is that some of my coworkers do not understand that in order for these numbers to be compared, they must have the same format. Some of them have put words in one of the cells...

Hi all. I'm looking for a formula to skip blank columns starting in row 2 (horizontal list) and transpose only those cells with values into a single column list. Then, I'd like to move down to row 3 and continue to add only cells with values to the bottom of the new vertical list, and so on...

Hi, Relatively new to VBA, but having read up on using On Error GoTo commands I cannot understand how the code is not responding when it encounters an error. The most annoying part is to get to that part of the code it has already correctly been navigated using an On Error statement. I'm sure...

Is there such a formula, that will search a column for a particular word or value - find the first occurance of it, then incorporate the offset formula to return values 3 cells to its left? Then, in another cell, a similar formula to look for the same work/value in the same column, but skip the...

I'm making a budget and i am trying to have a page with expenses for every month and then on a seperate page i want to have the total of each category of expenses (i.e. gas, loans, entertainment, etc.) in the expenses worksheet i have three columns for each month: 1st column: date of purchase...

OK, so this might be a weird question, I'm not sure it is doable through a formula, possibly a macro but I'm curious to see your opinions. So I have a list of users, items and prices, but for some users they didn't buy an item. So on the next sheet I just want a list that goes through what they...

Hello! I want to put in cell I3 the value from cell C1, to I4 the value of C49 and so on. How can I do it? Thanks

Hi. I've researched this question and saw how you can find the min with simpler ranges, but my equation doesn't work with what I've found so far. Can anyone help me? I want to skip the zeroes and blanks. Thanks...

Hi everyone, I need something which sounds complicated and maybe is but hopefully someone will get me. I use two worksheets - Goals and Results. In Results I have two columns with goals scored at home and away. In Goals I got a table for both home and away games in which I want to read and...

Hi. I'm trying to copy data from one sheet to another, but I want it to skip blanks and a row that has data on it. I want C9:C12, C14:C17, C19:C22, C24:C27, and C29:C34 from Sheet1 to be moved to A8:A33 on Sheet 2. Rows 13, 18, 23, and 28 on Sheet1 need to be left out. Thank you in...

Hi everybody I've already posted this in another thread, but to no avail.. My Formula is the following: =IF(E6<2863;DGET('Eingangsprüfung alte Nr.'!$A$2:$C$400;3;R6:R7);DGET(Eingangsprüfung!$A$2:$C$60000;3;R6:R7)) If I use autofill now to complete a table with approx. 3000 entries, it...

Hi all, can someone please help me with this one. I have a macro that loops through all the sheets in my workbook and then executes a certain code. However I do not want certain sheets to be included. How can I alter the code to skip sheets containing the word 'Database'? <code> Sub...