header

I have 2 images stored on a sheet in my workbook. I need to be able to copy them and put one in the header and one in the footer. Can anyone help me with the vba code please?

Hi, How would we go about a top of column code where in this case its row 4 ? As opposed to multiple codes have just one code. I have row 4 frozen so always seen. I have row 5 hidden so never seen So maybe double click the coloum header cell in question to be taken to the top. So i am in...

Hi, I have a set of data with a merged header cell, laid out like this: ---------------------------Merged header cell----------------------------------- <tbody> Value 1 Value 2 </tbody> I am trying to return Value 2, using the header cell as the lookup value. I've tried using HLOOKUP, but...

Hi, I'm trying to move a dataset into a new set of columns every time a descriptor appears. More specifically, if you look at linked images, I would like to move the corresponding dataset to new columns every time the word "particle" appears. Linked image #1 ...

Hi, I am extracting data from a Microsoft Project file into Excel and need to write a formula to grab some data. It has a header called "Build" and then another header called "System Build". I want all the rows in between those to be labelled "Build". ex. <tbody> A B C D 1 Name Start End...

Hi, Hoping someone could help me with this. I've been trying to find a way to do this and just can't get there. What I have is a combined spreadsheet that prior was multiple workbooks/sheets (don't have the original) and was combined into one very large worksheet. Each segment of the...

Hi, I have 2 worksheets, I need to retrieve the column header data from one worksheet, but I have values in the row data, not text. I need to look up the ID name from my master worksheet and return the header value if of my column of data if the same ID name is in the other worksheet. Lookups...

Trying to write a macro that will add 2 new columns (A & B) to each sheet in the workbook, adding header names & color coding, but need it to stop when it reaches the tab named "Master" Below is the code I have so far, but keep getting a compile error in the 'Start loop' section Sub...

Hi, I'm looking for help in creating a formula that can return column header names if the value in the cell is greater than 0. If Id 1 has a cell values >0, I want tag (header 2) and API (header 3) to be returned on a separate list. Example of data: Pixel(header1) Tag...

Hello all, I am working on a project and I have come to a problem I don't know how to solve, I have a grid of Data, Row Descriptions (Column B), and then My headers in columns "H:AP" and then the corresponding rows in between Range("H9:AP128"). So, I need code or even a formula that will go...

Hi. I'm new to macros/VBA in Excel and have been working through recording some print macros with a good deal of success....until I hit this infuriating roadblock. And it's something that seems like it should be so simple! :confused: As a final step after auto filtering and formatting my...

I need a formula or VBA, which can find corresponding row 0 value in the header C2:K2 and result in the column M</SPAN></SPAN> For an example... </SPAN></SPAN> Of the row 8 cell F8=0 so the value of header C2:K2 F2=4 result in the column M8=4 </SPAN></SPAN> Of the row 9 cell I9=0 so the value...

I have some code that was working and I don't think I have changed anything but now it is giving me the error "Object variable or with block variable not set" This is my code: It is highlighting this line lastRow2 = desWS.Range("A:A").Find("*", searchorder:=xlByRows...

<tbody style="box-sizing: inherit; border: 0px; margin: 0px; padding: 0px; vertical-align: top; -webkit-font-smoothing: antialiased; text-size-adjust: none;"> ETF-A ETF-B ETF-C ETF-D 10 27 11 11 </tbody> I cannot seem to write the formula that would return the column header of the second...

Greetings ~ I have a sheet with records and the rest of the sheet (all the way out to column WXT) has some sort of formating so when I try to get a column count it brings back 16112 columns instead of the 64 with actual data My approach is to simply delete the cells in row 1 which lie...

My report's final item is a chart image which is in the report footer. I don't want the page header and footer displayed here. I thought it would be easy - I set the report properties Page Header and Page Footer to "Not with Rpt Ftr". But although that works for printing (i.e. exporting to PDF)...

Access 365 I have a QBF with a combobox "CboGrouping" that tells the report the tow grouping the user wants. (code from Allen Brown) Now I need to add the correct fields in the Header area... i.e. if case 1, then District Header would be [District] and District Header would be [District]...

HI I am looking for some help, I have an excel with AND formulas from Column to Column AQ through AZ which returns True or False. Now for example IF AQ = FALSE and AR = TRUE " The lookup should come up with header of Column AR since the check is TRUE. If any criteria below is a match or...

Hi I have a 5-sheet Workbook on Sheet 1 there is a table with a Header from "A6:K6" In column D there is text with company departments. I want to copy all Rows with all columns from the table to Sheet 2 inserted from Row"A7: K7" without Header However, the Rows white company department...

Dear all, I currently have problem with the header added to my listbox. It has been activated (listbox property where columnheads of the listbox = true) but I don’t know why the code below Listbox1.rowsource = (“E1”) Where in the cell E1 from an excel sheet its’ written ‘’blabla’’ but the...