header

  1. J

    WORD: Macro to Cycle Through Headers & Remove Merge Fields / Change Formatting to Black

    Hi, Can anyone help with a macro to Cycle Through Headers & Remove Merge Fields / Change Formatting to Black? Thanks.
  2. I

    Is it possible to change header for all sheets without changing the page orientation?

    Hello! Hopefully you can help me to solve my problem! I have excel workbook with multiple sheets. And the sheet orientation are both - vertical and horizontal. I have faced the problem, changing the header information for all sheets, automatically all sheets change the orientation to Vertical...
  3. G

    Hidden Spaces/Tabs in Cell

    Hi folks, I have a cell in a table that seems to be giving me trouble when I try to import into Power BI from an excel sheet. Here is the issue: Cell E2 (blue A) : Has three entries that appear to be on individual lines, but in the same cell. When I try to take this to Power BI, it only...
  4. U

    What formula can make table headers values capable of being referenced in equations?

    Hello! I have an excel table that I'm building for scheduling / planning purposes. I want to be able to utilize the headers as date values that I can reference for summing assigned hours that are in a column whose header date is greater than the last day of the previous week. The formula I'm...
  5. M

    How to use column header in macro

    Hi everyone, I'm quite new with macros in excel so I'm relying on your expertise. Let's say I have a table with headers and I'm using the count formula in a macro and this is the code: Sub Test() ' ' Test Macro ' ' ActiveCell.FormulaR1C1 = "=COUNT(Sheet1!C)" End Sub The header of the...
  6. T

    VBA Different first page/odd page header/footer

    I'm working on a sheet that spans two pages, and I'm trying to format the page setup in VBA (as the culmination of a number of other operations the macro is executing). Since the result is on only two pages, it doesn't matter to me whether it's odd/even pages or different first page. In my page...
  7. T

    Print color only in Header

    Just wondering if this is possible, I have a lot of colored filled cells in my document that I need to print black and white. I only want my logo that is currently in the header to print in color. Is there a workaround for this? I know I could do a watermark on the finished pdf, but I would...
  8. D

    vba to find a header that repeats

    Hello, using vba i am looking for a way to find a header/multiple headers, the first header is called "Test A" and starts on row A51 and has a range where values are. The next header after that is "Test A-1" and same thing has a range of values, but that one is in column A but the row can be...
  9. R

    Insert Cell Value of Second Row of Column A after each Page Break as the Right Header

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

    Inserting a picture in the header in each sheet based on the sheet name

    Hi, I have around 250 sheets in a workbook all with a unique sheet name. I have 250 unique pictures (custom border templates) that correspond to the sheet name which I would like to insert into the header. How could I do this without manually going into each sheet inserting the picture and...
  11. Jyggalag

    Making a frontpage in Power BI?

    Dear all, I am completely, absolutely 100% new at Power BI. This is my first official day, so please bear with me :) I currently have the following Dashboard: Now, if I insert an image I can get it it to fill all of the screen except for below the dotted line (my red arrow is pointing at...
  12. D

    Header Formatting vba only works with breakpoint or Step Through

    All, Apologies ahead of time for the ugly code. I am a complete novice at this and have used inputs for forums like yourself to kludge together something that appears to work, except that I can't get it to run successfully when I push play. I've seen a lot of posts about only working when...
  13. S

    VBA - Copy Paste value base on the header

    Hello friends and community, I am very new to vba and trying to figure out how to do below. I need to copy a pivot table's data from one workbook to another Copy from the highlighted header (Week number) Paste to the highlighted header in another sheet Difficulty & Concern: 1. the header...
  14. J

    HELP.. Combined table by adding each date to fixed header line on seperate sheet by using VBA

    Hello Brave Excel Lovers and Helpers I have an Excel File in which there are three Nos. Sheets and a Userform (File is attached) RawDatabase ReportTemplate MyReport I can only generate report for single selected row from Userform Listbox1 (see MyReport) But this is not what I need. I then...
  15. O

    Document Header and Footer images placed in exact locations in bulk

    Hi guys, I'm currently changing the logos in bulk for 1000s of documents and know there to be an easier way to do this. I have some template documents which contain the right header and footer placements for each of the images, but I, so far, have not been able to translate this into bulk...
  16. W

    Requirement to show the hostname value / column heading when a cell is changed

    We keep a server list in Excel ready for any dinosaurs still lurking who want to read it. I'd like to show at the top of the spreadsheet (C2, D2, E2) corresponding column column header last modified cell (highlighted would be a nice touch)
  17. W

    VBA help to match column header from different workbooks

    Hi all, I am looking for some VBA code to help me with the problems, it would be great if one can help. I have 2 workbooks, and there are multiple worksheets in each of these workbooks. In workbook2(sheetname1) I would like to find the column in workbook1(sheetname2) that has the corresponding...
  18. T

    Move names into a text box and pushing data back

    Hi Everyone So I need to get some names and make userform inputs so heres what i need, I have 5 Cells with headers and 5 cells which need readings I have userform1 I want to take userform1 and Place the headers from Cells A10,C10,E10,G10,I10 to header boxes Below the header boxes I have Input...
  19. T

    Copy Columns from Origin Sheet Based on Header and Copy to a Different Sheet Under the Same Header

    Hi guys, Just wondering if there's a more clean and condensed solution to this macro I'm working on. I'm trying to map data from a client's payroll file onto our template in order to upload it to our system for record keeping. I need to copy the data (all rows in the column directly below...
  20. D

    Table headers being replaced when copying to it from another table

    I have some vba code that copies rows from a table to another table on another sheet. The headers for columns D, F and G on the destination table keep being replaced with column1, column 2 and column 3, instead of being left the as they are. I can't see where it is doing it in the code. Could...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
Top