headers

I'm searching for a macro that would go through headers (A1, B1, C1 ... P1), search for a text ("AAA" and "BBB") and then assign a variable to the column that contains the text (Set columnA=ColumnContaningTextAAAinHeaders and columnB=ColumnContaningTextBBBinHeaders) I'm guessing I would first...

I'm trying to clear contents of a range of cells, A2-C100 but excluding headers (so technically A2-A100, B2-B100 and C2-C100). How can I do this without specifying range for every column? So far I had this: Range("A2:A100").ClearContents Range("B2:B100").ClearContents...

Dear all, I have been laboring with this problem for quite a few days now, I am putting together a list of the 7 highest values, their row headers and their column headers. Using Table 1 below, rows A to F and columns H to M, I have found the 6 largest values using the =Large function, see...

I made this code below, and I am asking if anyone knows how to fix it, when I press on the command button an error shows up? I want to populate the list view with the table headers. Private Sub CommandButton1_Click() With ListView1Headers .View = lvwReport .CheckBoxes = True...

Hi guys, I think I'm nearly there but can't seem to get it to do what I want. I am trying to find the first instance of a date or date format in column headers, from left to right. Here's the code I have managed so far, but it doesn't do as I need. Sub InsertG1Dates() Dim tbl As String...

Help!! Why is this happening? It seems to be intermittent so not sure why. Sometimes it works and sometimes it doesn't. It obviously slows my productivity right down. Pasting Text into Headers from outside the Table or even copying existing headers into new columns will not work. It was...

Hi I downloaded this file (please see below) from the internet. The author is asking this question. "Make a pivot table showing each segments revenue and expenses. Make sure to use both row headers and column headers. Have "Sum of Member Months" be the left most column." I understood the...

Hi everyone, Is there any VBA code that allows me to make use of a userform and it will populate a new excel file with the headers selected? It will look and work like the picture above, where the different check boxes are linked to the different columns (headers) and user get to choose...

Does anyone know how to force Excel to group data together by headers in the X Axis? It did it automatically with this first graph (barriers by ladder group) after I merged some headers together over a secondary set of headers. Table format of first graph: <tbody> Null A-B C-E 2016 2017...

Hi there, New to VBA - have tried a few different bits of code but can't find one that achieves what I need. Trying to transfer a 2-axis dataset into stacked columns, removing zero balances. I want to populate adjacent columns with the headers along each axis. Below / linked image is an...

<tbody> I would like to automatically sort names alphabetically (a-z) when a name is typed into a list of cells. There are cells with a header named "Name" (L3 & O3), cells with a header named "ID" (M3 & P3), and cells with a header name "Location" (N3:Q3). As I type the names into the name...

I am using Office 360 (Excel) and I have a csv file with the following headers (and corresponding data): First Name,Last Name,Address,City,State,ZIP,Phone,Home Owner,Source The printing company I am using requires the following headers: Record Id,Salutation,First Name,Middle Name,Last...

hello, You guys were extremely helpful with a previous problem several months ago. I am going to the well once more. I have a few hundred workbooks that need to be combined into a single. They all have exact same 8 sheets names within each workbook. I need to keep the headers off one and...

Hi forum I am trying to populate an array in a loop. However, out of inexperience with arrays, I can't seem to populate my array. Dim SuppressArray As Variant i = 1 For Each c In m_wb.Sheets("Componenten").Range(Cells(cell.Row, "N"), Cells(cell.Row, LCol)) If c.Value <> "" And...

Hi Everyone, Can someone help me out on the below .. 1. I have 3 tables in sheet1 with the headers from A to F column. 2. I need to name a cell name as "Type" if my next cell name contains as "Data" which will appear anywhere from A to K however i need to repeat the same step for Table 2 and...

I have a sheet columns a to i I need a macro to that will read sheet 2 cell a1 in which i will plug truck number example TR-0506 , The macro then needs to go to sheet 1 search cell a1 where it finds the truck and then pull all those rows a to i starting row a3 as a2 will have headers I need a...

How do I get rid of the small navigation arrows in the bottom right of each header field in a table?

As the title states, how can I copy and paste along with any headers and footers from a excel worksheet and paste in another workbook? Without recording a macro and with an unknown footer and/or header placement location. Thank you

Hi, I have a spreadsheet in which I have a 'Data' tab and a 'Report' tab. I drop data from an online system in to the 'Data' tab. I have formulas in the 'Report' tab which looks up headers in the 'Data' tab based on the corresponding headers and returns the value from the cell below. That is...

I have a data table and when I went into it today the column headers are in the grey part where the columns letters are normally. How do I fix this? I have a feeling it has to do with freezing the top row for scrolling but, when I unfreeze it doesn't correct it. Thanks