1. 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...
  2. 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...
  3. 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?
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. B

    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...
  9. 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...
  10. 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
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. P

    Import data from text/CSV without headers?

    I use Excel 2019 and I'm trying to import some data from text/CSV, but the data I'm importing has headers, and I don't want them. Is there a way I can remove the headers and their formatting from the text before importing? I don't want to just delete the row with the headers after I import the text.
  20. M

    Can You Align Table Headers In Power Query Table?

    Hi, I have a table in Power Query that mostly contains numeric data. Therefore, I want to align the column headers to the right so they are right-aligned with the numbers. This way, when I refresh the query, and Excel populates the table on the worksheet, the column headers will align with...

Some videos you may like

This Week's Hot Topics