outline

Hi everybody I am working on a sheet for scoring KPI's in which I need to have a three-level outline numbering: Themes, sub-themes, and indicators. The format should be "1", "1.1", "1.1.1". I need to be able to use the data for pivot tables, so each row should include name and number of theme...

Hi Excel Masters :-) I have done some research on line and it seems that there is a bug in excel as there is no simple way to use the group function by default when the sheet is protected (even if you tick the option outline in the pop up window). My question is : What is the workaround? I...

now I want to get the on OLD sheet how many OutLines and His ReferenceAddress what is Level of Outline why ??? I want... want copy OLD Sheet to NEW Sheet by vba other thing / method... almost got but... can get information of OutLines... OutLines are... someone made, I want get not eyes...

Dear All, I am trying to create a formula whereby a number is adjusted to a fixed amount of characters using leading zeros. Wait - it doesn't stop there.. The problem I am encountering is that these numbers are in an outline style - 1.1, 1.1.1, 1.1.1.1 and so on. I need a formula which...

I'm trying to format my data series in a chart, and each point is outlined with a black or grey, and the points are filled with the color I specified. Where can I specify no stroke/outline, or change its color? I've searched and can't find this darned [hopefully EASY] answer! Thanks so much...

Hi All, I have a sheet named "fruit-sheet" in the attached excel, i have 4 outlines (1 to 4) in it. i need a macro code which does the below: 1) it should get the values which can be seen when outline is 1 (in this case fruits & veg can be seen.) & these values should be seen in sheet "DSR"...

Hello! There is a budget worksheet that has several outlines: Level 3: Has values/numbers for the details Level 2: Has formulas/(sub)totals for level 3 items Level 1: Has formulas/Totals for Level 2 items My boss wants me to create a macro that will "copy" the worksheet but: 1. Will...

Hi there. I have a Workbook with two sheets. One has a bunch of cashflows [Worksheets("I_Deal")] while the other sheet [Worksheets("II_Summary")] is linked to the "I_Deal" worksheet and has summary information and graphs on those cashflows. "I_Deal" sheet has rows that were grouped. There are...

I have created 8 tables, arranged vertically, in a spreadsheet (2 years, 4 quarters for each year). In the first table I have created a series of manual groupings via the outline functionality. Can I "cut and paste" or somehow recreate those exact same manual groupings in the other 7 tables...

Hi, I'm trying to enable outlining in VBA so I can group rows together, but also have the sheet protected so functions are proctected from deletion. The kicker is that the sheet also needs to be a "shared workbook", which inhibits protecting the sheet. I have the code below that works until...

I have a large spreadsheet that is organized as an outline with the outline level listed in the first column. I would like to implement the Excel outline feature using the outline levels listed in the first column. To clarify, the first column looks like this: Level 1 2 2 3 3 3 2 3 4...

I am making an outline of a lot of notes to refer to in the future. I want a table of contents with links to other parts of the document. (Using Interior Links) The parts of the document will be changing often. So my situation is: Cell A1 links to cell D5. Then when I drag the D5 date to...

Hey All, so I am sending some text from excel to a word document. I would like to create an Outline list for this information with two levels: 1) a. I know how to create a regular list, but I have no idea how to tell word to execute the second list level! This is the code I have right...

Is there a way to import the outline levels into Excel? My challenge is that I am attempting to import MS Project information into Excel. I export the Outline Level (1, 2, 3, etc) with my other fields from Project. I know how to use the Outline Level to add spaces and create the right visual...

I have data that I would like to group/ outline then sort. The data consists of a varying number of rows and the same number of columns. They are recipes for mixtures. I want to be able to sort the grouped information by recipe number but excel does not allow. How can this be accomplished?

Hi guys I've seen several users ask similar questions to this on the forum, but I can't find a solution that suits my purposes. So I'm hoping someone can help me out here.... I have designed a sheet within Excel 2003 for a company that other users need access to, but that I need to restrict...

this is a formula to add data for mos NOV through APR =VLOOKUP(B7,NOVTERM!$1:$65536,4,0)+VLOOKUP(B7,DECTERM!$1:$65536,4,0)+VLOOKUP(B7,JANTERM!$1:$65536,4,0)+VLOOKUP(B7,FEBTERM!$1:$65536,6,0)+VLOOKUP(B7,MARTERM!$1:$65536,6,0)+VLOOKUP(B7,APRTERM!$1:$65536,6,0) I get data if all 6 months are...

(How) Can you auto outline pivot tables? I'm using Excel 2003. I want to send the information to non-excel experts and need them to be able easily to view it at different levels. I know that to auto outline you really need a formula at the bottom of some rows of data. Pivot tables don't have...

After doing some searches (and coming up empty) I figured I'd check and see if anyone has suggestions on some code to dynamically create an outline in one column that reflects the indentation level of the second column. <script language="JavaScript"...