column headers

I have a large table of prices. The column headers in the top row have titles with some duplicates which can't be changed. I can't break up the table into more than one. Those column headers in the top row also are used to produce a validation list. But that list first shows up in a spill list...

Hi all. I have a table that is constantly being added to and i am trying to make a userform to search through the data. At present i think the search function working but i cannot get the table headers to become headers in my listbox. As the table is being added to frequently i have a dynamic...

Hi all, So I read some topics on Google to solve this issue, but couldn't got it working. Also I am still quite new with VBA and only know the basics, but eager to learn more about VBA. My case is as follows: We are making exports with around 250 columns of data, some of the columns are...

If you receive a workbook where the document was created with an undesirable default Font/Size, what can be done to change it, other than editing the documents XML? Setting the Font/Size for headers is done under: File\Options\General... When creating new workbooks Make it a nightmare by...

Is there a way I can modify this Index Match formula, or use a different formula, so that I can reference by column/field names instead of clicking on specific column references?: =INDEX(source!E:E,MATCH(A2,source!D:D,0)) Instead of source!E:E I'd like to find "DESCRIPTION" in row1 of the...

I would like to count specific rows in a spreadsheet. For example see below.. Failed XMLs tran_log_id origin_id reference_id result_code last_updated_dttm 11421022 OMS OMS_39794575 25 01:30.7 11421023 OMS OMS_39794575 25 01:47.2 I have repeated data with different...

Hello Everybody Please see below a scaled down version of a report I'm working on. What I want to do is write a formula in columns B and C which will pull through the values in columns G and J (respectively). So, B3 = 0, B4 = 7, B5 = 9, B6 = 15 (and so on for columns C/I). I have written a...

Here's what I'm using... For i = 15 To 17 Rows(ActiveCell.Row).Columns(i).Select If (ActiveCell) >= 1 Then Range((ActiveCell.Column) & 1).Select Next i The bolded piece is where I'm stuck. I'm trying to Get to Cell 1 of the current column Copy what's...

I attempted to write some code to insert a blank row after each change of value in column B. I also change the fill color to grey, add the text "Totals:" to column C and right justify it. I still have one bug. It overwrites the header (column labels) to add the grey bar and totals. Can...

Hi everyone, I was given a data set that listed header fields in a column format. I need to extract the data and make them rows so I can do a data comparison against another data set. Example. Name Jayme date 032315 id 5 state IL I want it to look like Name Date ID...