header

Hi all, I've got a document I'm using as a template with several sections. Page 1 is a title page with the: Document Title Published Date Updated Date Those three items are all bookmarks. Those three items are also included in the header of each page. When I'm ready to finalise the file...

Hello I am trying to create the exams taken column with a very large file. What would I need to use to create something like column b (EXAMS TAKEN) where it returns the coulmn header by student who took a given exam? Student No. EXAMS TAKEN ART EXAM PE EXAM FREE LUNCH? MATH EXAM SPECIAL ED...

Hello currently I'm trying to export data from a workbook without open it by using macro, to explore the limits of VBA I'm trying to check if some specific headers are present on the sheet. Exemple code : Sub Checking() Dim Cell_Date As Range Set Cell_Date =...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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)

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