Re: $$Excel-Macros$$ Hidden sheets

what error you are getting? If its only sheet then you cant hide it & you may get error. Cheers!! On Wed, Aug 13, 2014 at 1:43 AM, Brian wrote: > I have the following code in my Excel 2007 > > Application.Worksheets("Log").Visible = True > > and > > Application.Worksheets("Log").Visible = Fals

$$Excel-Macros$$ Need d JOB in MIS\Data Analyst Profile.

Hello Frnd, I'm Rajeev Ranjan, i have more than 5years exp in data analyst profile,As ref attached d updated cv. Thanks & Regrds Rajeev Ranajn -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ http

$$Excel-Macros$$ Values from INDIRECT not staying after file closes

Hi, I have a rather strange problem: I have a master file with INDIRECT worksheet functions to three different files, alpha, beta and gamma (for simplicity's sake, the actual project has about 100 files). Without opening these three files, the cells with the INDIRECT calls in the master workbo

$$Excel-Macros$$ Hidden sheets

I have the following code in my Excel 2007 Application.Worksheets("Log").Visible = True and Application.Worksheets("Log").Visible = False on my own computer I have run this in Excel 2007, 2010 and 2013 without a problem - I am running on Windows 7 I have given this workbook to an associat

Re: $$Excel-Macros$$ excel modelling and simulation

What are you trying to accomplish? On Aug 12, 2014 11:42 AM, "Sara Lee" wrote: > hi > > Can somebody help me with excel modelling assignment... some simulation > required immediately > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join of

$$Excel-Macros$$ excel modelling and simulation

hi Can somebody help me with excel modelling assignment... some simulation required immediately -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1)

Re: $$Excel-Macros$$ Filter on name in all sheet than paste in Master sheet

Check This !! Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like

Re: $$Excel-Macros$$ Help for date formula

I'd use something like: With the date to consider in A1, use:   =(YEAR(TODAY())-YEAR(A1))*12+MONTH(TODAY())-MONTH(A1)   Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, T

Re: $$Excel-Macros$$ Filter on name in all sheet than paste in Master sheet

First of all, you probably shouldn't "make" us follow a specific technique to accomplish your goals. Simply explain what you want to accomplish, then allow us to recommend a solution.   By that, I mean: I "combine" data from about 9 different sources. Each data source has between 1500 and 1,014,0

Re: $$Excel-Macros$$ On time Issue

Thanks for your replies On Mon, Aug 11, 2014 at 8:11 PM, Vaibhav Joshi wrote: > see this att for ref. > > Cheers!! > > > On Mon, Aug 11, 2014 at 8:09 PM, Vaibhav Joshi wrote: > >> Hi >> >> In first code add at the end this line.. >> >> Call Ontime_PivotRefresh >> >> >> Cheers!! >> >> >> On Mon