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
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
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
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
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
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
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
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
'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