column header

  1. F

    VBA - With each table on Activesheet

    Hi I am trying to set something up in VBA where it would cycle through each table on the Activesheet and if the 3rd column header says "Start Date" then add 7 for each element on the 3rd column of that table. How would this be written in VBA?
  2. M

    Filldown when don't know Column reference other than by Header Name in VBA Macros; Excel 2013, Windows 10

    Good day all, I posted a much wider subject here: https://www.mrexcel.com/forum/excel-questions/1075442-referencing-columns-based-header-names-vba-macros-excel-2013-windows-10-a.html but am not getting much responses so I decided to break it down a bit with a few edits I've been working with...
  3. Z

    Return column header of first cell identified in consecutive cells that meet criteria

    Hello, I would like to be able to get the column header of the first cell from an identified event of consecutive cells that fall below a threshold. Example data is below (column headers on 2nd row). I can identify the longest consecutive event, when more than one cell has data that falls...
  4. S

    Copying Data From One Sheet to Another Based on Column Headers

    Hi Everyone, This will be my first post. I've researched this problem for hours and I can't find a solution. I have two worksheets in the same workbook. Worksheet_A - has 20 columns and Worksheet_B - has about 50 columns. I need a macro, or preferably a index/match formula, to copy the data...
  5. G

    VLOOKUP to return column header based on column index value

    Here's a fun one! I have a gantt chart production schedule (Table 1) I use to show my team the schedule. Supply Chain also uses this tool to do material planning but it is a LONG process since they have to manually look at the gantt chart to see when jobs start or end. What I'm trying to do...
  6. A

    VBA finding column header and autofill contents by creating dynamic range

    End Sub Hi all, I'm trying to write a macro where i need to find the column header 'dec-26' in row 4 and extend the date till 'dec-31', i.e. add another 60 months and autofill the newly created cells so that the contents/formulas remain intact. I wrote a small part of macro using 'record...
  7. I

    searching for header

    Hi, I'm trying to find the column from the header and using the result, to format the entire column. below is what i've writen. Dim lnRow As Long lnRow = Worksheets("ADSS").Cells("1:1").Find(What:="Party", LookIn:=xlValues, LookAt:=xlWhole, MatchCase:=False, SearchFormat:=False)...
  8. J

    Copy data from one worksheet to another by matching column headers

    I am using the code below, which works beautifully to insert the new column headings I need. Now, I am trying to come up with a way to look at the "N" columns inserted between column B and (former) column C as a result of the code (below)... and if this column heading also appears in row 13 of...
  9. J

    Map column headings with different spelling/naming then find/copy column from one sheet to another

    Hello, I am in a bit of a strange predicament, where the column headings on my system A generated report do not match the column headings that I NEED on my import sheet for system B. Also, the system A generated report has additional columns that I don't need. I have two worksheets... "2 -...
  10. I

    Need to return column header when a value is found in a table in different worksheets.

    I work for a B2B tech company. I have a database of business contacts with their company names, phone numbers and other contact information (Sheet 1). I have separate files which has details about companies and what each is looking to purchase technology-wise. I want to merge these files into...
  11. B

    Return column header of active cell.

    Can someone help me with a code that returns the column header only of an active cell to a message box. For example, if my active cell was AD21, I would want the msgbox to return the "AD" only.
  12. 4

    Return header for column value is found in

    Have found solutions when it is known what row a value is one but what I am looking for is searching 4+ columns in a table to determine the header of the column in which the value resides. Example(s): 9 = "Guest Circuit ID", 7 = "Primary Circuit ID", 2 = "Backup Circuit ID" Ultimately this...
  13. S

    Pulling Multiple Column Headers

    <colgroup><col><col><col><col><col><col></colgroup><tbody> <tbody> A B C D E F ID Name Plan Design Build Test 1 Apple LATE LATE 2 Orange LATE COMPLETE 3 Banana LATE 4 Pear LATE COMPLETE 5 Strawberry LATE </tbody> I am working with the table above and am trying...
  14. C

    Finding Header and Row name based on Value

    I have a table of 1000 students (names in Column A) and roughly 100 courses (in Row 1) and a list of IDs for the students unique to their respective course. I am given an ID for a student and I need to access the students name and the respective course. For instance, I may receive H19 and I...
  15. JimJohnson

    Why do different files have different sized column & row headings?

    Man, do I ever feel like a failure. I have a bunch of files in which I size the total width and height of the worksheet to fit into PowerPoint slide without requiring any resizing. However, some of the files that I work with have differently formatted column & row headings which means the width...
  16. E

    Locating important Columns VBA

    Hi, I have two work sheets. The first one (varEoD) contains the data set and the second one varYTD will only be a select 6 columns that I have defined. I want to transfer all rows in varEoD to varYTD that correspond with the 6 column headers. I am getting the "Run Time Error 91: Object...
  17. M

    Macro needed to copy data from master sheet to other worksheets (but maintains formulas)

    Hi, I have a macro that currently sends all my data from a master spreadsheet to individual worksheets. It uses a column header to determine what data goes to what worksheets. The only issue I have is that this formula doesn't maintain formulas, it pastes values instead. Does anyone have a...
  18. R

    What function can i use for column labels with Part common title e.g. Plan in (Plan Q1, for Plan Q2, Plan Q3 and Plan Q4)?

    What function or formula can i use for column labels with Part common title e.g. Plan in (Plan Q1, for Plan Q2, Plan Q3 and Plan Q4)?
  19. S

    Paste formula in a particular column

    Hi Readers, My problem arises from the fact that I run macros on a report where the columns keep changing places. I need a macro which can Locate a particular column called PACE 1 Insert a formula from the first row under the PACE 1 column The formula needs to be such that If there is a...
  20. S

    Changing filter on multiple pivot tables

    On a particular worksheet within the workbook I have a bunch of pivot tables (excel 2007). The column header is "Wk Ending". This is the item that I need to filter. I used the code i show below. When I update the "Wk Ending" field all of the other pivot tables completely lose the filter. They...

Some videos you may like

This Week's Hot Topics

Top