columns

Hi everyone, I have an excel workbook with many tabs/worksheets. Each worksheet is in pretty much the same format. The thing im trying to do will work much easier by an automated VBA macro. Something that a little beyond me but I'm getting there. What I want to do manulally is this: In my...

I have looked in google and not found the answer to this question. 2 actually First is it possible to edit which fields appear in the data entry stock form. I do not want all of the columns to show up in it. I have formulas in some of them that will calculate based upon the what data is...

Hi everyone. I have a number spreadsheet with 20 columns /100 rows of numbers. I need to get the sum of the highest 4 CONSECUTIVE numbers of each columns. I have found two formula to get the sum: =SUMPRODUCT(MAX(D3:D95+D4:D96+D5:D97+D6:D98)) or =MAX(INDEX(D3:D95+D4:D96+D5:D97+D6:D98,0))...

Columns("F:XFD").Select Selection.Clear Hello All, The code above is working to clear all the cells. However, I would like to use another way instead of just referring to Column XFD to find the very end column. Is there another way to select all columns from "F:to the end" and instead of...

Hi I need to use a filter on my pivot table. (Placing the field into the folder box) I only want this to apply to one of my columns - is this possible? Jess

Hi - I have a problem with power query not updating all data from my source file. My query was created from file / from folder, and I currently only have a single file in that folder at the minute. I have imported that data into power query with no issues currently, however if I change some...

Hi, really hoping for some help please. I have a excel timesheet which details hours worked against different pay elements. For example , columns would be ... Ee no., name, no.of hrs, hourly rate, total pay. Header above theses columns would be PE Basic pay( 88). Following to the right , the...

Hi all. I'm trying to find the correct excel VBA code to count the number of columns in a named range, from the start of the range up to and including the current active cell location and return that value to a specific cell. Example: "mynamedrange" is columns AA thru AZ and the current active...

Hi All, I am looking for some help on VBA to Select Range and Move based on conditions. I would like to move all the contents between "Project A" and "Project B" one column to the right. Same with all contents between Project B and end of table which will also move 1 column to the right. This...

How can I write a formula that will sum the value from multiple columns using an index match matrix based approach? The formula below will work when there is only one column that has the "OC_TECH" value, but I want to sum both values if "OC_TECH" occurs as a column header more than once. for...

I found a thread that was extremely helpful in copying entire rows when the value in a specified column > 0. However, I only want the values in columns A,B,C,D,G,S instead of the entire row. The code I modified from Fluff's answer looks like: Sub WeeklyReport() Dim rng As Range Dim cell As...

I need a XIRR function that would only compute the XIRR for specific ISINs. This is a picture of a sample file with unnecessary info deleted: <tbody> ISIN DATE OF INVESTMENT DATE OF SALE BUY VOLUME SELL VOLUME US7475251036 18.11. 2015 2421 -385,86 US3546131018 3.12. 2015...

Greeting - is it possible to just lock columns A, B & C from being edited, but still allow rows to be added or deleted? I using Excel 2016. Many thanks in advance for any assistance.

Hi Team, I want to sum Non Contiguous Columns range. Is it possible sum Below formula in a Single formula. Need help in R1C1 styles sum. Range("A6").FormulaR1C1 = "=sum(R[-4]C[0]:R[-1]C[0])" Range("C6").FormulaR1C1 = "=sum(R[-4]C[0]:R[-1]C[0])" Range("E6").FormulaR1C1 =...

Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> Here the below is my example I need formula for conditional format to highlight result in 3 different forms highlight 2 match, 3 match or 4, for example if I put in the cell C3=1 & in the D3=2 it should highlight in the column C6:D44 all 2...

Good day. I am running Excel out of Office 365 on Windows 10 Home. I have a workbook that contains seven worksheets. Each of the worksheets has a group of Macros that allow the user to sort the data of each worksheet by different columns. The worksheets contain up to 200 rows with 125...

I everyone! i have a problem, I want to create a single column from the combination of 2 others from diferent tables... these columns have a null value or a numerical value, like this: COLUMN_TABLE1--COLUMN_TABLE2 ----- WANTED COLUMN_FROM_ANY_TABLE...

I am trying to Autosize Row height based on Visible cells only and not the Hidden columns. I have columns that has very long text that I will be hiding and then I am left with extra white space in other cells and extra long worksheet. I tried formatting the Autofit cells Row height but, it...

Hello, I am trying to use Index:Match to find a value in several different columns then return the result of a column once I find a match. Here is the sample formula I am trying...

Hi All, I have a column with INDEX/MATCH formula, but the match value could come from 1 of 3 possible columns. Could you help me combine the below into one formula please? =IFERROR(INDEX(admin!$C$4:$C$100,MATCH(C4,admin!$B$4:$B$100,0)),"0")...