Re: $$Excel-Macros$$ Maill Merge in Two Excel Sheet

[ankur]

*hi jai
do u want print out of sheet 1 after having Name, Designation, & Emp code of
each employee*?
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 Wed, Jul 6, 2011 at 11:17 AM, ashish koul  wrote:

> HI jAI
>
> do you want to send this form as attachment to emp ids mentioned in sheet 2
> ?
>
> r u using lotus notes or outlook.
>
>
>
>
>
> On Wed, Jul 6, 2011 at 10:45 AM, Jai  wrote:
>
>> Dear Experts
>>
>> i wnat to mail merge From Sheet -2  To Sheet -1, in Sheet -2 , Name,
>> Desination, & Emp code .
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> http://akoul.posterous.com/
>  *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> P Before printing, think about the environment.
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ marco to find common value

[Vasant]

Pls find the attached
This function will give you only the common values in both the columns

On Wed, Jul 6, 2011 at 10:49 AM, HARI NAIR  wrote:
> I want a marco to find common values of column A and B in column C in the
> attached file. Please Help.
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Regards

Vasant

skype Id: vasantjob
vasant...@gmail.com

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


xyz2.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Maill Merge in Two Excel Sheet

[ashish koul]

HI jAI

do you want to send this form as attachment to emp ids mentioned in sheet 2
?

r u using lotus notes or outlook.





On Wed, Jul 6, 2011 at 10:45 AM, Jai  wrote:

> Dear Experts
>
> i wnat to mail merge From Sheet -2  To Sheet -1, in Sheet -2 , Name,
> Desination, & Emp code .
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ marco to find common value

[ashish koul]

check the attachment


On Wed, Jul 6, 2011 at 10:49 AM, HARI NAIR  wrote:

> I want a marco to find common values of column A and B in column C in the
> attached file. Please Help.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


xyz2 (1).xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Need a Macro

[Abhishek Jain]

Friends,

Any update on this?

Thanks,

AJ

On Tue, Jul 5, 2011 at 11:49 AM, Abhishek Jain wrote:

> Dear friends,
>
> Attached along a data wherein in some rows, quantity and amount for items
> nos are both positive which is my inventory.
>
> In other rows one of the either or both are negative or nil. What I need to
> do is to adjust the negative and nil values from the positive values
> available for that particular item no. The macro should search for the
> negative/zero values in quantity and amount columns and if it is found in
> either of the column it should shift the available quantity/amount (with
> rate) to the adjacent columns and in the rows from where the data is shifted
> the row address of destination is written.
>
> An Example -
>
> At Row 16 - The quantity is 0 and amount is negative for item no.
> 002001010001. Now for this item no., the positive values are available at
> row no. 14. The macro should cut the Location Code, Quantity, Amount and
> Rate (D14:G14) and paste it in H16:K16) and in D14 the destination row no.
> is written - H16. (probably with different color).
>
> Hope some one helps me with this. This is a bit urgent.
>
> Thanks & regards,
>
> AJ
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ marco to find common value

[HARI NAIR]

I want a marco to find common values of column A and B in column C in the
attached file. Please Help.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


xyz2.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Maill Merge in Two Excel Sheet

[Jai]

Dear Experts

i wnat to mail merge From Sheet -2  To Sheet -1, in Sheet -2 , Name,
Desination, & Emp code .

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


MAIL MERGE.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Help for Excel query

[karunanithi ramaswamy]

HI,
    APPLY THE MAX FORMULA AT A4 AND CLICK THE FILL HANDLE AND DRAG.
   =MAX(A2:C2)
  DOUBTS IF ANY CONTACT.
-R.KARUNANITHI

--- On Wed, 7/6/11, satish  wrote:

From: satish 
Subject: $$Excel-Macros$$ Help for Excel query
To: "MS EXCEL AND VBA MACROS" 
Date: Wednesday, July 6, 2011, 2:31 AM

Hi,

I want to compare Colum A , B anc C

for ex.


A   B    MOQ
2    1     1       - Select - A
1   2      10     - Select - MOQ
2    4      1      -  Select - B

Basically I want to pick most best selling column for the three taps.

If some can help me out.

Regards

SATISH

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Help for Excel query

[ashish koul]

try the attchement

On Wed, Jul 6, 2011 at 2:31 AM, satish wrote:

> Hi,
>
> I want to compare Colum A , B anc C
>
> for ex.
>
>
> A   BMOQ
> 21 1   - Select - A
> 1   2  10 - Select - MOQ
> 24  1  -  Select - B
>
> Basically I want to pick most best selling column for the three taps.
>
> If some can help me out.
>
> Regards
>
> SATISH
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Book4.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Help Urgent Please

[ICWAI Help]

its Not working getting the wrong emaild id s
Hi Ashish the formula which u have provieded its working somewht but "out 10
geeitn the id for 2 employees id "

Thanks,

On Tue, Jul 5, 2011 at 10:48 PM, PRAVESH KUMAR wrote:

> HI,
> i think solved your quetions.
> otherwise revert me.
> Regards
> Pravesh Kumar
>
> On 7/5/11, ICWAI Help  wrote:
> > Search the employee name in Colomn B and get the email id and should be
> > updated in Colomun C if any formula
> > or code pelase give it to me  I need to do with 1000 records even though
> I
> > will match afterwords
> > single single
> >
> > Note there wont be propper value or text u need to search with part of
> > emplyee name
> >
> > --
> >
> --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> > http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >
> > To post to this group, send email to excel-macros@googlegroups.com
> >
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> > http://www.facebook.com/discussexcel
> >
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Help for Excel query

[satish]

Hi,

I want to compare Colum A , B anc C

for ex.


A   BMOQ
21 1   - Select - A
1   2  10 - Select - MOQ
24  1  -  Select - B

Basically I want to pick most best selling column for the three taps.

If some can help me out.

Regards

SATISH

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ help me urgent

[ICWAI Help]

USE indirect function ti will  help you

On Tue, Jul 5, 2011 at 2:25 PM, Rajan_Verma wrote:

>  *Try this*
>
> * *
>
> * *
>
> *Sub CompileSheet()*
>
> *Dim Sh As Worksheet*
>
> *Sheets.Add.Name  = "Compile"*
>
> *For Each Sh In ActiveWorkbook.Sheets*
>
> **
>
> *If Sh.Name <> "Compile" Then*
>
> *Sh.Activate*
>
> *ActiveSheet.UsedRange.Select*
>
> *Selection.Copy*
>
> *Sheets("Compile").Activate*
>
> *
> ActiveSheet.Range("A4").End(xlUp).Activate*
>
> *ActiveSheet.Paste*
>
> *End If*
>
> *Next*
>
> * *
>
> *End Sub*
>
> * *
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *ashish koul
> *Sent:* Tuesday, July 05, 2011 2:17 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ help me urgent
>
> ** **
>
> try this
>
>  
>
>
> http://akoul.blogspot.com/search/label/Merge%20data%20from%20multiple%20sheets%20to%20sheet1%20in%20same%20workbook
> 
>
> On Tue, Jul 5, 2011 at 11:12 AM, vijayajith VA 
> wrote:
>
> Hi, 
>
> ** **
>
> I have  30 to 40 excel sheets in one workbook..if i want to copy all the
> excel sheet data in one sheet . it takes time..
>
> ** **
>
> so is thr any macros for that . 
>
> ** **
>
> ** **
>
> Please help me
>
> ** **
>
> thanks in advance.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
>
>
>
> -- 
>
> *Regards*
>
> * *
>
> *Ashish Koul*
>
> *akoul*.*blogspot*.com *
> http://akoul.posterous.com/*
>
> *akoul*.wordpress.com 
>
> My Linkedin Profile ***
> *
>
>  
>
> P Before printing, think about the environment.
>
>  
>
> ** **
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Two lookup value with sumproduct.

[PRAVESH KUMAR]

hi,
please find your solution this attachment.

Regards
Pravesh Kumar

On 7/5/11, ICWAI Help  wrote:
> Hello Ashsih,
>
> COULD YOU PLEASE EXPLAIN ME WITH TWO LOOKUP VALUE THE SUMPRODUCT FUNCTION
> ITS URGENT PLESE HELP ME AS SOON AS POSSIBEL.
>
> THANKS,
> RAKESH.
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


New_Microsoft_Office_Excel_Worksheet(1).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ select row which have specified data

[Rajesh K R]

Hi Ankur
Thanks for the formula, but the values in the sheet 2 will change
daily and I have to keep the data in sheet 1 permanently. that is why
I am asking for code.if any idea pls tell me how can we do the same
thing with a code.
Regards
Rajesh Kainikkara


On 7/5/11, ankur  wrote:
> *hi rajesh
> i used formulas in sheet 1 , to get data from sheet 2
> just enter your data in sheet 2, it will be displayed against the date in
> sheet 1
> may this  may help u
> find attached file
> *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 Tue, Jul 5, 2011 at 6:23 PM, ashish koul  wrote:
>
>> try this
>>
>> Sub test()
>> Dim i As Long
>> For i = 2 To Sheets(1).Range("a65356").End(xlUp).Row
>> If DateValue(Sheets(1).Cells(i, 1).Value) =
>> DateValue(Sheets(2).Range("a1").Value) Then
>> k = Sheets(2).Range("iv2").End(xlToLeft).Column + 1
>>
>> For j = 2 To 11
>> Sheets(2).Cells(j, k).Value = Sheets(1).Cells(i, j).Value
>>
>> Next j
>> ' use exit for if u dnt want to search any more
>> Exit For
>>
>> End If
>> Next i
>> End Sub
>>
>>
>> On Tue, Jul 5, 2011 at 5:53 PM, Rajesh K R
>> wrote:
>>
>>> Hi Experts,
>>>
>>> Please find the attached file & tell me the code how to select the
>>> date value in "sheet2" cell "A1" in Sheet 1. After selecting the row
>>> then all the data in sheet2 range("B2:B11") have to copy & paste in
>>> the sheet1 colomns("B:K").
>>>
>>> Regards
>>>
>>> Rajesh Kainikkara
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>> *akoul*.*blogspot*.com 
>> http://akoul.posterous.com/
>>  *akoul*.wordpress.com 
>> My Linkedin Profile 
>>
>>
>> P Before printing, think about the environment.
>>
>>
>>  --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Help Urgent Please

[PRAVESH KUMAR]

HI,
i think solved your quetions.
otherwise revert me.
Regards
Pravesh Kumar

On 7/5/11, ICWAI Help  wrote:
> Search the employee name in Colomn B and get the email id and should be
> updated in Colomun C if any formula
> or code pelase give it to me  I need to do with 1000 records even though I
> will match afterwords
> single single
>
> Note there wont be propper value or text u need to search with part of
> emplyee name
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Copy of updated.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Two lookup value with sumproduct.

[ICWAI Help]

you simply a champ

On Tue, Jul 5, 2011 at 10:42 PM, ICWAI Help  wrote:

> thank you so much ashish its wrking now
>   On Tue, Jul 5, 2011 at 9:50 PM, ashish koul wrote:
>
>> try this
>>
>>
>> On Tue, Jul 5, 2011 at 7:54 PM, ICWAI Help wrote:
>>
>>> Hello Ashsih,
>>>
>>> COULD YOU PLEASE EXPLAIN ME WITH TWO LOOKUP VALUE THE SUMPRODUCT FUNCTION
>>>
>>> ITS URGENT PLESE HELP ME AS SOON AS POSSIBEL.
>>>
>>> THANKS,
>>> RAKESH.
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>> *akoul*.*blogspot*.com 
>> http://akoul.posterous.com/
>> *akoul*.wordpress.com 
>> My Linkedin Profile 
>>
>>
>> P Before printing, think about the environment.
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Two lookup value with sumproduct.

[ICWAI Help]

thank you so much ashish its wrking now
On Tue, Jul 5, 2011 at 9:50 PM, ashish koul  wrote:

> try this
>
>
> On Tue, Jul 5, 2011 at 7:54 PM, ICWAI Help wrote:
>
>> Hello Ashsih,
>>
>> COULD YOU PLEASE EXPLAIN ME WITH TWO LOOKUP VALUE THE SUMPRODUCT FUNCTION
>> ITS URGENT PLESE HELP ME AS SOON AS POSSIBEL.
>>
>> THANKS,
>> RAKESH.
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> http://akoul.posterous.com/
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> P Before printing, think about the environment.
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Help Urgent Please

[ashish koul]

hope you will get most of ids from these formula's

c2 = VLOOKUP(LEFT(A2,FIND(" ",A2)-1)&"*",B:B,1,0)

d2  = VLOOKUP("*"&RIGHT(A2,LEN(A2)-FIND("~",SUBSTITUTE(A2,"
","~",LEN(A2)-LEN(SUBSTITUTE(A2," ",""),B:B,1,0)


On Tue, Jul 5, 2011 at 9:58 PM, ICWAI Help  wrote:

> Search the employee name in Colomn B and get the email id and should be
> updated in Colomun C if any formula
> or code pelase give it to me  I need to do with 1000 records even though I
> will match afterwords
> single single
>
> Note there wont be propper value or text u need to search with part of
> emplyee name
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Help Urgent Please

[ICWAI Help]

Search the employee name in Colomn B and get the email id and should be
updated in Colomun C if any formula
or code pelase give it to me  I need to do with 1000 records even though I
will match afterwords
single single

Note there wont be propper value or text u need to search with part of
emplyee name

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Copy of updated.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$

[ashish koul]

try this

Sub test()
Dim i As Long
'  5 bcoz data starts from n5 to n22
For i = 5 To 22
Range("g4").Value = Range("n" & i).Value
Range("g5").Value = Range("o" & i).Value
'
ActiveSheet.PageSetup.PrintArea = "$A$1:$l$20"
ActiveWindow.Selection.PrintOut Copies:=1
Next i
End Sub


On Tue, Jul 5, 2011 at 7:51 PM, Azeem Quraishi (HAB5) wrote:

>  Hi All
>
> ** **
>
> ** **
>
> I have excel file which I attached I am not able to create macro because I
> need to print each test no each page manually taking more time please 
>
> I need  any macro  and any method easy which is I can print at a time all
> test number per printout separate.
>
> ** **
>
> ** **
>
> Appreciate your support in advance.
>
> ** **
>
> * *
>
> *Best Regards*
>
> * *
>
> * *
>
> *Syed Azeem Quraishi*
>
> ** **
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Two lookup value with sumproduct.

[ashish koul]

try this

On Tue, Jul 5, 2011 at 7:54 PM, ICWAI Help  wrote:

> Hello Ashsih,
>
> COULD YOU PLEASE EXPLAIN ME WITH TWO LOOKUP VALUE THE SUMPRODUCT FUNCTION
> ITS URGENT PLESE HELP ME AS SOON AS POSSIBEL.
>
> THANKS,
> RAKESH.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


New_Microsoft_Office_Excel_Worksheet(1).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Two lookup value with sumproduct.

[ICWAI Help]

Hello Ashsih,

COULD YOU PLEASE EXPLAIN ME WITH TWO LOOKUP VALUE THE SUMPRODUCT FUNCTION
ITS URGENT PLESE HELP ME AS SOON AS POSSIBEL.

THANKS,
RAKESH.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


New Microsoft Office Excel Worksheet.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$

[Azeem Quraishi (HAB5)]

Hi All

 

 

I have excel file which I attached I am not able to create macro because
I need to print each test no each page manually taking more time please 

I need  any macro  and any method easy which is I can print at a time
all test number per printout separate.

 

 

Appreciate your support in advance.

 

 

Best Regards

 

 

Syed Azeem Quraishi

 

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


REPORT.xlsx
Description: REPORT.xlsx

Re: $$Excel-Macros$$ macro for copy down

[rajan verma]

I think Default Fill option will take minimum time then User Define Macro.
You can fill Down your Formula By Ctrl+D

On Tue, Jul 5, 2011 at 2:58 PM, Rash  wrote:

> Hi All,
>
>
> I have excel file with 12000+ rows, and 10 column where i have used Vlookup
> and sumif function in the second row, i need a macro which copy down the
> function till the last row with min. time frame.
>
> Appreciate your support in advance.
>
> Regards
> Rash
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Regards
Rajan verma
+91 9158998701

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Macro for find any possible combination of numbers from given numbers to a given total

[Markkim]

Thanks a lot!!!

Well, I looked at the macro and its' not what I want. 

I thought through and came up with a following code..  ( just testing code) 

In this example, there are five values: 12.25, 10.3, 24.3, 23.19, 55.2
And I need to find any combination of values above which sum up to ... let's 
say 34.6. 

Sub Test()

Dim Ob_N(1 To 5) As Variant

Ob_N(1) = 12.25
Ob_N(2) = 10.3
Ob_N(3) = 24.3
Ob_N(4) = 23.19
Ob_N(5) = 55.2


Seeking_sum_amount = 34.6

For i = 1 To 5

For j = i + 1 To 5

If Ob_N(i) + Ob_N(j) = Seeking_sum_amount Then

ActiveCell.Value = Ob_N(i)
ActiveCell.Offset(0, 1) = Ob_N(j)
ActiveCell.Offset(1, 0).Select
End If

Next
Next
End Sub

Now, the problem of this testing code is that it only looks at the 
combination of 2 values... 
I can add another for...next for three combination ...   
and add another for four 4 combination test 

but I'm wondering  if there is a way to do up to 4 combination test if 
number of given values are 4.. if number of given values is 6 then up to 
5 combination test..  and so on..  

To sum up, macro determines how many values are given.  --->  ubound(Ob_n) 
run the combination test up to ubound(ob_n) - 1 and find any combination 
which sum up to a specified value. 

any good way of doing this??? 


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ macro for copy down

[vikas verma]

Hi Dear,

You can do this with the help of record macro easily.
Please forward me your sheet i will try to help you.

Thanks & regards,
Vikas verma

On Tue, Jul 5, 2011 at 2:58 PM, Rash  wrote:

> Hi All,
>
>
> I have excel file with 12000+ rows, and 10 column where i have used Vlookup
> and sumif function in the second row, i need a macro which copy down the
> function till the last row with min. time frame.
>
> Appreciate your support in advance.
>
> Regards
> Rash
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Thanks & Regards,

Vikas Verma

Bank of America

delhi.ve...@gmail.com

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Mail Merge Regarding

[ashish koul]

can you explaint it in detail what excatly you want to do

On Tue, Jul 5, 2011 at 4:56 PM, Jai  wrote:

> Hello EveryBody
>
> Can You tell me that , Mail Merge is possible in One Excel File to Another
> Excel file , if it is possible then How?
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ select row which have specified data

[ankur]

*hi rajesh
i used formulas in sheet 1 , to get data from sheet 2
just enter your data in sheet 2, it will be displayed against the date in
sheet 1
may this  may help u
find attached file
*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 Tue, Jul 5, 2011 at 6:23 PM, ashish koul  wrote:

> try this
>
> Sub test()
> Dim i As Long
> For i = 2 To Sheets(1).Range("a65356").End(xlUp).Row
> If DateValue(Sheets(1).Cells(i, 1).Value) =
> DateValue(Sheets(2).Range("a1").Value) Then
> k = Sheets(2).Range("iv2").End(xlToLeft).Column + 1
>
> For j = 2 To 11
> Sheets(2).Cells(j, k).Value = Sheets(1).Cells(i, j).Value
>
> Next j
> ' use exit for if u dnt want to search any more
> Exit For
>
> End If
> Next i
> End Sub
>
>
> On Tue, Jul 5, 2011 at 5:53 PM, Rajesh K R wrote:
>
>> Hi Experts,
>>
>> Please find the attached file & tell me the code how to select the
>> date value in "sheet2" cell "A1" in Sheet 1. After selecting the row
>> then all the data in sheet2 range("B2:B11") have to copy & paste in
>> the sheet1 colomns("B:K").
>>
>> Regards
>>
>> Rajesh Kainikkara
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> http://akoul.posterous.com/
>  *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> P Before printing, think about the environment.
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


SOLUTION OF FIND(1).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ select row which have specified data

[ashish koul]

try this

Sub test()
Dim i As Long
For i = 2 To Sheets(1).Range("a65356").End(xlUp).Row
If DateValue(Sheets(1).Cells(i, 1).Value) =
DateValue(Sheets(2).Range("a1").Value) Then
k = Sheets(2).Range("iv2").End(xlToLeft).Column + 1

For j = 2 To 11
Sheets(2).Cells(j, k).Value = Sheets(1).Cells(i, j).Value

Next j
' use exit for if u dnt want to search any more
Exit For

End If
Next i
End Sub


On Tue, Jul 5, 2011 at 5:53 PM, Rajesh K R wrote:

> Hi Experts,
>
> Please find the attached file & tell me the code how to select the
> date value in "sheet2" cell "A1" in Sheet 1. After selecting the row
> then all the data in sheet2 range("B2:B11") have to copy & paste in
> the sheet1 colomns("B:K").
>
> Regards
>
> Rajesh Kainikkara
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ select row which have specified data

[Rajesh K R]

Hi Experts,

Please find the attached file & tell me the code how to select the
date value in "sheet2" cell "A1" in Sheet 1. After selecting the row
then all the data in sheet2 range("B2:B11") have to copy & paste in
the sheet1 colomns("B:K").

Regards

Rajesh Kainikkara

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


FIND(1).xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Mail Merge Regarding

[Jai]

Hello EveryBody

Can You tell me that , Mail Merge is possible in One Excel File to Another
Excel file , if it is possible then How?

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ macro for copy down

[Vasant]

Sub Test()
Dim Rng As Range
Lrow = ActiveSheet.Range("A65536").End(xlUp).Row ' Last Row in Column A.
Set Rng = ActiveSheet.Range("B1") ' Cell where you have the vlookup formula
Rng.AutoFill Destination:=Range("B1" & ":B" & Trim(Str(Lrow))),
Type:=xlFillDefault
End Sub


On Tue, Jul 5, 2011 at 2:58 PM, Rash  wrote:
> Hi All,
>
> I have excel file with 12000+ rows, and 10 column where i have used Vlookup
> and sumif function in the second row, i need a macro which copy down the
> function till the last row with min. time frame.
> Appreciate your support in advance.
> Regards
> Rash
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Regards

Vasant

skype Id: vasantjob
vasant...@gmail.com

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Re: and the Microsoft MVP award goes to Ashish Koul :)

[shannu shannu]

Congrats Ashish, now dont fly our expectation has now  increased more.  
 

--- On Tue, 7/5/11, Vasant  wrote:


From: Vasant 
Subject: Re: $$Excel-Macros$$ Re: and the Microsoft MVP award goes to Ashish 
Koul :)
To: excel-macros@googlegroups.com
Date: Tuesday, July 5, 2011, 7:35 AM


Hey Ashish,

Congrats!,
You deserve it



On Tue, Jul 5, 2011 at 3:47 AM, bpascal123  wrote:
> Ayush,
> I wish you well.
> Congrats to Ashish!
> Pascal
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links : 
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Regards

Vasant

skype Id: vasantjob
vasant...@gmail.com

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - June'11

[simplyali]

Thanks Ashish for the Invite.. I have accepted the same...
I would like to thank you million times for making me aware of this
post

On Jul 5, 10:29 am, Kal xcel  wrote:
> Congratulation Ashish...You deserve it
>
> Kalyan
>
>
>
> On Mon, Jul 4, 2011 at 11:17 PM, Ahmed galal  wrote:
> >  [image:
> >http://tracking.technodesignip.com/?action=count&projectid=642&conten..]Congratulations
> > *Ashish*, you deserve it.[image:
> >http://tracking.technodesignip.com/?action=count&projectid=642&conten..]
>
> > Best regards,
>
> > *Ahmed galal Mohamed*
>
> > Procurement Engineer
>
> > Head Office : SQUARE Engineering Firm
> > Tel       :(202) 2402 8846
> > Fax      :(202) 2405 0476
> > Mobile :(010) 9 62 60 61
> > Website :http://www.square.com.eg
> > 31 Lebanon St. Mohandsen, Giza, Egypt
>
> >  --
> > From: jainayus...@gmail.com
> > Date: Mon, 4 Jul 2011 22:48:33 +0530
> > Subject: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - June'11
> > To: excel-macros@googlegroups.com
>
> >   Hello Everyone,
>
> > Ashish Koul has been selected as 'Most Helpful Member' for the month of
> > June'11
> > He has posted 53 posts in June 2011 and helped many people through his
> > expertise. He has been consistent contributor to this excel forum and
> > achieved this recognition from last seven months consecutively.This is
> > really awesome. He is awarded Microsoft MVP 2011 award for his voluntary
> > contribution.
>
> >    Thanks to Rajan, Venkat and other folks for helping excel enthusiasts !!
> > keep it up !!
>
> >    Let see who becomes next MVP..
>
> >    Keep posting.
>
> >  Regards
> > Ayush Jain
> > Group Manager
>
> > --
>
> > ---­---
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/discussexcel
>
> > --
>
> > ---­---
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/discussexcel- Hide quoted text -
>
> - Show quoted text -

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

RE: Re $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING

[MITTAL AJAY]

Thanks Rajan .

It is working fine.

With Warm Regards,

CA. Ajay Mittal
Finance Manager

[cid:image001.jpg@01CC3B23.4A34CC10]
Pipelines Division,
Noida - 201 301
Tel: 0120-2448312

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Rajan_Verma
Sent: Tuesday, July 05, 2011 2:24 PM
To: excel-macros@googlegroups.com
Subject: Re $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING

Use this In B2

=MID(SUBSTITUTE(TRIM(A2)," ","*",2),FIND("*",SUBSTITUTE(TRIM(A2)," 
","*",2),1)+1,11)



From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of MITTAL AJAY
Sent: Tuesday, July 05, 2011 2:07 PM
To: 'excel-macros@googlegroups.com'
Subject: $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING

I WANT TO EXTRACT  11 DIGIT NUMBER IN CLOUMN B.

Can anybody suggest a suitable formula ?

With Warm Regards,

CA. Ajay Mittal
Finance Manager

[cid:image001.jpg@01CC3B23.4A34CC10]
Pipelines Division,
Noida - 201 301
Tel: 0120-2448312

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of ashish koul
Sent: Tuesday, July 05, 2011 1:33 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ copy data without opening file

i suggest you hide the workbook from which you are copying the data if you dont 
want to show it to the user


http://akoul.blogspot.com/search/label/Hide%20and%20Unhide%20a%20workbook%20in%20vba



On Tue, Jul 5, 2011 at 12:53 PM, Rajan_Verma 
mailto:rajanverma1...@gmail.com>> wrote:
No, We cant Copy the data from Closed Workbook.. but we can get the Data by 
Using Full Reference of cell .. Like

='C:\Users\Xl_Lover\Desktop\[ForDownload[Sheet1]]Sheet1'!A1


From: excel-macros@googlegroups.com 
[mailto:excel-macros@googlegroups.com] On 
Behalf Of ankur
Sent: Tuesday, July 05, 2011 12:13 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ copy data without opening file

hi hanumant

you may find this to be useful

http://spreadsheetpage.com/index.php...a_closed_file/
[cid:image002.jpg@01CC3B23.4A34CC10]

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 Tue, Jul 5, 2011 at 12:40 AM, hanumant shinde 
mailto:arsfan2...@yahoo.co.in>> wrote:
Hi friends,

is there any way where we can copy data from closed workbook "A" and paste it
into workbook "B" which is open?

--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at 
http://www.excel-macros.blogspot.com
4. Learn VBA Macros at 
http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at 
http://exceldailytip.blogspot.com

To post to this group, send email to 
excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at 
http://www.excel-macros.blogspot.com
4. Learn VBA Macros at 
http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at 
http://exceldailytip.blogspot.com

To post to this group, send email to 
excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at 
http://www.excel-macros.blogspot.com
4. Learn VBA Macros at 
http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at 
http://exceldailytip.blogspot.com

To post to this group, send email to 
excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><

$$Excel-Macros$$ Re: Macro spanning into different files and folders. Can someone help?

[Ronak Hindocha]

Hi, Please see the original post. It will be really great if I can receive 
some help here. 

Regards,
Ronak
99874 12342 

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ macro for copy down

[Rash]

Hi All,


I have excel file with 12000+ rows, and 10 column where i have used Vlookup 
and sumif function in the second row, i need a macro which copy down the 
function till the last row with min. time frame.

Appreciate your support in advance.

Regards
Rash

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

RE: Re $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING

[MITTAL AJAY]

Thanks Dave. Excellent ..

With Warm Regards,

CA. Ajay Mittal
Finance Manager

[cid:image001.jpg@01CC3B22.459EBEA0]
Pipelines Division,
Noida - 201 301
Tel: 0120-2448312

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Dave Bonallack
Sent: Tuesday, July 05, 2011 2:38 PM
To: excel-macros@googlegroups.com
Subject: RE: Re $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING

Hi,
Here is another option. It is slightly shorter, and doesn't produce a #VALUE! 
error when the target cell does not contain the expected data.
=MID(A2,MIN(SEARCH({1,2,3,4,5,6,7,8,9,0},A2&1234567890)),11)
If your the 11 digit number always starts with a 1 or a 3, as it does in your 
sample, then the formula could be further reduced to:
=MID(A2,MIN(SEARCH({1,3},A2&13)),11)
Regards - Dave.

From: rajanverma1...@gmail.com
To: excel-macros@googlegroups.com
Subject: Re $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING
Date: Tue, 5 Jul 2011 14:24:00 +0530
Use this In B2

=MID(SUBSTITUTE(TRIM(A2)," ","*",2),FIND("*",SUBSTITUTE(TRIM(A2)," 
","*",2),1)+1,11)



From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of MITTAL AJAY
Sent: Tuesday, July 05, 2011 2:07 PM
To: 'excel-macros@googlegroups.com'
Subject: $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING

I WANT TO EXTRACT  11 DIGIT NUMBER IN CLOUMN B.

Can anybody suggest a suitable formula ?

With Warm Regards,

CA. Ajay Mittal
Finance Manager

[cid:image001.jpg@01CC3B22.459EBEA0]
Pipelines Division,
Noida - 201 301
Tel: 0120-2448312

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of ashish koul
Sent: Tuesday, July 05, 2011 1:33 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ copy data without opening file

i suggest you hide the workbook from which you are copying the data if you dont 
want to show it to the user


http://akoul.blogspot.com/search/label/Hide%20and%20Unhide%20a%20workbook%20in%20vba



On Tue, Jul 5, 2011 at 12:53 PM, Rajan_Verma 
mailto:rajanverma1...@gmail.com>> wrote:
No, We cant Copy the data from Closed Workbook.. but we can get the Data by 
Using Full Reference of cell .. Like

='C:\Users\Xl_Lover\Desktop\[ForDownload[Sheet1]]Sheet1'!A1


From: excel-macros@googlegroups.com 
[mailto:excel-macros@googlegroups.com] On 
Behalf Of ankur
Sent: Tuesday, July 05, 2011 12:13 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ copy data without opening file

hi hanumant

you may find this to be useful

http://spreadsheetpage.com/index.php...a_closed_file/
[cid:image002.jpg@01CC3B22.459EBEA0]

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 Tue, Jul 5, 2011 at 12:40 AM, hanumant shinde 
mailto:arsfan2...@yahoo.co.in>> wrote:
Hi friends,

is there any way where we can copy data from closed workbook "A" and paste it
into workbook "B" which is open?

--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at 
http://www.excel-macros.blogspot.com
4. Learn VBA Macros at 
http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at 
http://exceldailytip.blogspot.com

To post to this group, send email to 
excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at 
http://www.excel-macros.blogspot.com
4. Learn VBA Macros at 
http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at 
http://exceldailytip.blogspot.com

To post to this group, send email to 
excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
--
Some important links for excel users:
1. 

Re: $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING

[Manoj kumar]

Hi,

you can use this formula as well in cell B2:-

=LOOKUP(99^99,--("0"&MID(A2,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A2&"0123456789")),ROW(INDIRECT("1:"&LEN(A2))



Best,
Manoj Kumar
On Tue, Jul 5, 2011 at 2:06 PM, MITTAL AJAY  wrote:

>  I WANT TO EXTRACT  11 DIGIT NUMBER IN CLOUMN B.
>
> ** **
>
> Can anybody suggest a suitable formula ?
>
> ** **
>
> *With Warm Regards,*
>
> * *
>
> *CA. Ajay Mittal*
>
> *Finance Manager*
>
> * *
>
> *[image: cid:image001.jpg@01CC1029.98246F90]*
>
> *Pipelines Division,*
>
> *Noida - 201 301
> **Tel: 0120-2448312***
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *ashish koul
> *Sent:* Tuesday, July 05, 2011 1:33 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ copy data without opening file
>
> ** **
>
> i suggest you hide the workbook from which you are copying the data if you
> dont want to show it to the user 
>
>  
>
>  
>
>
> http://akoul.blogspot.com/search/label/Hide%20and%20Unhide%20a%20workbook%20in%20vba
> 
>
>  
>
>
>  
>
> On Tue, Jul 5, 2011 at 12:53 PM, Rajan_Verma 
> wrote:
>
> *No, We cant Copy the data from Closed Workbook.. but we can get the Data
> by Using Full Reference of cell .. Like*
>
> * *
>
> *='C:\Users\Xl_Lover\Desktop\[ForDownload[Sheet1]]Sheet1'!A1*
>
> * *
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *ankur
> *Sent:* Tuesday, July 05, 2011 12:13 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ copy data without opening file
>
>  
>
> hi hanumant
>
> you may find this to be useful
>
> http://spreadsheetpage.com/index.php...a_closed_file/
> 
>
> [image: Image removed by sender. Reply With 
> Quote]
> 
>
>
> 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 Tue, Jul 5, 2011 at 12:40 AM, hanumant shinde 
> wrote:
>
> Hi friends,
>
> is there any way where we can copy data from closed workbook "A" and paste
> it
> into workbook "B" which is open?
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
>  
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> -- 
>
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
>
>
>
> -- 
>
> *Regards*
>
> * *
>
> *Ashish Koul*
>
> *akoul*.*blogspot*.com *
> http://akoul.posterous.com/*
>
> *akoul*.wordpress.com 
>
> My Linkedin Profile ***
> *
>
>  
>
> P Before printing, think about the environment.
>
>  
>
> ** **
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER 

Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - June'11

[Venkatesan c]

Congrats  *Ashish,*
*
*
*
*
-- 
*Best Regards,*
*Venkat*
*
*



On Tue, Jul 5, 2011 at 10:59 AM, Kal xcel  wrote:

> Congratulation Ashish...You deserve it
>
> Kalyan
>
>
> On Mon, Jul 4, 2011 at 11:17 PM, Ahmed galal  wrote:
>
>>  [image:
>> http://tracking.technodesignip.com/?action=count&projectid=642&contentid=6543&referrer=-&urlaction=r...]Congratulations
>> *Ashish*, you deserve it.[image:
>> http://tracking.technodesignip.com/?action=count&projectid=642&contentid=6548&referrer=-&urlaction=r...]
>>
>>
>> Best regards,
>>
>>
>>
>> *Ahmed galal Mohamed*
>>
>> Procurement Engineer
>>
>> Head Office : SQUARE Engineering Firm
>> Tel   :(202) 2402 8846
>> Fax  :(202) 2405 0476
>> Mobile :(010) 9 62 60 61
>> Website : http://www.square.com.eg
>> 31 Lebanon St. Mohandsen, Giza, Egypt
>>
>>
>>
>>
>>
>>  --
>> From: jainayus...@gmail.com
>> Date: Mon, 4 Jul 2011 22:48:33 +0530
>> Subject: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - June'11
>> To: excel-macros@googlegroups.com
>>
>>
>>   Hello Everyone,
>>
>> Ashish Koul has been selected as 'Most Helpful Member' for the month of
>> June'11
>> He has posted 53 posts in June 2011 and helped many people through his
>> expertise. He has been consistent contributor to this excel forum and
>> achieved this recognition from last seven months consecutively.This is
>> really awesome. He is awarded Microsoft MVP 2011 award for his voluntary
>> contribution.
>>
>>
>>Thanks to Rajan, Venkat and other folks for helping excel enthusiasts
>> !! keep it up !!
>>
>>Let see who becomes next MVP..
>>
>>Keep posting.
>>
>>
>>  Regards
>> Ayush Jain
>> Group Manager
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

RE: Re $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING

[Dave Bonallack]

Hi,
Here is another option. It is slightly shorter, and doesn't produce a #VALUE! 
error when the target cell does not contain the expected data.
=MID(A2,MIN(SEARCH({1,2,3,4,5,6,7,8,9,0},A2&1234567890)),11)
If your the 11 digit number always starts with a 1 or a 3, as it does in your 
sample, then the formula could be further reduced to:
=MID(A2,MIN(SEARCH({1,3},A2&13)),11)
Regards - Dave.

From: rajanverma1...@gmail.com
To: excel-macros@googlegroups.com
Subject: Re $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING
Date: Tue, 5 Jul 2011 14:24:00 +0530



















Use this In B2

 

=MID(SUBSTITUTE(TRIM(A2),"
","*",2),FIND("*",SUBSTITUTE(TRIM(A2),"
","*",2),1)+1,11)

 

 

 





From:
excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of MITTAL AJAY

Sent: Tuesday, July 05, 2011 2:07 PM

To: 'excel-macros@googlegroups.com'

Subject: $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING





 

I WANT TO EXTRACT  11 DIGIT NUMBER IN CLOUMN B.

 

Can anybody suggest a suitable formula ?

 

With Warm Regards,

 

CA. Ajay Mittal

Finance Manager

 



Pipelines Division,

Noida - 201 301

Tel: 0120-2448312

 



From:
excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of ashish koul

Sent: Tuesday, July 05, 2011 1:33 PM

To: excel-macros@googlegroups.com

Subject: Re: $$Excel-Macros$$ copy data without opening file



 



i suggest you hide the workbook from which you are copying
the data if you dont want to show it to the user 





 





 





http://akoul.blogspot.com/search/label/Hide%20and%20Unhide%20a%20workbook%20in%20vba





 







 





On Tue, Jul 5, 2011 at 12:53 PM, Rajan_Verma  wrote:





No, We cant Copy the data from Closed
Workbook.. but we can get the Data by Using Full Reference of cell .. Like

 

='C:\Users\Xl_Lover\Desktop\[ForDownload[Sheet1]]Sheet1'!A1

 

 



From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com]
On Behalf Of ankur

Sent: Tuesday, July 05, 2011 12:13 PM

To: excel-macros@googlegroups.com

Subject: Re: $$Excel-Macros$$ copy data without opening file





 



hi hanumant



you may find this to be useful



http://spreadsheetpage.com/index.php...a_closed_file/

















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
Tue, Jul 5, 2011 at 12:40 AM, hanumant shinde 
wrote:

Hi
friends,



is there any way where we can copy data from closed workbook "A" and
paste it

into workbook "B" which is open?



--

--

Some important links for excel users:

1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip

2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310

3. Excel tutorials at http://www.excel-macros.blogspot.com

4. Learn VBA Macros at http://www.quickvba.blogspot.com

5. Excel Tips and Tricks at http://exceldailytip.blogspot.com



To post to this group, send email to excel-macros@googlegroups.com



<><><><><><><><><><><><><><><><><><><><><><>

Like our page on facebook , Just follow below link

http://www.facebook.com/discussexcel



 

--


--

Some important links for excel users:

1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip

2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310

3. Excel tutorials at http://www.excel-macros.blogspot.com

4. Learn VBA Macros at http://www.quickvba.blogspot.com

5. Excel Tips and Tricks at http://exceldailytip.blogspot.com



To post to this group, send email to excel-macros@googlegroups.com

 

<><><><><><><><><><><><><><><><><><><><><><>

Like our page on facebook , Just follow below link

http://www.facebook.com/discussexcel









-- 





--

Some important links for excel users:

1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip

2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310

3. Excel tutorials at http://www.excel-macros.blogspot.com

4. Learn VBA Macros at http://www.quickvba.blogspot.com

5. Excel Tips and Tricks at http://exceldailytip.blogspot.com



To post to this group, send email to excel-macros@googlegroups.com

 

<><><><><><><><><><><><><><><><><><><><><><>

Like our page on facebook , Just follow below link

http://www.facebook.com/discussexcel












-- 



Regards





 





Ashish
Koul





akoul.blogspot.com

http://akoul.posterous.com/





akoul.wordpress.com





My
Linkedin Profile





 





P Before printing, think about the
environment.

 



 

-- 

--

Some important links for excel users:

1. Follow us on TWITTER for tips tricks and 

RE: $$Excel-Macros$$ help me urgent

[Rajan_Verma]

Try this

 

 

Sub CompileSheet()

Dim Sh As Worksheet

Sheets.Add.Name = "Compile"

For Each Sh In ActiveWorkbook.Sheets



If Sh.Name <> "Compile" Then

Sh.Activate

ActiveSheet.UsedRange.Select

Selection.Copy

Sheets("Compile").Activate

ActiveSheet.Range("A4").End(xlUp).Activate

ActiveSheet.Paste

End If

Next

 

End Sub

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent: Tuesday, July 05, 2011 2:17 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ help me urgent

 

try this

 

http://akoul.blogspot.com/search/label/Merge%20data%20from%20multiple%20shee
ts%20to%20sheet1%20in%20same%20workbook

On Tue, Jul 5, 2011 at 11:12 AM, vijayajith VA 
wrote:

Hi, 

 

I have  30 to 40 excel sheets in one workbook..if i want to copy all the
excel sheet data in one sheet . it takes time..

 

so is thr any macros for that . 

 

 

Please help me

 

thanks in advance.

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
 
4. Learn VBA Macros at http://www.quickvba.blogspot.com
 
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel




-- 

Regards

 

Ashish Koul

  akoul.blogspot.com
http://akoul.posterous.com/

  akoul.wordpress.com

My   Linkedin Profile

 

P Before printing, think about the environment.

 

 

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING

[ashish koul]

hi Ajay

try this

=MID(B2,FIND(" ",B2,FIND(" ",B2)+1),FIND(" ",B2,FIND(" ",B2,FIND("
",B2)+1)+2)-FIND(" ",B2,FIND(" ",B2)+1))

On Tue, Jul 5, 2011 at 2:06 PM, MITTAL AJAY  wrote:

>  I WANT TO EXTRACT  11 DIGIT NUMBER IN CLOUMN B.
>
> ** **
>
> Can anybody suggest a suitable formula ?
>
> ** **
>
> *With Warm Regards,*
>
> * *
>
> *CA. Ajay Mittal*
>
> *Finance Manager*
>
> * *
>
> *[image: cid:image001.jpg@01CC1029.98246F90]*
>
> *Pipelines Division,*
>
> *Noida - 201 301
> **Tel: 0120-2448312***
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *ashish koul
> *Sent:* Tuesday, July 05, 2011 1:33 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ copy data without opening file
>
> ** **
>
> i suggest you hide the workbook from which you are copying the data if you
> dont want to show it to the user 
>
>  
>
>  
>
>
> http://akoul.blogspot.com/search/label/Hide%20and%20Unhide%20a%20workbook%20in%20vba
> 
>
>  
>
>
>  
>
> On Tue, Jul 5, 2011 at 12:53 PM, Rajan_Verma 
> wrote:
>
> *No, We cant Copy the data from Closed Workbook.. but we can get the Data
> by Using Full Reference of cell .. Like*
>
> * *
>
> *='C:\Users\Xl_Lover\Desktop\[ForDownload[Sheet1]]Sheet1'!A1*
>
> * *
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *ankur
> *Sent:* Tuesday, July 05, 2011 12:13 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ copy data without opening file
>
>  
>
> hi hanumant
>
> you may find this to be useful
>
> http://spreadsheetpage.com/index.php...a_closed_file/
> 
>
> [image: Image removed by sender. Reply With 
> Quote]
> 
>
>
> 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 Tue, Jul 5, 2011 at 12:40 AM, hanumant shinde 
> wrote:
>
> Hi friends,
>
> is there any way where we can copy data from closed workbook "A" and paste
> it
> into workbook "B" which is open?
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
>  
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> -- 
>
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
>
>
>
> -- 
>
> *Regards*
>
> * *
>
> *Ashish Koul*
>
> *akoul*.*blogspot*.com *
> http://akoul.posterous.com/*
>
> *akoul*.wordpress.com 
>
> My Linkedin Profile ***
> *
>
>  
>
> P Before printing, think about the environment.
>
>  
>
> ** **
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceld

Re $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING

[Rajan_Verma]

Use this In B2

 

=MID(SUBSTITUTE(TRIM(A2)," ","*",2),FIND("*",SUBSTITUTE(TRIM(A2),"
","*",2),1)+1,11)

 

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of MITTAL AJAY
Sent: Tuesday, July 05, 2011 2:07 PM
To: 'excel-macros@googlegroups.com'
Subject: $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING

 

I WANT TO EXTRACT  11 DIGIT NUMBER IN CLOUMN B.

 

Can anybody suggest a suitable formula ?

 

With Warm Regards,

 

CA. Ajay Mittal

Finance Manager

 

cid:image001.jpg@01CC1029.98246F90

Pipelines Division,

Noida - 201 301
Tel: 0120-2448312

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent: Tuesday, July 05, 2011 1:33 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ copy data without opening file

 

i suggest you hide the workbook from which you are copying the data if you
dont want to show it to the user 

 

 

http://akoul.blogspot.com/search/label/Hide%20and%20Unhide%20a%20workbook%20
in%20vba

 


 

On Tue, Jul 5, 2011 at 12:53 PM, Rajan_Verma 
wrote:

No, We cant Copy the data from Closed Workbook.. but we can get the Data by
Using Full Reference of cell .. Like

 

='C:\Users\Xl_Lover\Desktop\[ForDownload[Sheet1]]Sheet1'!A1

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ankur
Sent: Tuesday, July 05, 2011 12:13 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ copy data without opening file

 

hi hanumant

you may find this to be useful

http://spreadsheetpage.com/index.php...a_closed_file/
  

  Image
removed by sender. Reply With Quote


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 Tue, Jul 5, 2011 at 12:40 AM, hanumant shinde 
wrote:

Hi friends,

is there any way where we can copy data from closed workbook "A" and paste
it
into workbook "B" which is open?

--

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
 
4. Learn VBA Macros at http://www.quickvba.blogspot.com
 
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

 

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
 
4. Learn VBA Macros at http://www.quickvba.blogspot.com
 
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 


--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
 
4. Learn VBA Macros at http://www.quickvba.blogspot.com
 
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel




-- 

Regards

 

Ashish Koul

  akoul.blogspot.com
http://akoul.posterous.com/

  akoul.wordpress.com

My   Linkedin Profile

 

P Before printing, think about the environment.

 

 

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN gro

$$Excel-Macros$$ help me urgent

[vijayajith VA]

Hi,

I have  30 to 40 excel sheets in one workbook..if i want to copy all the
excel sheet data in one sheet . it takes time..

so is thr any macros for that .


Please help me

thanks in advance.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ help me urgent

[ashish koul]

try this

http://akoul.blogspot.com/search/label/Merge%20data%20from%20multiple%20sheets%20to%20sheet1%20in%20same%20workbook

On Tue, Jul 5, 2011 at 11:12 AM, vijayajith VA wrote:

> Hi,
>
> I have  30 to 40 excel sheets in one workbook..if i want to copy all the
> excel sheet data in one sheet . it takes time..
>
> so is thr any macros for that .
>
>
> Please help me
>
> thanks in advance.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING

[MITTAL AJAY]

I WANT TO EXTRACT  11 DIGIT NUMBER IN CLOUMN B.

Can anybody suggest a suitable formula ?

With Warm Regards,

CA. Ajay Mittal
Finance Manager

[cid:image001.jpg@01CC3B1C.C8978CC0]
Pipelines Division,
Noida - 201 301
Tel: 0120-2448312

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of ashish koul
Sent: Tuesday, July 05, 2011 1:33 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ copy data without opening file

i suggest you hide the workbook from which you are copying the data if you dont 
want to show it to the user


http://akoul.blogspot.com/search/label/Hide%20and%20Unhide%20a%20workbook%20in%20vba



On Tue, Jul 5, 2011 at 12:53 PM, Rajan_Verma 
mailto:rajanverma1...@gmail.com>> wrote:
No, We cant Copy the data from Closed Workbook.. but we can get the Data by 
Using Full Reference of cell .. Like

='C:\Users\Xl_Lover\Desktop\[ForDownload[Sheet1]]Sheet1'!A1


From: excel-macros@googlegroups.com 
[mailto:excel-macros@googlegroups.com] On 
Behalf Of ankur
Sent: Tuesday, July 05, 2011 12:13 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ copy data without opening file

hi hanumant

you may find this to be useful

http://spreadsheetpage.com/index.php...a_closed_file/
[cid:image002.jpg@01CC3B1C.C8978CC0]

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 Tue, Jul 5, 2011 at 12:40 AM, hanumant shinde 
mailto:arsfan2...@yahoo.co.in>> wrote:
Hi friends,

is there any way where we can copy data from closed workbook "A" and paste it
into workbook "B" which is open?

--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at 
http://www.excel-macros.blogspot.com
4. Learn VBA Macros at 
http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at 
http://exceldailytip.blogspot.com

To post to this group, send email to 
excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at 
http://www.excel-macros.blogspot.com
4. Learn VBA Macros at 
http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at 
http://exceldailytip.blogspot.com

To post to this group, send email to 
excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at 
http://www.excel-macros.blogspot.com
4. Learn VBA Macros at 
http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at 
http://exceldailytip.blogspot.com

To post to this group, send email to 
excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel



--
Regards

Ashish Koul
akoul.blogspot.com
http://akoul.posterous.com/
akoul.wordpress.com
My Linkedin Profile


P Before printing, think about the environment.


--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quick

Re: $$Excel-Macros$$ I want to learn VBA

[Kal xcel]

Very useful linkThanks to ALL

Kalyan

On Tue, Jul 5, 2011 at 1:30 PM, ashish koul  wrote:

>
> try this book
>
>
> http://www.recordexcelmacro.com/vebooks/RecordExcelMacrosthatWork.pdf
>
>
>
>
> On Tue, Jul 5, 2011 at 1:16 PM, Rajan_Verma wrote:
>
>>  * *
>>
>> http://excelpoweruser.blogspot.com/**
>>
>> * *
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI
>> *Sent:* Monday, July 04, 2011 4:00 PM
>>
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ I want to learn VBA
>>
>>   ** **
>>
>> PFA
>>
>>  
>>
>> -- 
>>
>> Thanks & regards,
>>
>> Noorain Ansari
>>
>> *http://noorain-ansari.blogspot.com/*
>> 
>>
>>
>>
>> 
>>
>> On Mon, Jul 4, 2011 at 2:33 PM, ankur  wrote:***
>> *
>>
>> one more
>>
>> 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 Mon, Jul 4, 2011 at 2:32 PM, ankur  wrote:
>> > some more files
>> > 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 Mon, Jul 4, 2011 at 12:17 PM, Anish Shrivastava 
>> wrote:
>> >> Basics of a macro for all beginners..
>> >>
>> >> On Sat, Jul 2, 2011 at 3:17 PM, ankur  wrote:
>> >>>
>> >>> hi kurikkal
>> >>> get files from the link below, i had uploaded there. i tried to
>> >>> attach files but due to excess size of files, it cant be attached .
>> >>>
>> >>> http://cmaankur.webs.com/apps/documents/
>> >>>
>> >>> 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, Jul 2, 2011 at 1:02 PM, ankur 
>> wrote:
>> >>> > hi kurikkal
>> >>> > have this file..
>> >>> > 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, Jul 2, 2011 at 12:54 PM, ankur 
>> wrote:
>> >>> >> hi kurikkal
>> >>> >> have this files...
>> >>> >> 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 Fri, Jul 1, 2011 at 9:24 PM, ashish koul > >
>> >>> >> wrote:
>> >>> >>> try thse video tutorial and websites
>> >>> >>> http://akoul.wordpress.com/2011/05/28/excel-video-tutorials/
>> >>> >>>
>> >>> >>>
>> http://akoul.wordpress.com/2011/05/27/excel-blogs-and-websites-learn-excel-online/
>> >>> >>>
>> >>> >>>
>> >>> >>> On Fri, Jul 1, 2011 at 1:34 PM, kurikkal padinjarappalla
>> >>> >>>  wrote:
>> >>> 
>> >>>  please attach it
>> >>> 
>> >>>  On Fri, Jul 1, 2011 at 10:43 AM, ankur 
>> >>>  wrote:
>> >>> >
>> >>> > Dear friends
>> >>> > I m agree that , the sites you all recommended are very useful
>> ,but
>> >>> > for a new user , the best way to learn VBA is getting a book
>> >>> > dedicated
>> >>> > on vba...becoz they provide step wise and detailed concepts 
>> >>> > there are many free ebooks on vba on the internet.download
>> it
>> >>> > ...learn basic from there ...and then make reference from this
>> sites
>> >>> > to learn more...
>> >>> > i have books if u need  i can attach here...
>> >>> >
>> >>> > 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 Fri, Jul 1, 2011 at 10:29 AM, Venkatesan c
>> >>> > 
>> >>> > wrote:
>> >>> > >
>> >>> > >
>> >>> > > Hi Pooja,
>> >>> > > Just watch the below link Youtube video's you may get VBA
>> >>> > > Basic&Advancedconcepts
>> >>> > > http://www.teachmsoffice.com/list-of-tutorials.php?src=tegb
>> >>> > >
>> >>> > > Best Regards,
>> >>> > > Venkat
>> >>> > >
>> >>> > > On Thu, Jun 30, 2011 at 10:32 PM, Pooja Sharma
>> >>> > > 
>> >>> > > wrote:
>> >>> > >>
>> >>> > >> Hi All,
>> >>> > >>
>> >>> > >> I want to learn VBA, therefore, could anybody suggest with a
>> good
>> >>> > >> link
>> >>> > >> where I can learn it.
>> >>> > >>
>> >>> > >> --
>> >>> > >> Best Regards
>> >>> > >> Pooja Sharma
>> >>> > >>
>> >>> > >> --
>> >>> > >>
>> >>> > >>
>> >>> > >>
>> >>> > >>
>> --
>> >>> > >> Some important links for excel users:
>> >>> > >> 1. Follow us on TWITTER for tips tricks and lin

Re: $$Excel-Macros$$ count unique values

[airen]

Thanks Haseeb and other Experts :)

Regards
Akhilesh Airen

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Need formula for Current Date Access

[Idhrees Mohamed]

Dear Friends,

I need a help to access query for current date.

I have an column with name valid date. I need a formula for validity date
less than current date, its shown "valid otherwise "expired" like that.
Please help me the ms access fuction for this.

-- 
Thanks & Regards,

Mohamed Idhrees. S.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Urgent Help required!!!!!!!!!!

[chandrabhushan prasad]

tri this

=round(a1,-3)

On Mon, Jul 4, 2011 at 9:31 PM, Dilip Pandey  wrote:

> Hi Anshul,
>
> As per the latest scenario provided by you, attached solution may help you.
> Let me know if this works :)
>
> Regards,
> DILIPandey
>
> On 7/4/11, Anshul Gupta  wrote:
> > Hi All
> >
> > No boss this is also not working see i show you what excatly i want
> >
> > 202.718
> > 198.724
> > 200.178
> > 202.867
> > 195.514
> > Total 1000.000
> >
> > this is i want that random unique numbers between 195.001 to 203.999
> which
> > always gives a total of 1000.000 after every total of 5 numbers
> >
> > Help me guy
> >
> > cheers!!!
> > On Sun, Jul 3, 2011 at 12:40 PM, Rajan_Verma
> > wrote:
> >
> >>  *See if it help*
> >>
> >> http://www.mrexcel.com/tip069.shtml
> >>
> >> ** **
> >>
> >> * *
> >>
> >> * *
> >>
> >> *From:* excel-macros@googlegroups.com [mailto:
> >> excel-macros@googlegroups.com] *On Behalf Of *karunanithi ramaswamy
> >> *Sent:* Saturday, July 02, 2011 9:29 PM
> >>
> >> *To:* excel-macros@googlegroups.com
> >>  *Subject:* RE: $$Excel-Macros$$ Urgent Help required!!
> >>
> >>   ** **
> >>
> >> Sir,
> >>   Do u have any idea of auto filling magic squre for a particular sum
> >> total.  Iam interested
> >> to know it. Thanks if u could help.
> >>-R.Karunanithi
> >>
> >> --- On *Sat, 7/2/11, Rajan_Verma * wrote:
> >>
> >>
> >> From: Rajan_Verma 
> >> Subject: RE: $$Excel-Macros$$ Urgent Help required!!
> >> To: excel-macros@googlegroups.com
> >> Date: Saturday, July 2, 2011, 8:25 PM
> >>
> >> *See if it helps*
> >>
> >> * *
> >>
> >> *From:* excel-macros@googlegroups.com [mailto:
> >> excel-macros@googlegroups.com] *On Behalf Of *Anshul Gupta
> >> *Sent:* Saturday, July 02, 2011 7:39 PM
> >> *To:* excel-macros@googlegroups.com
> >> *Subject:* $$Excel-Macros$$ Urgent Help required!!
> >>
> >>  
> >>
> >> Hi All.
> >>
> >> As m working in a import house for that i have to sales bills on daily
> >> basis i just want a help that makes me easy to make that
> >>
> >> If someone tell that how to make 5 random numbers selection between
> >> 197.001
> >> to 203.999 which gives the total of 1000.000
> >>
> >> Please help meurgent guys
> >>
> >> Cheers 
> >>
> >> --
> >>
> >>
> --
> >> Some important links for excel users:
> >> 1. Follow us on TWITTER for tips tricks and links :
> >> http://twitter.com/exceldailytip
> >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> >> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >>
> >> To post to this group, send email to excel-macros@googlegroups.com
> >>
> >> <><><><><><><><><><><><><><><><><><><><><><>
> >> Like our page on facebook , Just follow below link
> >> http://www.facebook.com/discussexcel
> >>
> >> --
> >>
> >>
> --
> >> Some important links for excel users:
> >> 1. Follow us on TWITTER for tips tricks and links :
> >> http://twitter.com/exceldailytip
> >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> >> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >>
> >> To post to this group, send email to excel-macros@googlegroups.com
> >>
> >> <><><><><><><><><><><><><><><><><><><><><><>
> >> Like our page on facebook , Just follow below link
> >> http://www.facebook.com/discussexcel
> >>
> >> --
> >>
> >>
> --
> >> Some important links for excel users:
> >> 1. Follow us on TWITTER for tips tricks and links :
> >> http://twitter.com/exceldailytip
> >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> >> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >>
> >> To post to this group, send email to excel-macros@googlegroups.com
> >>
> >> <><><><><><><><><><><><><><><><><><><><><><>
> >> Like our page on facebook , Just follow below link
> >> http://www.facebook.com/discussexcel
> >>
> >> --
> >>
> >>
> --
> >> Some important links for excel users:
> >> 1. Follow us on TWITTER for tips tricks and links :
> >> http://twitter.com/exceldailytip
> >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> >> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> >> 5. Excel Tips and T

Re: $$Excel-Macros$$ Recovery plz

[Chandra Shekar]

Thanks a lot its working fine. :)

On Mon, Jul 4, 2011 at 4:46 PM, Venkatesan c  wrote:

> Hi
>
> just install the  software and just open that software and click Remove
> Password...Before that you have to open
>
> Locked VBA Book..
>
> --
> *Best Regards,*
> *Venkat*
> *
> *
>   On Mon, Jul 4, 2011 at 6:32 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>>   How to use this software?
>>
>> Thanks,
>>
>> Chandra Shekar B
>>
>>   On Fri, Dec 24, 2010 at 11:56 AM, Venkat  wrote:
>>
>>> Dear Saijt,
>>>
>>> Find below Link&Download Software &Install,It may Help you...
>>>
>>> http://www.excel-tool.com/vbarecovery.html
>>>
>>> *Best Regards,*
>>> **
>>> *Venkat CV*
>>>
>>> On Thu, Dec 23, 2010 at 12:42 PM, Vikas Chouhan wrote:
>>>
 send ur file

 On Tue, Dec 21, 2010 at 10:45 PM, SAJID MEMON 
 wrote:

> Dear All,
>
> I had made a project in excel and some macro made but i had protected
> with password and forget the password.
> How can i recover my VBA password.
>
> please give me some tips to accomplish my project.
>
> sajid memon
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @
> http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
>
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>



 --
 One Team One Dream One Goal

 Warm Regards,
 *Vikas Chauhan*
 E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
 9911868518,
 "We can't Spell S_*ccess *without U"

 Life is Very beautiful !!!
 ¨`•.•´¨) Always
 `•.¸(¨`•.•´¨) Keep
 (¨`•.•´¨)¸.•´ Smiling!
 `•.¸.•´.

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 <><><><><><><><><><><><><><><><><><><><><><>
 Like our page on facebook , Just follow below link

 http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

>>>
>>>
>>>
>>> --
>>> *Best Regards,*
>>> *Venkat*
>>> ) 91 99414 31925
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>>
>>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> *
> *
> *
> *
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blo

Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - June'11

[Kal xcel]

Congratulation Ashish...You deserve it

Kalyan


On Mon, Jul 4, 2011 at 11:17 PM, Ahmed galal  wrote:

>  [image:
> http://tracking.technodesignip.com/?action=count&projectid=642&contentid=6543&referrer=-&urlaction=r...]Congratulations
> *Ashish*, you deserve it.[image:
> http://tracking.technodesignip.com/?action=count&projectid=642&contentid=6548&referrer=-&urlaction=r...]
>
>
> Best regards,
>
>
>
> *Ahmed galal Mohamed*
>
> Procurement Engineer
>
> Head Office : SQUARE Engineering Firm
> Tel   :(202) 2402 8846
> Fax  :(202) 2405 0476
> Mobile :(010) 9 62 60 61
> Website : http://www.square.com.eg
> 31 Lebanon St. Mohandsen, Giza, Egypt
>
>
>
>
>
>  --
> From: jainayus...@gmail.com
> Date: Mon, 4 Jul 2011 22:48:33 +0530
> Subject: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - June'11
> To: excel-macros@googlegroups.com
>
>
>   Hello Everyone,
>
> Ashish Koul has been selected as 'Most Helpful Member' for the month of
> June'11
> He has posted 53 posts in June 2011 and helped many people through his
> expertise. He has been consistent contributor to this excel forum and
> achieved this recognition from last seven months consecutively.This is
> really awesome. He is awarded Microsoft MVP 2011 award for his voluntary
> contribution.
>
>
>Thanks to Rajan, Venkat and other folks for helping excel enthusiasts !!
> keep it up !!
>
>Let see who becomes next MVP..
>
>Keep posting.
>
>
>  Regards
> Ayush Jain
> Group Manager
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ workbook location on status bar

[Venkatesan c]

Pascal,

Yes  you are right

I have said for 2007 &2010 Version...


*Best Regards,*
*Venkat*
*
*

On Tue, Jul 5, 2011 at 4:05 AM, netuser501  wrote:

> thanx,
>
> Venkat solution is most practical for 2007 since it works on all
> workbooks that work and don't work with vba code.
> I guess the vba code for this is for Excel 2003?
>
> Pascal
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ copy data without opening file

[Venkatesan c]

Hi,

Just Try Copy &Paste it will work...

*Best Regards,*
*Venkat*
*
*

On Tue, Jul 5, 2011 at 12:40 AM, hanumant shinde wrote:

> Hi friends,
>
> is there any way where we can copy data from closed workbook "A" and paste
> it
> into workbook "B" which is open?
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ copy data without opening file

[ashish koul]

i suggest you hide the workbook from which you are copying the data if you
dont want to show it to the user


http://akoul.blogspot.com/search/label/Hide%20and%20Unhide%20a%20workbook%20in%20vba



On Tue, Jul 5, 2011 at 12:53 PM, Rajan_Verma wrote:

>  *No, We cant Copy the data from Closed Workbook.. but we can get the Data
> by Using Full Reference of cell .. Like*
>
> * *
>
> *='C:\Users\Xl_Lover\Desktop\[ForDownload[Sheet1]]Sheet1'!A1*
>
> * *
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *ankur
> *Sent:* Tuesday, July 05, 2011 12:13 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ copy data without opening file
>
> ** **
>
> hi hanumant
>
> you may find this to be useful
>
> http://spreadsheetpage.com/index.php...a_closed_file/
> 
>
> [image: Image removed by sender. Reply With 
> Quote]
> 
>
>
> 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 Tue, Jul 5, 2011 at 12:40 AM, hanumant shinde 
> wrote:
>
> Hi friends,
>
> is there any way where we can copy data from closed workbook "A" and paste
> it
> into workbook "B" which is open?
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> ** **
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
<<~WRD000.jpg>>

Re: $$Excel-Macros$$ I want to learn VBA

[ashish koul]

try this book


http://www.recordexcelmacro.com/vebooks/RecordExcelMacrosthatWork.pdf




On Tue, Jul 5, 2011 at 1:16 PM, Rajan_Verma wrote:

>  * *
>
> http://excelpoweruser.blogspot.com/**
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI
> *Sent:* Monday, July 04, 2011 4:00 PM
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ I want to learn VBA
>
>   ** **
>
> PFA
>
>  
>
> -- 
>
> Thanks & regards,
>
> Noorain Ansari
>
> *http://noorain-ansari.blogspot.com/*
> 
>
>
>
> 
>
> On Mon, Jul 4, 2011 at 2:33 PM, ankur  wrote:
>
> one more
>
> 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 Mon, Jul 4, 2011 at 2:32 PM, ankur  wrote:
> > some more files
> > 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 Mon, Jul 4, 2011 at 12:17 PM, Anish Shrivastava 
> wrote:
> >> Basics of a macro for all beginners..
> >>
> >> On Sat, Jul 2, 2011 at 3:17 PM, ankur  wrote:
> >>>
> >>> hi kurikkal
> >>> get files from the link below, i had uploaded there. i tried to
> >>> attach files but due to excess size of files, it cant be attached .
> >>>
> >>> http://cmaankur.webs.com/apps/documents/
> >>>
> >>> 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, Jul 2, 2011 at 1:02 PM, ankur  wrote:
> >>> > hi kurikkal
> >>> > have this file..
> >>> > 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, Jul 2, 2011 at 12:54 PM, ankur 
> wrote:
> >>> >> hi kurikkal
> >>> >> have this files...
> >>> >> 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 Fri, Jul 1, 2011 at 9:24 PM, ashish koul 
> >>> >> wrote:
> >>> >>> try thse video tutorial and websites
> >>> >>> http://akoul.wordpress.com/2011/05/28/excel-video-tutorials/
> >>> >>>
> >>> >>>
> http://akoul.wordpress.com/2011/05/27/excel-blogs-and-websites-learn-excel-online/
> >>> >>>
> >>> >>>
> >>> >>> On Fri, Jul 1, 2011 at 1:34 PM, kurikkal padinjarappalla
> >>> >>>  wrote:
> >>> 
> >>>  please attach it
> >>> 
> >>>  On Fri, Jul 1, 2011 at 10:43 AM, ankur 
> >>>  wrote:
> >>> >
> >>> > Dear friends
> >>> > I m agree that , the sites you all recommended are very useful
> ,but
> >>> > for a new user , the best way to learn VBA is getting a book
> >>> > dedicated
> >>> > on vba...becoz they provide step wise and detailed concepts 
> >>> > there are many free ebooks on vba on the internet.download it
> >>> > ...learn basic from there ...and then make reference from this
> sites
> >>> > to learn more...
> >>> > i have books if u need  i can attach here...
> >>> >
> >>> > 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 Fri, Jul 1, 2011 at 10:29 AM, Venkatesan c
> >>> > 
> >>> > wrote:
> >>> > >
> >>> > >
> >>> > > Hi Pooja,
> >>> > > Just watch the below link Youtube video's you may get VBA
> >>> > > Basic&Advancedconcepts
> >>> > > http://www.teachmsoffice.com/list-of-tutorials.php?src=tegb
> >>> > >
> >>> > > Best Regards,
> >>> > > Venkat
> >>> > >
> >>> > > On Thu, Jun 30, 2011 at 10:32 PM, Pooja Sharma
> >>> > > 
> >>> > > wrote:
> >>> > >>
> >>> > >> Hi All,
> >>> > >>
> >>> > >> I want to learn VBA, therefore, could anybody suggest with a
> good
> >>> > >> link
> >>> > >> where I can learn it.
> >>> > >>
> >>> > >> --
> >>> > >> Best Regards
> >>> > >> Pooja Sharma
> >>> > >>
> >>> > >> --
> >>> > >>
> >>> > >>
> >>> > >>
> >>> > >>
> --
> >>> > >> Some important links for excel users:
> >>> > >> 1. Follow us on TWITTER for tips tricks and links :
> >>> > >> http://twitter.com/exceldailytip
> >>> > >> 2. Join our LinkedIN group @
> >>> > >> http://www.linkedin.com/groups?gid=1871310
> >>> > >> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> >>> > >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> >>> > >> 5. E

RE: $$Excel-Macros$$ copy data without opening file

[Rajan_Verma]

No, We cant Copy the data from Closed Workbook.. but we can get the Data by
Using Full Reference of cell .. Like

 

='C:\Users\Xl_Lover\Desktop\[ForDownload[Sheet1]]Sheet1'!A1

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ankur
Sent: Tuesday, July 05, 2011 12:13 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ copy data without opening file

 

hi hanumant

you may find this to be useful

http://spreadsheetpage.com/index.php...a_closed_file/
  

  Image
removed by sender. Reply With Quote


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 Tue, Jul 5, 2011 at 12:40 AM, hanumant shinde 
wrote:

Hi friends,

is there any way where we can copy data from closed workbook "A" and paste
it
into workbook "B" which is open?

--

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

 

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
<<~WRD000.jpg>>