headers

Hi, I am new to VBA and i have been trying to achieve the following but i am stuck. I have different tables in one worksheet with common headers from which i need to collate the data into a single table with one set of headers, in a different worksheet. Example given below is of the Raw data...

Hello all, I have two tables of data that is the "same" but being pulled from two difference sources. I need a way to combine this data and check for differences. The data is currently all in one workbook (but different sheets) and I would like to keep it that way. One set of data is manually...

Hi All, I am trying to write a formula that uses Column E data, searches the column headers of the data sheet, and counts all "Pass" values in that column. Here is my formula" =COUNTIF(INDEX(Sales_Q1,0,MATCH('Question by Role'!E5,Sales_Q2,0)),”Pass”) Where "Sales_Q1" is the range of the data...

I've been doing this manually; going mad. In the below image the left represents the information I receive and the right shows what the information should look like.https://imgur.com/a/NJpdut2 (This is a small sample) The rules I can tell you is that: 1) Every other column is a header then...

Hi, Can you please helpme with VBA, I have an excel spreadsheet with 2 tabs (data, keyfigure matrix). I extract data daily of another program on to the keyfigurematrix. And I need VBA code to copy this data over to data tab (withoutdeleting / overwriting previous days), matching the...

Hi, I've had a google of how to do this and have gotten stuck :( I would like to use excel to dl and parse data from www.teamgate.com I have already used the api to connect to klipfolio so I just need to get power query to work ! My (edited for security) details are : GET...

I have three workbooks that I am trying to move into one by matching the headers (we’ll refer to the workbooks as WB1, WB2, WB3 and the new as the master sheet). Some information about the existing workbooks and the master sheet. Master sheet is blank, except for the headers. Headers match...

I have three workbooks that I am trying to move into one by matching the headers (we’ll refer to the workbooks as WB1, WB2, WB3 and the new as the master sheet). Some information about the existing workbooks and the master sheet. Master sheet is blank, except for the headers. Headers match...

Hello, I am hoping someone could help teach me how to transfer data by columns from one sheet to another. Essentially, the headers on both sheets will be the same. However, the order of information on sheet 1 is never the same as the set order on sheet 2. I was wondering what is the best way...

Hello, I am hoping someone could help teach me how to transfer data by columns from one sheet to another. Essentially, the headers on both sheets will be the same. However, the order of information on sheet 1 is never the same as the set order on sheet 2. I was wondering what is the best way to...

Here is what I am trying to do. I have 50+ worksheets with identical headers but different row lengths and data. Rows "A4:BA4" are the headers, A5:BA... is all data. I would like to combine all 50 sheets into one worksheet called "Master". #1 , I'd like to bring over the header from the...

Hey guys - So here is what I am trying to do: I have 50+ worksheets with identical headers but different row lengths. Rows "A4:BA4" are the headers, A5:BA... is all data. I would like to combine into one worksheet "Upload tab". #1 , I'd like to bring over the header from the 1st worksheet as...

Hi Everyone, I need a macro that can turn the font on every sheet Black but not the first row as this is the headers. Any Ideas? Thanks Tony

So I have a workbook that has line numbers 1,2,3 at the top and then has the alpha column headers and then the standard row numbers. I can't figure out how to delete the lines 1,2,3 above the column headers. Can someone tell me what they are and how to delete. If I copy and past to a new...

I am starting to develop a tool that will enforce good practices in data loading. I'm new to VBA, so I probably shouldn't be doing this. Having said that, I'm getting an error on this code. Sub Check() Application.EnableEvents = False Dim ColumnHeaderArr(0 To 2) As String...

I'm new to VBA and was hoping someone could help me with a running inventory using a VBA code. I have 3 sheets (ProductList, Purchases, Transfers). What I am trying to do is calculate at CurrentBalance for each individual product (so far 500 products) in the ProductList. When I enter the data in...

Hi, I have imported an excel worksheet manually in MS Access. Table name is ‘Employee Directory’. This table has 13 column headers. How do I write a query which will give list of these 13 headers. Can anyone please help me in this.

All, hoping someone can help. I have a table that needs refresh from other source based on column headers. Basically: "source" sheet will contain new data. there is a number of headers we dont use "target" sheet will have the headers (and data) we want to update looking for a way to: 1/ look...

Hello MrExcel community, I've been looking for a solution of my issue and couldn't find any coherent help. I have two sheets which have specific names. Let's say "sheet 1" and "sheet 2". How can I consolidate the data per VBA in a newly created sheet if sheet 1 and sheet 2 have columns that...

Hi all, I've not used tables yet but I think they will help me to add some new features and functionality to my current workbook. I would like to represent and pull out values in what will be a 'three dimensional' table. Column headers will be 'Assessment Objectives', rows will be 'Strands'...