indent

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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