headers

I have a fairly complex macro (for me) to program. The Workbook contains the following: The first Worksheet called “Export” contains 53 columns with headers in row 1 with names such as “Apples”, “Bananas”, “Cherry”, etc. The Workbook also contains 53 hidden Worksheets named like the headers in...

Hi everyone, I have a small question for you: Let's say I have a table with headers and I'm trying to calculate an average. I'm using the following macro to calculate it Sub Average() ' ' Average Macro ' ' ActiveCell.FormulaR1C1 = _...

Hi there, I've got a Table (let's call it Table1) with a number of 'spacer' columns in it. Those spacer columns each have the word "spacer" somewhere in their column headers. For example, a header might be "Spacer Column 3" or "SPACER66" and so on. I want to conditionally format all the...

Hello. I have this code already that I found on this site and edited it a little bit to my fit my needs. I have two different workbooks. They each have most of the same headers but the order of them can be changed at random times unfortunately. So I need to copy and paste all the data from my...

Okay, I found this bit of code from a post back in 2010, and I am hoping that somebody can please help me figure out what kind of variable "hb" should be, and what it should be pointing to because the original person that posted this code never included them at all. I know this code was intended...

Hi All, Can someone help me with below requirement. I have two wrokbooks wk1 and wk2 in the same path as my macro workbook. in Wk1 in sheet1 i have my dump from column A to AX. in Wk2 in sheet2 i have headers from column A1 to S1 what i am looking for is to copy respective data for each...

In ponctualy receive a file that I would like to reorganize. I am thus looking for specific headers names and either renaming them and copying data or doing more complex operations. In the simplest case, I am only renaming columns and pasting the new columns headers and content in a second...

Hi Team I got one vba solution on this site given by DanteAmor, if any header missing then I want to add message box for user and exit sub Option Explicit Sub copy_paste_data_based_column_headers() Dim sh1 As Worksheet, sh2 As Worksheet, a() As Variant, b() As Variant Dim i As Long, j...

What do the @ symbols do in excel formulas? The names are table column headers =[@Rate]*([@MinHours]+[@AddHour]) What would happen if the @ symbols were not included?

I'm trying to combine files in PQ that have an extra row above the headers. How would I combine these files by deleting Row1 and promoting Row2 as headers? <tbody> Count 5 ID Action Date 11111 INP 18-Oct 22222 INP 19-Oct 33333 INP 20-Oct 44444 CLOSED 21-Oct 55555 INP 22-Oct...

I import a file each day that contains about 40 columns of data. 15 of the 40 column headers are dates for the next 15 days from the current date. Therefore, each day the column headers change in the source data for those 15 columns. My refresh will crash each day since it cannot find the exact...

I just want to get value from one cell in TotalsRowRange. If I write myTable.TotalsRowRange(9).Select everything works fine. But how I can select that cell in TotalsRowRange by using headers row name? I can select column like next myTable.ListColumns("Stake").DataBodyRange.Select Next does not...

Two tables of data... I have table1 with headers which I need to do a horizontal lookup on to match table2 with the same headers I have a serious of columns of data in table2 which I then need to do a vlookup from - find a specific cell in a specific column, Is it possible to do this using a...

I'm not very good at VBA and am struggling to work out a way to search across the top row column headers and delete the entire column if the following words do not exist in the relevant text description of that column. The columns headers will have different text, but just in case it helps I...

Hello. First time here, I hope I'm posting this in the right area. Please note that while the linked document contains names and addresses, it from a public database and is therefore not a breach of any kind of data protection (United Kingdom's company database from the official government...

Hi Everyone, I need your small help in execute a macro to combine sheet i have three sheet by the name of sheet1, sheet2 and sheet3 all have same headers and data avaiable in A1:C10 i want to combine all three sheets into one. kindly help

I have an excel workbook with 6 worksheets. Each worksheet has a different header. Each week, I want to be able to change 4 of the worksheets footers without changing their headers. When I group the 4 worksheets and change the footer; it changes the headers too. Is there a way to change 4 of...

Hello, I have a workbook in which I would like to have some headers populated by simply filling in some cells with text then hitting a macro button to populate the headers of multiple sheets automatically. The headers already have some text in them which need to remain. i have snip images of...

Trying to create a macro that will add 2 new columns A & B with headers to each sheet in workbook. This code works to add columns for all worksheets, but only puts the headers in the 1st worksheet. Sub Insert_Columns() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets On Error...

Hi can anyone help with a formula? On Sheet1 I have headers in cells "A1:D1" A1 = Ref B1 = A C1 = B D1 = C On Sheet2 I have Data with headers in 3 separate blocks with 7 columns each: "B1:H" "J1:P" "R1:X" "B1:H1" - headers = A "J1:P1" - headers = B "R1:X1" - headers = C On Sheet1 in the...