multiple

Hi Please help, I have the code below where I have multiple sheets rows from A:Q and the source is B which is the date what I want from oldest to latest, B1 is the header so it should start from B2. I am gettng an error on the 'Next' Private Sub CommandButton2_Click() Dim wksht As Worksheet...

I’m trying to set up a table where you can have multiple dynamic lists. For example, column 1 has a drop-down list containing the asset group, column 2 would then have a sub-category if there is one otherwise it would remain blank and column 3 would then show the correct assets attributable to...

Hi. I have a spreadsheet that has two rows of data both with multiple columns. One row has 16 columns of data and the one below has 10 columns of data. ABCDEFGHIJKLMNOPQRS 12345678910111213141516 12345678910 Does anyone know the formula to display the data as one row adding the data from...

Hi all Im using the index match feature with multiple criteria to get a returned value, but its slowed the sheet to a crawl. Any other ideas to return the text value? Im not great at VB I should mention its a shared document and I think arrays have issues with it being shared...

I have a column of number values and need to find a give amount which could be a multiple of 1 or more of those numbers. Is this possible in excel?

Hi All, I have a data of all positive and negative values like -400 200 200 -100 100 -500 250 250 300 -150 -150 I have multiple formulas to identify the matching numbers but all i want is modifications I have data in A1:A100 I use the B1...

Hello, I have a spreadsheet with tens of thousands of formulas like the following. I've split it over multiple lines for readability. =IFERROR(IF(K156=0,0, IF($J156<=AC156,AC$2, IF($J156<=AD156,AD$2, IF($J156<=AE156,AE$2, IF($J156<=AF156,AF$2, IF($J156<=AG156,AG$2...

Issue: Multiple duplicate values in excel cell. I have multi column data A to AA. In some cells I have multiple duplicate values in each cell (contains numbers and alphabets and special characters) separated by comma. How to remove multiple duplicates and keep only the unique values in each...

Good day, I am new to the VBA code for excell. I am trying to automate a process for my small business. I am trying to create a macro to find multiple values, one of them is "B00ZL31582". All i came with so far is: Cells.Find(What:="B00ZL31582", After:=ActiveCell, LookIn:=xlValues, _...

Hi everyone, I have an excel problem that I am stuck on, appreciate any help! Goal: To identify the total sum of each company in a specific stage based on a Date criteria. For example: <colgroup><col span="4"></colgroup><tbody> Client Action Date Stage Amount Company A 1/1/2019 1 $100...

How can I filter multiple columns by color?

Hi all, So I am writing a code to select multiple columns. Here is what my code would look like: Columns("B:B")... Columns ("E:E")... Columns ("H:H")... Is there an easier way of selecting all of those with only one "Columns"? The ... is there just for the example. Thanks in advance.

I have a large worksheet used for creating daily reports on a monthly basis. I am trying to create a macro that will clear the data entries in order to create a blank worksheet that can be used as a template. The workbook contains a lot of pages but the ones that are currently giving me a...

Hello there, Can we create pivot table from multiple sheets? I have 5 sheets in a workbook and their column orders are identical. I need to create one pivot table using all 5 sheets as source data. I can't combine the 5 sheets into 1 due to the volume of data. Thank you!

I would like to find some function or VBA code to count how many rows contain 3 specific numbers in columns B: to G: i.e how many rows contain 1 & 2 & 7 <tbody> A B C D E F G 1 David 1 4 7 8 9 10 2 Andrew 1 2 4 5 7 9 3 Steve 2 3 4 6 8 10 4 Bob 3 5 6 7 9 10 5 Harry 1 4 6 7 8 9 6...

Hi, I'm in the process of trying to consolidate multiple sheets into one. Sub Consolidate_Data() ' Copy Data onto one sheet Sheets("Data1").Select Range("A3").Select Range(Selection, Selection.End(xlDown)).Select Range("A3:S" & Range("A" & Rows.Count)).Select...

Hello Everyone, wondering if someone might be able to help me out with a formula I am having trouble with. I have researched the formula extensively on-line and can't seem to get it to work. Basically, I am trying to use a sumifs formula with multiple criteria that sums across multiple...

Looking to get the average of a single cell over multiple worksheets, but I need it to always go to the last worksheet as I will be adding more sheets. =AVERAGE(Sheet1:????!A1) Thanks

Hello, Quick question. I am looking to do a multiple IF AND statement including LEFT. The below formula gives me a #VALUE error so I know I am doing it incorrectly: =IF(AND(C2="Blue",(LEFT(D2,1)="C"),"250",""),IF(AND(C2="Blue",LEFT(D2,1)="B"),250,"")) C2 has to be Blue AND D2 has to start...

Hi Everyone, i have a code which create workbook into the specific folder. however i want to create multiple folder by the date name: for example code is ActiveWorkbook.SaveCopyAs "D:\TEMP\XXXX.XLS" so i want, this XXXX file name should depend on A1. where we would have date. so i can...