Hi Sudhir
Have a look at the attached. It took some sorting! Hopefully it's what you need.
Regards - Dave.
Date: Mon, 18 Jan 2010 14:12:24 +0530
Subject: $$Excel-Macros$$ Help
From: bluecore...@gmail.com
To: excel-macros@googlegroups.com
Hi Frnds
In the attached sheet calcuation problem.
Dear Manoj, you are welcome...!!
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Mon, Jan 18, 2010 at 4:56 PM, Manoj S Negi <
manojsnegi.uttranc...@gmail.com> wrote:
> Thank you so much Dilip.
hi rahul
check this
this will work in any format
+MID(A1,FIND(9,A1,1),10)
On 19/01/2010, ashish koul wrote:
> Ichek it
>
>
> F(NOT(ISERROR(FIND("No.",A1))),MID(A1,FIND("No.",A1)+4,10),IF(NOT(ISERROR(FIND("No",A1))),MID(A1,FIND("No",A1)+3,10),"
> "))
>
> On Tue, Jan 19, 2010 at 12:17 AM, Rahul Gan
Ichek it
F(NOT(ISERROR(FIND("No.",A1))),MID(A1,FIND("No.",A1)+4,10),IF(NOT(ISERROR(FIND("No",A1))),MID(A1,FIND("No",A1)+3,10),"
"))
On Tue, Jan 19, 2010 at 12:17 AM, Rahul Gandhi. wrote:
> Guys,
>
> I am facing some problem to Extract the A/c no. from Line written in
> Particular Cell.
>
> Ther
hi rahul
plz attach sample file
On 19/01/2010, Rahul Gandhi. wrote:
> Guys,
>
> I am facing some problem to Extract the A/c no. from Line written in
> Particular Cell.
>
> There is only 2 Unique things
>
> 1. A/c No. should be starts from 9.
> 2. Length of A/c no. is 10 digits.
>
> Example.
>
> A
Can't you use the same offset and movement code... i.e. End(xlUp) and
calc two SUMIFs functions?
SUMIF(c10:cN,"COGS",e10:eN)
SUMIF(c10:cN,"Sales",e10:eN)
Dim FirstRow As Long
Dim LastRow As Long
FirstRow = 10
LastRow = Range("A65536").End(xlUp).Offset(0, 0).Row
Range("aa1")
Hello dailey,
Can you share a sample workbook with your exact requirement. I went through
your code.. But was unable to get what exactly you are looking for. If you
share a workbook and explain the result you want..probably it would be easy
for this group members to respond.
Thank you!!
Regards,
Guys,
I am facing some problem to Extract the A/c no. from Line written in
Particular Cell.
There is only 2 Unique things
1. A/c No. should be starts from 9.
2. Length of A/c no. is 10 digits.
Example.
A1 = EMI of Rs. 800 From A/c No. 9089655463
A2 = From A/c No. 9826438564 Debt EMI 300
A3 = A
Hi,
I want open multiple web pages in IE 7 using excel macros.
Can i use Arrays to store weblinks & for loop to move the loop to the next link.
I tried but its not working.
Regards,
Sandeep
--
--
Some important li
I have a spreadsheet that is connected to an Access database using the
“Get External Data” feature of Excel.
The Access database has simple macro that executes to refresh the data
used by the queries. Right now, whenever I want to refresh the tables
in Access, I have to open the databases and run
Hi.
Is there a way to protect just the format of some Excel worksheet area
(Excel 2003)?
I have some areas fully protected and some unprotected. I need to
avoid users to change format (making pastes simpler) in unprotected
areas.
Thanks
Martins
--
---
Hi,
Any special reason for using VBA?
I think this would be done more easily using the worksheet function COUNTIF
Regards - Dave.
> Date: Mon, 18 Jan 2010 06:03:26 -0800
> Subject: $$Excel-Macros$$ Problem w/ VBA Code Evaluating a Range
> From: mdai...@xomox.com
> To: excel-macros@googlegroup
Thank you so much Dilip.
Now its working fine.
*Unfeigned Regards
Manoj S Negi
Skype - manojsnegi
*
On Fri, Jan 15, 2010 at 3:23 PM, Dilip Pandey wrote:
> Dear Manoj,
>
> As requested, please find below the process.
>
> Assume you want to do conditional formatting in entire row 2, if it has
>
I'm relatively new to VBA programming, but what I want to do is go
through a range starting at a10 through the last record listed (varies
in # of records, but always together). If the field in column a =
"cogs", then I want to count it as +1. Eventually I'm trying to
create to sum formulas- one t
hi prabhat
i think this is what you required
let you defind two cell B2 & A16..You want that from A16 THE CURSOR
MOVE TO B2 OR VICE VERSA
Here is a sample macro:
Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address
Case "$B$2"
Range("A16").Se
Hi
am working scheduling problem in excel. i would like to know...is there any
way i can get the chart for the datas in Gantt Chart format.
It will be greatful if somebody helps me out with this problem.
Regards
Maniyan
--
hi bro
check your file at
http://www.file-encryptor.com/
i think your file is corrupted
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Sat, Jan 16, 2010 at 6:04 PM, champaneriya nipun
wrote:
> Dear ankur
>
> Can u
Hi Frnds
In the attached sheet calcuation problem.
for Example
A
125000 (Ram)
262000 (Amit)
3Total
How to total above which has text.
Please Help
--
sudhir
--
--
Some important links for exce
18 matches
Mail list logo
