heading

Hi, Short version: Someone knows about a VBA way to structure data under indented parent-tree when parent name is on same row in columns to the left? (Se bottom example) Long version: This is my first post here so please let me know if I'm writing this wrong. (Tried to read rules and search...

Hello everybody, I am having a situation where I have heading of certain names or items and it is spread across 3-5 cells (merged as one) and underneath these cells there is subheading (each item occupying single independent cell). I just want a custom function that can LOOKUP the heading and...

Hi - can someone assist my row headings are displaying as values instead of text - what am I missing??? Thanks ~ E

Hi All, I have a s/w from which I export some data into an excel file. The exported excel file is very RAW and I needed help to clean it and beutify it so that it is presentable. Of the things I wanted to automate via macros are- 1. Insert a new row on top for creating column titles so that...

Hi, I'm looking for a formula that will take the cells used as a heading and place them cell into columns with the corresponding rows under the heading. I'm thinking that the formula will have an offset that counts the blank cells in column A then place the text from the heading cells (by...

I'm trying to figure out a way to average directions given in compass degrees- where 0 is north, 90 is east, 180 is south, 270 is west and 360 is back to north. It is easy until I get two compass readings that are north east and north west-- for example, an average of 350 degrees and 10...

Hi, I want to place this forumla "=IF(INT(B3/$U$1)=(B3/$U$1),1,0)" across my worksheet. Now, I'm okay when dragging down as it works fine with the B3 changing to B4 and the U1 staying as U1. However, I would like it so that when I drag it horizontally, the U1 becomes V1. I want it so that...

I have hundreds of rows with name in column A, I want to print each name on a separate sheet as heading and nothing else on that page. So I will have over hundred pages with name on the top and rest blank. Thanks Sohail

Hi, I have been able to create pivot tables dynamically one after the another and I am also able to provide the gaps of 5 rows between the pivot tables. What I need is to insert a Heading for each of the pivot table. For creating a pivot table, I use the following code. The "PivotTable1"...