headings

Hi everyone. I have a scenario where I get a dynamic (rows & columns) table with headings. All headings in the original data only appear once. If for example there are 26 columns (A to Z), I only want 5 of these columns (Say columns with headings Apple,Bike,Cat,Drop,Elephant) from the 26 and...

For the workbook I am creating, I am turning off gridlines & headings. However, the user can easily turn them back on by going to the View tab and clicking the check boxes for those two items (I'm using Excel 2016). Is there a way to make it so they CANNOT turn them back on?

Hi, I have spreadsheet that want to copy another sheet and the date field has formula to copy date from above cell(s) the code copy sheet want to copy sheet with the headings and values to sheet1 but i having this issues 1. is not copy the headings just the records and start in row 2 and row 1...

Hi all, kindly advise me so that to create a VBA code which should “SUM” the headings and rows down in columns “SALARY” & “ACTUAL SALARY”. Therefore, that the above headings have no stably column, but the row “2” is constantly. Below I present the original data and the expected result...

I have a table which has data I need for my spreadsheet. The table has two rows of headings on both X and Y axis. Is there a formula that will allow me to get data from this table?

Hi, Is it possible to create static column or row headings in a table or matrix visual? I'm trying to convert an Excel spreadsheet to Power BI and am missing some of Excel's functionality in Power BI. In my Excel spreadsheet I have all of the column/row headings setup and then reference...

Hi, I have a master file with headings in row 1. In another folder and its sub folders there are multiple excel files and the headings are in different columns instead of rows and their values are in in next column i.e. a heading like "Location" may be in cell B5 then its value will be in next...

Hello, I wonder if there's an easy way for me to move certain text in column B, to go beneath headings in column A... Sometimes the text in column B appears on the same line as the Heading in Column A, sometimes a row down, sometimes there is one line in Column B, sometimes up to twenty and...

Hi, I have a workbook where the column headings have the same name as a worksheet in the workbook. I want to compile the data from those sheets into one master sheet. Is there a way to use those headings as a reference for which worksheet to pull data from? I would be using Column A as the...

I have a table with several broad headings at the top. Each of those headings have 3 sub headings. Is there a formula to access each column as all I can think of are a few if statements? (I don't know a lot about excel)

Hi, I am relatively new to writing Macros but what I want to achieve is within the Excel sheet to search through the data headings, find the corresponding Heading and then select the cell below it. This is the Macro that I have so far. Sub OverdueDate() ' ' OverdueDate Macro '...

Hi all, I have a long vertical list of companies with their addresses, phone numbers, names of directors, etc. ALL of it fits into one column. Let's say, Column B. My ultimate goal is to make a mail merge. BUT I am spending an extraordinary amount of time transposing EACH company's info...

How can I format my post to show my excel example properly? I need to show column and row headings along with grid-lines. Thanks. /twg

Good evening. I created a post in the forum chandoo to ask if it was possible, after transforming files with different extensions in Excel, to find tables (which may have similar headers, different or mixed) present in the ciscun files containing in a folder (the files will be many for this...

I'm trying to get data from a web page and keep getting the message from the web page 'the browser your using is not supported any more, update your browser'. I'm using Excel 2016 and IE 11, which surely must be as up to date as you can get. Subsequently the headings download but the data tables...

This is driving me nuts. Today every time a go to print a sheet excel has somehow selected 'row and column headings' and deselected 'Gridlines' on every spreadsheet I open today. I tried rebooting the machine still does it. I can select 'gridlines' and deselect 'row and column headings' then...

Hi guys - grateful for any assistance you can give. I have done this before via VBA but can't recall exactly how. I have a worksheet with various headings, as below. I want to have data filters available on some headings, but not others. For instance: Columns A, C, D & F, but not visible on...

Hi, I have one workbook with two tabs - 'raw' & 'final'. I want to copy all rows from 'raw' onto 'final' - but only for selected columns. Also, the column headings in 'raw' aren't identical to the column headings in 'final' but can be mapped as they won't change, month to month. In essence...

I thought this would be fairly simple, but I am struggling. I have 12 monthly worksheets with various headings such as Total, Purchases, Motor etc. Beneath those headings are daily entries and these are totalled at the bottom. All I want to do is copy the totals from each month to a new sheet...

Having issues with this macro ... It's copying the headings which is great, but I need it to automatically copy as much data is on each tab, and then move to the next tab. Any tips? Thanks! Sub CombineAllTabs() Dim J As Integer Dim s As Worksheet On Error Resume Next...