headers

Hi. Can anyone please quickly provide an alternative formula to create a dynamic named range which will use the index function as opposed to offset or indirect. Sorry, can't get my head round this one. I have : =OFFSET(Demographics!$C$2,0,0,COUNTA(Demographics!$H:$H)-1,29) This captures all...

I have a workbook, which I want to create a macro button to populate headers on certain worksheets in the workbook. I have a macro button created in another workbook which works perfect. I figured I could copy and paste the code of the macro into this new workbook and edit it as I see fit...

I have a spreadsheet with more than 600 columns. Unfortunately several of the headers are identical. I would like to rename these headers so that they become unique. Lets say that part of the headers looks like this: <tbody> a b c d d d d e f f f f </tbody> I would...

I'm trying to import some text from a CSV file, but I don't want to include the headers, which the CSV file contains. I've been told on a previous thread I posted that there's a "start import at row" option where you can select the topmost row to import. That thread seems to have died a few days...

I use Excel 2019 and I'm trying to import some data from text/CSV, but the data I'm importing has headers, and I don't want them. Is there a way I can remove the headers and their formatting from the text before importing? I don't want to just delete the row with the headers after I import the text.

Hi, I have a table in Power Query that mostly contains numeric data. Therefore, I want to align the column headers to the right so they are right-aligned with the numbers. This way, when I refresh the query, and Excel populates the table on the worksheet, the column headers will align with...

I have been studying some of the code snippets posted to the forums. I have a very broad question to ask, so forgive me if I ramble. I am trying to understand how VBA works with Windows Controls, Messages, etc. I don't have anything specific in mind that I'm trying to do, but I want to learn it...

Hi everyone, I am having issues with a pivot table merging 2 column headers and count of values together when I filter out Blanks. I've created an example workbook of the source data, what I'm doing (which is definitely wrong), and an example of what I want it to look like...

hi, after filtering...i want to count the number of rows used from after the headers...the headers fill in the top 6 rows and the data is row 7 and below (from columns A to N)....essentially i just want vba to tell me how many rows are used today after doing some sort of filtering and excluding...

I have headers in row 1 on sheet "Data Import" I have written code to delete a specific Col Header, but need it to delete several Col Headers for eg Physical address, Remarks, branch ID etc Sub DeleteSpecifcColumn() Set MR = Range("A1:z1") For Each cell In MR If cell.Value =...

Hi, I'm in the process of writing some VBA to match and extract data from one worksheet to another. Originally I was going down the path of VLOOKUP but have since read about Index & Match being the better way to go. I've attached a sample of the data here, any suggestions on the best way to...

Hi For the last hour or so I have been trying to find an answer through youtube but just can't it. Really appreciate if some one can help me with this, I just created a table from randon figures which represent the actual table at work, so the modules are products and the dis module colum is...

This is probably very simple, but I can't think of the right solution at present. Spreadsheet On a seperate Sheet, i need to add a formula that will look across row 1 for xDate, then row 2 to find Header Title then find row related to Totals in Column A and result with the answer to that...

Hi, I have headers in row 1, with data underneath. For every change in column A, I want the data (plus the headers) copied and pasted into a new tab. I then want that tab to be named the same as the data then in cell A2 of the new tabs. So, if there are 7 rows with "Bananas", I want those 7...

Hi guys, I have an excel file with first sheet having large quantity of data, say around 200,000 rows of data. I'm able to save the sheet data to a text file, but due to the amount of data i'm unable to upload this text file into server. Is there any VBA macro to split this sheet data into two...

I have a dynamic Drop-down being populated by the Headers from Range("G1:AZ1") when a button is clicked, there could be any number of headers in this range If there are No headers in this range i.e. all cells are empty then I need to clear the drop-down of the values it has. But I am having...

Hi, I have been trying to work through some VBA code that can solve the following problem: Copy column data from multiple sheets and consolidate into one sheet "DOH_Master"; Column locations change month-to-month in the sheets where I need to extract data from, I have setup "DOH_Master" with...

Hallo gurus I can now insert a new column with its own header into a row of headers (thanks to help on this forum). The new column (for which I will add a header) will be inserted to the left of an existing column with header. My problem how do I ensure that a header cell is selected and not...

Hi all! I am trying to copy values in cells from one worksheet to another after filtering. My problem is that the code below is copying the headers when a cell is blank. I would like it to just keep the cell blank instead in the worksheet where the data is being pasted. Please see my code...

Hi I have sheet1 with approx 60 columns with unique headers in row 1. I want to copy some of these columns into a new sheet based on a list in sheet2, column A. So if there are 3 rows in that list, it will copy & paste 3 columns into the new sheet being columns A,B & C. My knowledge of using...