heading

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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.

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?

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...

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...

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...

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...

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...

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...

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...

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...