$$Excel-Macros$$ Re: Highlight & add data to another sheet - help needed

2016-06-08 Thread SG
Experts, anybody working on this please? On Tuesday, June 7, 2016 at 4:25:32 PM UTC+5:30, SG wrote: > > Hi Masters, > > Need your help again. I need to do some changes in my file. > > First, when the user enters the start & end time with same day with their > name, it would become red highlighte

$$Excel-Macros$$ Cannot Use two namerange in one sumproduct(sumif( formula

2016-06-08 Thread B Sharma
Hello Excel Friends, I am using the below formula which was working fine for me =SUMPRODUCT(SUMIFS(range 1,criteria 1, range 2,Criteria 2,range 3,*Defined Name Range 1 *)) but I needed one more name range to add in this formula , but it stopped working and showing wrong results... Can somebod

$$Excel-Macros$$ Re: Excel is showing different data on other sharing computer

2016-06-08 Thread B Sharma
Hiii Pravin,, >From your screen shot I think that both the files are at different location... Please check that in the first first there is only one sheet, and in the another file there are 2 sheets (one new with name "Master") Please carefully check the path of the file which you open in the sh

$$Excel-Macros$$ Re: Excel is showing different data on other sharing computer

2016-06-08 Thread B Sharma
In addition to the above,,, You can check the path by the following formula =Cell("filename") On Wednesday, June 8, 2016 at 5:14:42 PM UTC+5:30, B Sharma wrote: > > Hiii Pravin,, > From your screen shot I think that both the files are at different > location... > Please check that in the firs

$$Excel-Macros$$ Date Conversion Problem

2016-06-08 Thread Bill Q
Hi, PSA. Column "A" = source.date. Column "B" = source date converted to special date form MMDD I would like column "C" to be just the numeric. . I have tried just about everything. Cannot figure this out. Any takers ? Much appreciated. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in