header row

Hello! I have an excel table that I'm building for scheduling / planning purposes. I want to be able to utilize the headers as date values that I can reference for summing assigned hours that are in a column whose header date is greater than the last day of the previous week. The formula I'm...

Hi folks, I have a few co-users of a worksheet that uses FILTER and SEQUENCE, but as they are on older versions of Excel they lose these results. The worksheet has something similar to below where, For a given array (B2:E13) of values Return a dynamic list of Column and Row "Header" Values...

I have a header row where I want to alternate the shading of every 3 columns within a specific range of columns. For example, A1, B1, C1 Shaded D1, E1, F1 Not Shaded G1, H1, I1 Shaded J1, K1, L1 Not Shaded M1, N1, O1 Shaded Is there a way to do this WITHOUT having to enter each cell for...

Using COUNTA to exclude blanks – having issues I have a spreadsheet that has 101 rows of data (First row contains column headings) Column B is a text field. There are four blank cells, so the correct count is 96. =COUNTA(B2:B101) returns 96 =COUNTA(B:B) returns 98 =COUNTA(RGIndex!Authors)...

Hi there, I already have VBA code that will recursively trawl through a directory. I am currently using this to identify if any columns in any of the worksheets in any of the Excel workbooks within that directory contain email addresses and, if so, those columns are then deleted. Here's the...

Dear Community, I am very new to excel and in urgent need of your help because I have a huge set of Data to analyze. I have a file with a lot of worksheets (>50) that have all their content arranged in the same way. However, they are named differently (not Sheet1, Sheet2 but e.g. P1_F, P2_F...

Could someone point me to a post that previously address this (can't locate) or assist me with the following: I'm trying to return the row header for the lowest value in the set. Using the table below what i'd like to display where the XX is would be "Changed" and "Dated". I'm struggling with...

Good morning - I'm a relative novice with coding for Excel. I know just enough to be dangerous, so please bear with me. I'm using the following code to enable dates to be entered into certain columns using just 6 digits and it will automatically format it as a date with the slash characters...

folks, not quite sure how to present this properly. so bear with with me: 1. i have userform, and would like to do a calc inside the userform, referencing a cell in the xls 2. the cell is in the same row as the 'active cell', but it is in a different column and also, 3. since the xls is in...

I have a large report with about 300 districts on it. Each week, this report is burst out to the field, with each district getting only their stores. I do not do the burst (don't know how, to be honest), so I didn't realize this was happening When the file is burst out to the field, the...

I need to insert a Header row to existing text file (VBA Code). Here is my code; Sub header() 'the final string to print in the text file Dim strData As String 'each line in the original text file Dim strLine As String Dim time_date As String strData = "" time_date = Format(Date...

good afternoon. I am trying to create a macro that will take the contents of an excel file that had new user details and save it as a csv. The Headers are in column B - B11:B44 with the data in D11:D44. Being the information is running vertically rather than horizontally I am having issues in...

Hi, I am working with VBA and automating a spreadsheet that we do. We import and SSRS report into Excel, then perform certain tasks on it. However for one of the lines, it is giving the following error: Microsoft Excel Cannot determine which row in your list or selection contains column...

Folks: PART I: How come I can't get my autofilter code to work for more than 2 criteria? I keep getting "Criteria doesn't exist" but why should that matter if I'm using "Or"? If you have solution to only PART I or PART II, please respond. PART II : Do you have a better idea for deleting...

They just updated me at work to Office 2007. I'm having an issue with the sort function of excel 2007. This didn't happen in my old 2003 version. I import a set of data with a header row. I add nother row above the header row to add more data (file date, etc.). I then freeze the panes at A3...

Hello All, I would like a macro that copies the current region but doesn't include the header row. Thanks

I have a large excel worksheet with many groups in it. Each group begins with an identical header row. Currently, I just split up each group with page breaks. I need to make a macro which splits each group into a separate worksheet tab each time it finds the header. Here is the header: HSE...

Hi, is there a way to force a Header row on a sort in VBA xlGuess is the default, are there any other options? I can't seem to get the header row to stay no matter how i select the cells before sorting. Thanks Intersect(Range("A:H"), ActiveSheet.UsedRange).Select Selection.Sort...

I have a worksheet that contains information in 5 Columns (B:F), I would like to conditionally format the header row to highlight the cell by which the data is currently being filtered (e.g., if the data is filtered by the header row of ColumnB, I would like the header cell in ColumnB to be...