headers

  1. P

    Detecting Duplicates by Date?

    I am trying to make a schedule for my ball league and I have it organized like this (there is other info like game time and location as well, but that isn't really relevant to this question): <tbody> Date Away Home May 1 Team 1 Team 2 May 1 Team 3 Team 2 May 1 Team 4 Team 3 May 8 Team...
  2. C

    formula to look up column headers in one table and return values in another table

    Am sure this is very easy but I'm having a complete mental block!! What's the formula to put into the yellow cells to give the results shown - it's looking up the headers in B3:K3, finding the header that matches the one input in N3:W3, and then returning the cell content in the same row. The...
  3. Pinaceous

    VBA Show row & column headers

    Hi All, Is there a code through VBA that can hide all row & column headers, for all sheets of your workbook? Thank you! Pinaceous
  4. W

    How to count headers in Word table of contents

    Hello. Is there away to use a formula in Word to count types of Headers in a Word doc? Thanks!
  5. M

    Dates in Table Headers

    Hello all, Is it possible to have dates automatically update in table headers? I read somewhere else that you cannot formulate a header. I track days on time sheets and hours worked each day. I need to keep the headers in order to do my totals, but get tired of having to change the dates every...
  6. L

    Find column header and copy contents of column to a second sheet within workbook

    Hi, I was wondering if someone could help me with a macro. I have a spreadsheet 'Sheet 1' that has column headers starting on row 8 and information corresponding to the columns for up to 50 rows. The column headers span columns A-Z. I need to find the following headers: "Well", "Sample Name"...
  7. N

    Find Column Header column Number

    Need Formula or VBA In Cell A1 I have the text "Quantity" which I want to find the Column header that matches that value from the headers of Value in cell i A1 is say "Quantity" (The column header value returned for is would be 4 ) Column headers are in row 5 Customer retuuns...
  8. U

    Copy & Replace Header Columns to Another Workbook Header Columns?

    I don't have a lot of experience with VB Scripts or Macros so I hope you can help me. I have two separate workbooks that have different header columns on them. One is an Amazon workbook that has specific header columns in order to import products. The other is my distributor that I have to...
  9. kelly mort

    A count formula needed

    Hello Everyone, I have a challenge here with me: I have headers x y z. They keep repeating at regular intervals; x y z x y z etc. Now I want to count based on each header the number of cells that contain values greater than 0. I tried to use the countif but did not do what I wanted. I am...
  10. U

    Populate combobox from a pivot

    Hy, I have an excel userform with a combobox. I want to fill the combobox with values from a pivot. The pivot contains hundreds of columns with two rows. The first row contains the column headers and some of the second row contains some value. I want to fill the combobox with those column...
  11. C

    Hyperlink value to autofilter data in another worksheet/tab

    I have specific numeric values in column J. From Row 11. in one sheet. The linked data is in another tab called "Equip ID" in the same file. I want to click that particular value in Column J cells in one sheet and once i click it it should take me to tab "Equip ID" search it in column A of...
  12. N

    Using SumIF on Dates Stored as Text in Column Headers

    Using Excel 2016 I have a dataset which has dates in row 1. when the range is converted into a Table, row 1 becomes my table headers and excel treats all column headers as Text regardless of the previous data type. I have the following formula which when the dataset is stored as a range, and...
  13. P

    VBA Question

    Hi I need help in VBA coding I have region wise different excel worksheets and on each sheet in column D there are some comments and in Column E and F I have values against which there are certain headers in column H Now I want to collect all the comments from column D and values from...
  14. S

    Finding the three lowest scores

    So I have, what I think, is a somewhat complicated scenario that I need to solve. I have bits and pieces but can't seem to get it to all come together in to the end result I am seeking. I have a single workbook. Two worksheets. Sheet 1: ItemNames in column A and Locations in column B. There...
  15. M

    Extracting from multiple lines of text in one cell.

    Hi this is my data in one cell contains. I need to take each of these points from this one cell and put it into individual cells under my headers in Excel. Headers in Excel. A1 Provider B1 Service C1 Name D1 Phone E1 Email F1 Address
  16. S

    HELP: Compile Sheets Into ONE Tab

    VBA: Compile 5 out of 10 sheets into 1 Hello! I have made a macro to basically take 5 data sources and order them into new order by headers. Now I have 5 sheets into a workbook of 10 that is set in the same order with same headers. Is there a macro out here that would compile the 5 sheets...
  17. M

    Split Data into Sheets Based on Column Data

    I am having a little bit of trouble trying to split out some data. The macro I built I used some code that I found and altered it a little bit to do what I need it to do. I have 2 columns specifically that I am trying to use as the identifier to split out this data onto different sheets. The...
  18. E

    Search for empty cell then return a specific number of cells before it

    Hi, I'm trying to find an empty cell, then return the cell 1 before it, then the cell 2 before it, then the cell 3 before it, so that my summary page is always showing only the last 13 headers. Any idea on what this formula would be? Thank you in advance!

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
Back
Top