1. R

    Pass Row 2, Column A Cell to Header After Each Page Break

    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...
  2. B

    VBA code for copy paste data based on column headers.

    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...
  3. T

    Using VBA to combine headers (based on name) and concatenate columns based on conditions

    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...
  4. M

    VBA - Copy specific headers help... check point

    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...
  5. D

    What do the @ symbols do in formulas

    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?
  6. S

    Power Query: Combine Files, delete row1, promote row2 as headers

    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...
  7. L

    Power Query - Dynamic Column Headers - By Date

    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...
  8. D

    VBA table TotalsRowRange cells

    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...
  9. D

    Vlookup and match?

    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...
  10. BradleyS

    Delete Entire column based on word search

    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...
  11. J

    Power Query column alignment

    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...
  12. R

    combine Sheet

    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
  13. C

    Excel Header and Footers

    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...
  14. M

    MACRO button to fill headers

    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...
  15. S

    Adding columns to multiple worksheets

    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...
  16. P

    Formula to Count Cells

    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...
  17. M

    Index Function

    Hi. Can anyone please quickly provide an alternative formula to create a dynamic named range which will use the index function as opposed to offset or indirect. Sorry, can't get my head round this one. I have : =OFFSET(Demographics!$C$2,0,0,COUNTA(Demographics!$H:$H)-1,29) This captures all...
  18. M

    a MACRO to populate headers on worksheets??? Code listed

    I have a workbook, which I want to create a macro button to populate headers on certain worksheets in the workbook. I have a macro button created in another workbook which works perfect. I figured I could copy and paste the code of the macro into this new workbook and edit it as I see fit...
  19. S

    VBA - Renaming identical headers

    I have a spreadsheet with more than 600 columns. Unfortunately several of the headers are identical. I would like to rename these headers so that they become unique. Lets say that part of the headers looks like this: <tbody> a b c d d d d e f f f f </tbody> I would...
  20. P

    Where is the "start import at row" option in Excel 2019?

    I'm trying to import some text from a CSV file, but I don't want to include the headers, which the CSV file contains. I've been told on a previous thread I posted that there's a "start import at row" option where you can select the topmost row to import. That thread seems to have died a few days...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back