header

Hi, The following code does exactly what I need it to do when the relevant Cells change, however I need it to represent a Table. Table Name and Table Headers are commented in the Code. Any help greatly appreciated. Private Sub Worksheet_Change(ByVal Target As Range) ' Table Name =...

Hello, I need to count 1's "count 1 as one" if the find under same header in various columns In the example given below there are 3 sets of 6 columns (with the same headers) I want to counts 1's (but if the are under same header count must be "as 1 count" For example... in the 2nd set...

Hi, Thanks in advance since i am pretty new to Excel VBA. I have a excel file and contains multiple tabs with the same header. Each tab contains some data(The # of rows can vary). The data in each tab contains some formula. What i want to do is to merge all the data from each tab together...

I may be too stupid to live. I would simply like to make an XY Scatter chart - where the X-Axis Data is in column C (header in C1), and the Y-Axis data is in column B (header in B1), and I'd like to label the points with the text in column A. I keep futzing with it, and I either get it...

Hi there, I have created a simple macro to look to copy some data from one sheet to another however I have just noticed that the source data can actually fluctuate as to where it may be so my cell reference of going to AL9 and copy the data in AL9-AL500 is not ideal. The header in AL9 (or...

I am trying to search for a value >2 in a row, and return the column header of the cell which meets that criteria. Currently I have INDEX/MATCH/MAX to return the header, but I am having trouble making it conditional (>2). Below I have illustrated the desired result. What formula can I put in...

Hi all, I've done some searching and found a code that works reasonable well for what I need, but I do need a little help to edit it. The below code looks in two different tabs within the same spreadsheet and finds and discrepancies, then copies the rows over to a 3rd tab, pasting them 1 under...

Hi all, I'm no expert at VBA, so I've hit a brick wall with this. Here is my code below. The problem I have is when I try to update the fields in the userform, line 25 of buttUpdate_Click causes an "object required" error and I just can't get my head round it Private Sub UserForm_Click()...

I'm building a tool to accommodate various reports where the the header row could be in row 1, 2, 3 etc. This tool will be used by a number of different employees. I need a creative way (using VBA) to determine what row the header is in. Management has asked me to prevent the macro from...

Hi there I have some imput data sheets that will be filtered by country. Using what's filtered, I need to populate that info into other sheets. At the moment, I am using VBA to populate one column, then within that sheet, I am just doing vlookups but I wonder if there is a better way to do...

Hi I have huge database with 3 rows header and I need to transpose it to columns for me to be able to create a header and detail tables

Hello Sir, I am trying to create a macro to copy and paste data from one Sheet to another sheet when Header and Column A data is matching and want to paste into the specific cell. below code is working fine for me when Row(headers) order is the same in both sheets. but I need a solution for...

Hi,</SPAN></SPAN> Data column is column C:E</SPAN></SPAN> Header H2:I4 values are brought by formula and J2:J4 values are consonants </SPAN></SPAN> Header-1 H2:J2 = Pattern XX1</SPAN></SPAN> Header-2 H3:J3 = Pattern XXX</SPAN></SPAN> Header-3 H4:J4 = Pattern XX2</SPAN></SPAN> I want that...

Hi,</SPAN></SPAN> Data column is column C</SPAN></SPAN> Header F2:H3 values are brought by formula and F4:H4 values are consonants </SPAN></SPAN> Header-1 F2:F4 = Pattern 2X1</SPAN></SPAN> Header-2 G2:G4 = Pattern 2XX</SPAN></SPAN> Header-3 H2:H4 = Pattern 2X2</SPAN></SPAN> I want that...

I already have column header row (that is ediable) in a particular spreadsheet. But when I import data from Access into to the spreadsheet, say starting at row three, I get the access table header row that is uneditable and unremovable. Right click on the access table header row gives a greyed...

Hi Everyone. Having an issue with my vba below. Our developers every now and then (as per normal) update our system (crystal reports) by adding or deleting extra columns, I export these reports to a CSV Excel file then run my macro on the csv to delete and manipulate the columns and data...

Hi everybody I have found this VBA and I want it to remove rows on sheet1 when its not found on sheet2. However, I have 1-row-header in sheet2 and 2-row-header in sheet1. I get the code only to work when both sheets have 1 row header. Can anybody of you please help me adjust the code? Sub...

Hi, I'm having a problem with an INDEX/MATCH lookup with the reference field off of a table header - for background, I want to sum a column of the table using =SUM(INDEX(Table2[[2001]:[2018]],,MATCH(F518,Table2[[#Headers],[2001]:[2018]],0))) - however the table header does not match the...

Hello! How can I find the right column by its header and use this to other formulas? I am thinking to use index match to find the right header by INDEX/MATCH. But how to I convert the above result into the column code i.e. A:A? Thanks!

Hi there, so I have the following code. it works great, if there are 3 rows or more. But if there are only 2 rows, the script copies down from B1, instead of essentially doing nothing. I do not want the header to overwrite B1. Is there an easy fix? I tried offset, but I don't think that works in...