header

Hello, I am trying to count cells if they are not blank without including extra rows or columns to do so. I know how to represent if a cell is not blank but I do not know how to count them. Example: In the grid below A1 has my header and A2-A5 has a 1 or it doesnt. B1 has my header and B2-B5...

Hello I have hundreds of separate excel workbooks saved in a single folder. Each workbook has the same set of 28 variables with the same header row titles and contains monthly data on the cost of drugs. I want to run a loop to merge these workbooks into one. There are two main issues (1) the...

Is it possible to count number of instances of duplicate and unique cells found from a varied range using a list of data from another sheet as a reference to on what to look for? My data will be varied with up to 20,000 rows and up to 10 columns Also the cells will contain both numbers and...

Hi I am trying to retrieve the text that is in the center header At the start of the program I ask the user for a sheet title sheetTitle = InputBox("Please input title for sheet", "Title") which I later use in the print setup With ActiveSheet.PageSetup .CenterHeader =...

Good Day Ma'am/Sir. May I ask for help. I cant find a way to display my Header Name in my worksheet in to my listbox un userform, even though i set to true the value of columnhead properties, it only displays cell values. I just want to also appear the header names in the listbox. Here is...

Good Morning, Ive tidied up all my table etc in the Name Manager but stuck on one. All my table are 1 column. So examples of my tables. Header Sold Name manager i see under refers to =Table22[SOLD] Range AK2:AK66 Header Bought Name manager i see under refers to =Table9[BOUGHT] Range T2:T100...

I'm trying to get the macro to look for "Mary Lee" in header (row 1) and puts in the word "LOAN" below it. It should go all the way down to match the number of rows in column A. The name "Mary Lee" may appear multiple times in the header. Data will change daily, so the number of rows in...

Hi! Could someone help me tweak this macro? I want the macro to find specific texts in the header and (the text will appear multiple times) and delete everything in that column but don't delete the header. For example, I want the macro to look for "Mary Lee" and "Bob Smith" in the header and...

I add a image as a header and I have white gridlines appearing throughout the image. If I add the image just as an image, it is fine but if added through the insert header, it has the lines through it. How do I get rid of them?

Hi All, I need to get data in a table to then list using the clumn header then the cell, per row. <tbody> Header1 Header 2 Header 3 Header 4 FU Bar Hello World End Of Days Cheese </tbody> using the table above as an example to display the below Header1 "FU" Header2 "Bar" Header3 "Hello"...

I am trying to copy all of the rows in a sheet that meet 2 different criteria. Including the header row. If A2="X" and B2="Y" then copy entire row including the header row

Please help me to find a vba code to multiply two column data using its header names (column will vary each time) Eg: Two columns with header name "Unit Price" and "Quantity". The sum should be multiplication of these two columns. regards Varghese Mathew

I currently have a macro that loops through all each column on a sheet. Within that loop it will find the value of the column header and row header. It then will find that column header value in a table on a different sheet. The next point of the macro should look for the original row header...

In Row/Column B5:b16 I have months, Apr, May, June, July, August...... etc What I need is when my VBA Code is run, for whatever row I am in (say row D) , I want it to look at the correct column header for that month (so today is June) and then place a timestamp Many thanks

hi, I have a worksheet where I need to delete data in column A by selecting Ctl+spacebar buttons in keyboard and delete button to clear entire data EXCEPT header in cell "A1".. how can I do that.. please help:warning:

Hi I have a table where the headers are weeks. I want the user to update the first column header and the subsequent headers would update by each week. e.g. Column A is 10-Jun and formula in column b onwards is A1+7 etc <tbody> 10-Jun 17-Jun 24-Jun 01-Jul 08-Jul 15-Jul </tbody>...

is it possible to use this layout (they are tables, I couldn't get it to paste that way) and have excel look at all the tables and return the header and amount under the header of that table only if it is greater than zero? The tables are on one tab and the results/totals are on a different tab...

Hello, I've searched the forum and thoroughly as I can and haven't found a solution to my issue. Apologies if I missed something. I'm building a project resourcing sheet for my company. I would like to be able for users to enter in the number of weeks in the project into a cell and have t add a...

The title pretty much says what I'm looking for, I need to breakout a sheet of 15,000+ rows into individual sheets of 150 data rows + header row from sheet 1. I just don't know enough coding to be able to make this happen. Appreciate the help, thanks.

So I have this sheet that automatically seperates the data byt column D value then uses that value to create a formatted "Header" for each group and places the name from D into the newly created header. My question is is it possible to add the sum of G in the header as well? Heres my code Sub...