heading

  1. R

    Hyperlink formula reference

    I understand how to create a hyperlink to take me to other sheets using the hyperlink formula, but I become stuck with the next part. If I have headings in Row 1, I would like to be able to see which one was selected. For example, if we assume the columns are also the headings (heading A in...
  2. D

    Infiinite If/Then scenarios and a macro

    Hello, I'm working on a complex problem. I have several distinct headings that each have a number of rows in them and each heading/row is replicated across (4) sheets. For example... Heading A row 1 row 2 row 3 Heading B row 1 row 2 row 3 row 4 I'm trying to create a...
  3. Guzzlr

    Fundemental Change in Thinking to Select a Column to Copy and Paste

    Range("C4:C5000").Copy Range("G4:G5000").Select Selection.PasteSpecial Paste:=xlPasteValues Hello All... I use the term Fundamental in the title, because I've always used a Column number to find the column I wanted to work on. In the above code, I use Column C because the heading of C4 is...
  4. P

    Converting Headings to Bookmarks in Word

    Hey all. I'm using Office 2016. I'd like to make a macro that loops through each heading in a document, and then creates a bookmark at the heading's location using the heading text (modified as necessary) as the bookmark name. Most of the headings are in X.X.X.X format, such as "3.3.4.1...
  5. J

    Using command button in macro enabled form to add rows under multiple headings

    Hi! I am looking for help with formulas in my macro enabled form, which will allow the user to add multiple rows to enter free text under 3 headings (if they require more than 1 entry). I want to have an "Add Another" button which the user can click to copy more rows into the form automatically...
  6. F

    Identifying non numerical headers

    Hi there and happy newyears! What I have here is essentially a word document that we'v taken and copy-pasted all the information into excel. We currently use a macro that is identifying all the information and then seperating everything into each column. The one thing that the macro is not...
  7. J

    Copy range based on matching column heading

    Hi all. I'm really struggling to find any code that will work for this scenario, after trying for hours I'm just about ready to give up. As you will see below, I'm a complete newbie when it comes to VBA. I have two workbooks, Entry_Sheet (where I need to paste the data) and Data_Sheet (where...
  8. E

    Excel Simplified Query

    Hi, I have unique IDs in column A of "tab 1" with the same IDs in column A of "tab 2". What I want to do is within Column E of "tab 1," is the following: 1. I want to check the ID in column A, and then if the value in the heading of "tab 1" called "topic" = "Ice Cream Van [1]" and if heading...
  9. E

    Returning Cells Based on Values

    I have two tabs namely "Working" and "Source" but I need to do the following: 1. In the "Working" tab I have a list of unique IDs in column A, I want to match these with Column A of the Source tab which also contains IDs. 2. Once the corresponding ID has been found in the "Source" tab I want...
  10. V

    Sort Userform ListBox

    Dear All, My Data has 4 columns with the following headings: Heading 1,Heading 2,Heading 3 and Heading 4. I have created a Listbox using the below code. In the user from i have 2 Option Buttons which indicates 2 columns. I want to sort my list box based on the selection. Example: if the...
  11. I

    Duplicate heading rows problem

    I have merged 50 excel files in one file. Problem is that, there are 50 heading rows in my new created file. How I delete all heading rows except first.
  12. E

    Hiding colums

    Hi, I have a spreadsheet that has columns with headings (F-AA), I want to hide all the columns where the heading doesn't match whats in cell D28. Easy way of doing this please?
  13. G

    Lookup With Conditions

    Hi, I need to extract data from a range of data based on 3 criteria. I've used SUMPRODUCT rather than an array formula with INDEX and MATCH: =SUMPRODUCT((Column A = Product Code)*(Row 2 = Date)*(Row 3 = "Adjusted Sales")*(values to extract)) The problem is that there is a second column...
  14. S

    Automatically copy over a range of cells if I type the heading of the column

    Hi guys, I am working on an excel sheet for a professor and I really need help. I have 75 columns in excel and each has a different heading which consists of three digits. The headings are all in row 32 of the sheet. All 75 columns have 30 rows of data which have a number in each cell. I am...
  15. H

    Unable to delete Paragraphs in Word Docs Processed from Excel

    Hi and thank you in advance for considering my question. I need to use VBA in Excel to resolve the following issue: We have word documents that are generated from a training development application. The documents generate titles with Heading 3 and Heading 4 styles that are duplicated in the...
  16. E

    Tidying an Excel Table

    Hi All, I have a standard Excel table with heading across row 10 and all corresponding information under this. My problem however is that I am now required to input information relating to each of the heading above it. At the moment this is looking a little untidy as some columns only have one...
  17. RobbieC

    breaking down sheet data into blocks (vba)...

    Hi there, I have a worksheet which contains imported data. The data is essentially in 18 blocks of differing widths and heights, but essentially have the same 4 categories: GROUP, HEADING, UNIT & TYPE After these headings follow the DATA. So column A looks a bit like: GROUP HEADING UNIT TYPE...
  18. M

    Conditional formatting with Icon Sets

    i am trying to compare two rows of numbers and use conditional formatting with either a tick or a cross if the two values are the same or not. for instance in cell a1 the heading would be predicted cell b1 the heading would be actual cell a2 would have 2 cell b2 would have...
  19. M

    Calculation of latitude and longitude

    Hi, I need to calculate latitude and longitude for given speed and heading. First value of latitude and longitude is provide rest of the values need to be calculated for given other parameters such as speed and heading d1=speeds(1)*stept1; d2=speeds(2)*stept2...
  20. P

    Finding TOC reference Style in Word from Excel

    I have an Excel file that will process multiple Word files looking for comments. What I need Excel to do when it finds a comment is to search in reverse from the comment location to the first use of the style "Heading n" (could be Heading 1, Heading 2, Heading 3, etc...). When it finds this...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top