indent

  1. R

    Auto-indent based on the value of another column?

    Hey all, I have a CSV sitemap that I'm formatting and one of the requests is to indent the Page Name column "X" amount of times based on the value of another column. The other column contains the "Level", which is simply a number between 1 and 6, and based on that is the number of indents the...
  2. M

    Indent level in a scaled sheet

    I am working on a vba excel sheet that requires scaling the page at 25%, for this, I used a font size 24. Now, when I tried to do Range("B2").IndentLevel = 1, it is so perfect in the excel sheet, But when printing the sheet to pdf, I found a lot of wasted space. Is there any way to control the...
  3. P

    Indent text

    I have a spreadsheet where text in column D may repeat several times. The repetitions will always be grouped together. I need to look at the entries in column D and when they repeat I want to indent them five spaces. So the first occurrence of a text value will be left justified with no...
  4. J

    VBA subtotal depending on indent

    Hi, I have a table with text and numbers that i got from MSProject, for example: <tbody> <colgroup><col span="2"></colgroup><tbody> A 36 A.1 10 A.2 12 A.3 14 B 61 B.1 38 B.1.1 15 B.1.2 11 B.1.3 12 B.2 11 B.3 12 </tbody> </tbody> My goal is to run a...
  5. J

    Sum values based on indent

    Hi, I want to sum values based on indent level in another column. Example: <tbody> text A 0 9 A.1 2 2 A.2 4 4 A.3 5 5 B 0 3 B.1 1 1 B.2 2 2 C 0 5 C.1 3 3 C.2 2 2 </tbody> I have my different strings in column A:A And in column B:B i have...
  6. M

    VBA: Indenting cells in one column based off data in another column.

    So I have a list of values in a column with named "Rank". This has values of integers going from 1 to 10. In a different column called "Name" I want to indent the data in each cell according to the value in column "Rank." So if Rank = 1, no indent is needed. If Rank = 2, one indent (5...
  7. E

    Why CHAR(9) does not display a gap/tab?

    Why CHAR(9) does not display a gap/tab? I want to indent the text in some cells, how can I do that? Thanks!
  8. M

    Transpose variable data from a single column into multiple columns based on indent level

    Hello helpful excel folk! I have been given a data export to cross reference that looks like it was created as some kind of pivot and the only data structures are the cell indents in the first column. I have already used a small VBA script to populate the indent level of the cell data and now...
  9. gheyman

    Indent VBA Code debug error

    Run0time error 1004 : Unable to set Indentlevel property of the range class Someone kindly gave me this code and I am trying to use it in a new spreadsheet. it does indent the rows but them it debugs with the message above. Anyone know why? Sub Indent() ' Dim Ind As Range ' 'this is...
  10. B

    Unique Number Formula Required

    Good morning all Here is what I am after, I need a formula to create a unique number for each item on a list of engine parts Below is what i currently undertake manually and consists of typing in each level and then concatenating the levels at the end of the process. This can be in excess of 10k...
  11. B

    Create a unique number list

    Ok so here is what I am after if anyone can help I need to create a unique number from an item list, I am given indent numbers on the list for parent/child relationships top level is level zero which is 001, next level with an indent of 1 will be 001001, next level with an indent of 2 will be...
  12. B

    Creating a unique number from a list of items

    Ok so here is what I am after if anyone can help I need to create a unique number from an item list, I am given indent numbers on the list for parent/child relationships top level is level zero which is 001, next level with an indent of 1 will be 001001, next level with an indent of 2 will be...
  13. gheyman

    Auto Indent (format) the text based on a number in the cell next to it

    I have a column "C" that has numbers in it (numbers between 0 and 15) The column starts at row 7 I want to go down row C and for every row that has a value I want to "Increase Indent" the text in Column B and D the number of time that equals the value In column C of that row. So in Row 7 if...
  14. P

    Why the Hanging Indent always sticks with the first tab in the Main Line?

    Why the Hanging Indent always sticks with the first tab in the Main Line? You know... When you press ctrl+T the above tab (mostly ":" character) moves with the hanging indent. Why the word has been built in this way? Example: Residence Address : No...
  15. C

    SHowing Parent-Child Relationship using VBA

    Hi there! I am fairly new to VBA in Excel and was hoping for some guidance on this problem. I am given hierarchical data from a database to perform a report, and the user would like to format the information such that an entry's children lie directly below it (a parent can have multiple...
  16. C

    Representing Hierarchical Data in Excel

    Hi there! I am fairly new to VBA in Excel and was hoping for some guidance on this problem. I am given hierarchical data from a database to perform a report, and the user would like to format the information such that an entry's children lie directly below it (a parent can have multiple...
  17. C

    Finding Header and Row name based on Value

    I have a table of 1000 students (names in Column A) and roughly 100 courses (in Row 1) and a list of IDs for the students unique to their respective course. I am given an ID for a student and I need to access the students name and the respective course. For instance, I may receive H19 and I...
  18. N

    Multiple indent levels in a single cell

    Hi there, I'm looking to create multiple levels of indent in a single Excel cell, as a way of displaying hierarchy of information. Here's the situation: I'm currently preparing a list of files and am using an Excel spreadsheet to keep track of each file. Each line in my spreadsheet is a...

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