Recent content by SP

Hello Sir, I have the file avilable in https://www.dropbox.com/s/erkv25hb5ykbymt/PERSO_fmb8.XLS I use this file to consolidate different workbooks. it work fine. i see that my master file will have all the desired sheets but will also contine empty work sheets namely sheet1 sheet2 and...

Thanks for all your help... Now I know how important it is to know macro :-( I am trying it. I have a macro which has been created by my friends. When I try running this it gives me lots of errors and I don’t know how to fix this . This macro dose the same task as consolidating the data from...

Hello, Can anyone help me on my issues? I have to consolidate different work book in to one. Each work book has one sheet and each sheet should get copied to one workbook. Maximum number of sheet is 3. I do it every hour can you please let me know if I can get a macro to do this task...

Thanks a ton... i GOT IT WORKED!!! Regards, SP

Hi Dave, I used if iserror formula and insted of blank my formula will be giving an #na value whereever the data is unavilable eg =IF(ISERROR(G86/G81),"#N/A",(G86/G81)) But I am not getting the result what I need. My Graph is plotting zero :-(

Thanks for the responce Dave and Faseeh, Dave, I used =na() it works.. But I already have a formula in the cell how to use this with my formula? The data will not be manually input every month it gets refresh on monthly basis so I have to keep the formula.. Can you help me in this? Thanks...

Hello, I am working on Excel Graphs, I need a graph to show three years data 2011, 2012 and 2013. For the past 2 years (2011 and 2012) I have data available for all the months but for the current year I get the data end of every month. Now I want my graph to take (plot) the data only for the...