$$Excel-Macros$$ Excel Dashboard

2015-08-18 Thread Deepa
Hi Everyone, Can someone please give me some site which gives really fancy dashboard illustration. We are tryng to build a couple of dahsboard but the "coolness" quotient is a lil low. Any help would be much appreciated. TIA -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna b

RE: $$Excel-Macros$$ not able to repeat code through all sheets in workbook

2015-08-18 Thread gargee singh
Hello Paul, A big thank you for your help. I had actually completely forgotten that there was a hidden sheet at all and i kept thinking my code was not going beyond the active sheet. That's why we need an expert from time to time. :) Thanks for the tip regarding last active column and hel

Re: $$Excel-Macros$$ Excel formula

2015-08-18 Thread Vikas Bhosale
'=IF(AND(ISERROR(VLOOKUP(A5388,POS!$A$2:$B$97,2,0)),"n/a",VLOOKUP(A5388,POS!$A$2:$B$97,2,0)),IF(ISERROR(VLOOKUP(A5388,POS!$H$5:$I$97,2,0)),"n/a",VLOOKUP(A5388,POS!$H$5:$I$97,2,0)),IF(ISERROR(VLOOKUP(A5388,POS!$O$5:$P$97,2,0)),"n/a",VLOOKUP(A5388,POS!$O$5:$P$97,2,0)),iF(ISERROR(VLOOKUP(A5388,POS!$V$

$$Excel-Macros$$ Excel formula

2015-08-18 Thread Mike B
I would appreciate if someone would look at this formula and tell me what I am doing incorrectly; I have a large spreadsheet called POS where I have different variables separated and I am trying to use IF,AND,ISERROR in nested IF statements and Excel doesn't like what I did. Please see my form

$$Excel-Macros$$ Urgent Need!!! Microstrategy Developer----McLean VA

2015-08-18 Thread MADHU-GenuineItLlc
*Hi All,* *Please send resume to **ma...@genuineitllc.com* *Title : MicroStrategy Developer* *Duration: Long Term* *Location: McLean VA* *Interview: Phone and In-person* Project Tasks and Activities in support of: Reporting Tool Architecture, Design, and Development ü Ongoing developm

$$Excel-Macros$$ Client in New York, NY need Peoplesoft Financials Technical Developer

2015-08-18 Thread MADHU-GenuineItLlc
Hi all, Please send resume to ma...@genuineitllc.com *Title : Peoplesoft Financials Technical Developer* *Location: New York, NY* *Duration: 9-12 months* *LOCAL CANDIDATES ONLY* *JD:-* We are looking for PeopleSoft Technical Consultant with 5+ years of experience, who can help us with

$$Excel-Macros$$ Urgent need for Front End .net Developer---New York, NY--LOCAL CANDIDATES ONLY

2015-08-18 Thread MADHU-GenuineItLlc
Hi Partner, Hope you are doing great … Please send resume to ma...@genuineitllc.com *Title : Front End .net Developer* *Location: New York, NY* *Duration: 6-12 months* *LOCAL CANDIDATES ONLY* JD:- We are seeking a developer who will be responsible for designing and developing web appl

Re: $$Excel-Macros$$ not able to repeat code through all sheets in workbook

2015-08-18 Thread Paul Schreiner
"Technically", it looks like you're not describing the problem accurately.The problem isn't that it only works on the active sheet, the problem is that you have a hidden sheet! It just HAPPENS that in the list of sheets, you have:Summary ASummary BSummary CCentre Acentre formats (original ) (whi

Re: $$Excel-Macros$$ Excel to Pdf

2015-08-18 Thread Paul Schreiner
If you do a File-> SaveAs and select .pdfyou get an "options" button.selecting this button, you can select to publish "Active Sheets".This will create a pdf file of only the sheets selected. Another option would be to hide all the sheets except the ones you want to publish.then publish the "enti

Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.

2015-08-18 Thread Daniel Dias
Hi Unable to download files. pls could you mail this to my id. dias.da...@gmail.com Regards On Sunday, 7 October 2012 14:58:10 UTC+5:30, Bullet wrote: > *@ Krishna, Sir right now it's working fine.thanks a lot for all your > kind support throughout. :) it's really make my job simpler.*