hi narayan - thanks for the help - i have used the iferror index thing in the past - i've been trying to do VBA to extent my horizons so to speak - but this would work for general purposes for this type of issue!
And to help you out with the stated purpose - i have 3 analyst who will do these position exposures every month - and there are many different excelwork books for position exposures for different funds. This master file will help me know which ones have been completed or not for what month...
Hi Narayan - thank you so much for your patience! I started just really tinkering with the actual VBA code as I have not fully laid out concrete plans to the individual workbooks etc. I am up for any ideas on how to make this easier to solve. almost all workbooks which are like "b" are called...
Yes L2 and M2 have complete in them, however A2-ZZ2 have this formula (=IF('Position Exposure'!CX2="","","Complete"). In the position exposure sheet (first sheet) in row 2 there is formulas which cover a large part of that row essentially saying =IF(SUM(W7:W128)=0,"",W4) and W4=the date.
So...
correct
1st link - called "b" has a tab called position exposure database. There is only two things going on in this worksheet. Dates are in row 1 and either "blank" or "complete is in row 2 corresponding to the date (there is a complete if that month was done and its blank if it still hasn't...
apologies for so many threads - i also revamped the "b" position exposure just to take some info out of it - so this is the link to the "b" excel sheet
https://docs.google.com/open?id=0BwKyVQi8QwbPUjQzamNZbGRTMkMyU1k1T1czakR4dw
For ease of this thread here is the test run excel sheet which...
apologies - i revised the test run excel sheet so its much more basic, the rest of the tabs had no real relevance to what I wanted to do.
here is the link - https://docs.google.com/open?id=0BwKyVQi8QwbPMGVjQ3liUGpUbGFGR0RpSDFRamtCdw
two things which I don't understand, how to create my "find" variable as dynamic (as in I want it to be a range of dates not just 1/1/2012. This range would be found in the master file. Also I don't understand how to make the VBA "loop" or do this code a bunch of times with different dates...
So I am trying to do some code, but i am quite the novice. I have a masterfile which has dates (1/1/2012, 12/1/2011, etc) that correspond with months we do a specific task within these excel files call position exposures. In each 'position exposure' excel workbook I have a work sheet called...
Thank you Fred and Narayan for your responses. The spreadsheet can be found here: http://www.speedyshare.com/files/30750280/chandoo.xlsx
password (not sure its needed): gugiremacexe
Please see the tab titled "one pager".
All the graphs are created from the table in rows 18 - 28. Its used...
I created a 5-series dynamic chart using 5 different offset formulas (one for each series in the graph). The series name / data is retrieve from 5 cells in a table. When I try to only display data for 4 returns , the 5th return is still accounted for in the legend - I'm assuming this is because...
At my work we have an external hard drive which holds also the excel sheets we use. They are on what we call the Z drive. I have this one database which links to over 50 worksheets on the Z drive (this database is also stored on the Z drive) and it works fine for what I need it to do...
guys thanks so much
I ended up doing what radu said but slightly changed I did min(abs(a1-a5) and colored it green and then did max(abs(a1-a5) and colored it red and had the 50 percentile be yellow so that all the numbers grouped closest to zero are green, while the mid way ones are yellow and...
Hi Hui, yes no I know how to do that but here is the problem, The cells I want to heat code i don't want to heat code by their actualy value I want to heat code them by their absolute value
So when I run a correlation analysis and I have -0.06 as a correlation, I'd want to heat code it so that...
thanks for the responses - did any of these modules make it so that one blank row will not be hidden, for the last one I want it to hide all the blank rows except for the first instance
thanks for the responses - did any of these modules make it so that one blank row will not be hidden, for the last one I want it to hide all the blank rows except for the first instance
if an cell A1-A10 you had 10 different correlations and you wanted to conditionally format them so that the ones which has the closest absolute value to 0 are green while the ones gradually farther away from that are red (like a heat sensor) how would you do that....also alternatively....if you...
I have two fold question ...one I want to add to this Module (I am a total newbie at doing this) but basically I wanted to have a macro that does all three of these in one shot (macro).... as of right now they are three separate macros to do the work.
Explanation of Macro - basically each...