$$Excel-Macros$$ Macro required for consolidation

2009-10-30 Thread nitin gupta
Hi All I am an excel user with negligible knowledge if VBA codes. I want to know if following is possible by any generic macro: -->My objective is to consolidate few number of files (say 20 files) where data is there in just two fields i.e "Country" and "Sales in USD". To clarify more: There

Re: $$Excel-Macros$$ HOW CAN I WORK IN ONE WORKBOOK IN MULTIPLE LOCATION

2010-01-11 Thread Nitin Gupta
Hi, Do share the file on Network. Regards Nitin Gupta On Mon, Jan 11, 2010 at 3:29 PM, Anant Shelke wrote: > > Hi, > > I want some help and little bit > challenging > > I WANT TO WORK IN ONE FILE IN MULTIPLE LOCATIONS > AND ALL THE CHANGES MADE BY ALL USERS IT TO BE S

Re: $$Excel-Macros$$ Help

2010-02-10 Thread Nitin Gupta
If you are working in 1 workbook in that case both terms are same and If you are working with more that 1 workbook then ActiveWorkbook denote the current selected workbook and Thisworkbook denote the workbook where the coding is stored. Regards Nitin Gupta On Tue, Feb 9, 2010 at 11:03 PM, Shiv

$$Excel-Macros$$ Re: Compare two text columns by last name

2013-02-23 Thread Nitin Gupta
Pls see the solution in attached sheet Nitin On Saturday, February 23, 2013 1:14:46 PM UTC+5:30, satyas wrote: > > > Hi Experts, > > Just need to compare two columns by last name . Will appreciate if you can > help me for this. > > Satya. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? A

$$Excel-Macros$$ Re: Sum with maximum

2013-02-23 Thread Nitin Gupta
I see the answer in 2 steps, as attached IF & SUMIF Regards Nitin On Saturday, February 23, 2013 4:06:15 PM UTC+5:30, Ranjeet Negi wrote: > > Dear Sir, > > I have a data in Range (C2:C50). There are values. I want to sum all > value upto or equal to 6500, wherein values greater than 6500 wi

$$Excel-Macros$$ Re: Sum with maximum

2013-02-23 Thread Nitin Gupta
Solution in Single Step On Saturday, February 23, 2013 5:01:30 PM UTC+5:30, Ranjeet Negi wrote: > > Thanks, but is it possible to make one formula instead of two step. > > On Saturday, 23 February 2013 16:45:09 UTC+5:30, Nitin Gupta wrote: >> >> I see the answer in 2 ste

$$Excel-Macros$$ DATA LINKAGE PROBLEM

2013-02-23 Thread Nitin Gupta
Hi I want to link multiple data in row to column, but when you use transpose function the links are not working need to past special in value term Sample Sheet attached Please advice -- 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 officia

Re: $$Excel-Macros$$ Sum with maximum

2013-02-23 Thread Nitin Gupta
On Saturday, February 23, 2013 8:09:18 PM UTC+5:30, अनिल नारायण गवली wrote: > > Dear Ramjit, > > Pls share a worksheet with us. > > > > Warm Regards, > Gawli Anil > > On Sat, Feb 23, 2013 at 4:06 PM, Ranjeet Negi > > > wrote: > >> Dear Sir, >> >> I have a data in Range (C2:C50). There are valu

Re: $$Excel-Macros$$ DATA LINKAGE PROBLEM

2013-02-26 Thread Nitin Gupta
'Thanks On Tuesday, February 26, 2013 1:09:46 PM UTC+5:30, bé trần văn wrote: > > Menu> Toosl> Macro> Macro and click Run to view the results > > 2013/2/23 Nitin Gupta > > >> Hi >> I want to link multiple data in row to column, but when you use tran