Hi!
I am working on project for a company that owns a bunch of other companies. Every month, they populate an excel file w/ about 50 tables with data from hyperion. They then manually sort each of these tables, and in order to compare how each company is doing against the average - they draw a line to separate those that are above the average, and those that are below. Next to the line, they add a "+" and "-" to indicate above/below w/ a merged cell that links to the total average for that month.
I know this probably isn't clear, I've added a picture, link below.
http://i41.tinypic.com/eqvzpd.png
http://tinypic.com/view.php?pic=eqvzpd&s=5
So...I am not a VBA expert. I was able to create a macro that sorts the tables and also adds a border to separate values above & those below average (by inserting the Y/N column). But I can't figure out how to add the +/-, or how to add a merged cell that lines up to the border. This can also be a text box instead of a merged cell - I know how to create the text box that links to the cell containing the total - but I don't know how to position this in the correct location.
This is done every month and someone spends quite a lot of time sorting & drawing lines, etc. in 50 tables - so any help would be very much appreciated!
Thanks!
Alice
I am working on project for a company that owns a bunch of other companies. Every month, they populate an excel file w/ about 50 tables with data from hyperion. They then manually sort each of these tables, and in order to compare how each company is doing against the average - they draw a line to separate those that are above the average, and those that are below. Next to the line, they add a "+" and "-" to indicate above/below w/ a merged cell that links to the total average for that month.
I know this probably isn't clear, I've added a picture, link below.
http://i41.tinypic.com/eqvzpd.png
http://tinypic.com/view.php?pic=eqvzpd&s=5
So...I am not a VBA expert. I was able to create a macro that sorts the tables and also adds a border to separate values above & those below average (by inserting the Y/N column). But I can't figure out how to add the +/-, or how to add a merged cell that lines up to the border. This can also be a text box instead of a merged cell - I know how to create the text box that links to the cell containing the total - but I don't know how to position this in the correct location.
This is done every month and someone spends quite a lot of time sorting & drawing lines, etc. in 50 tables - so any help would be very much appreciated!
Thanks!
Alice
