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

*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

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

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

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

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

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

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 f

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

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

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

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

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

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://twitt

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

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,

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

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 colu

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

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

$$Excel-Macros$$ Help for Excel query

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

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

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

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

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

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

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 >

$$Excel-Macros$$ Help Urgent Please

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 >

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

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

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

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 P

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

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

$$Excel-Macros$$ Help Urgent Please

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

Re: $$Excel-Macros$$

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 a

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

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

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

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 TWITT

$$Excel-Macros$$

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 suppor

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

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 ne

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

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

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

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

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

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

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

*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

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

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).Va

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

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

$$Excel-Macros$$ Mail Merge Regarding

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

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

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

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

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,

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

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:

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

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, J

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

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 :

$$Excel-Macros$$ macro for copy down

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

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

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,

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

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. > > ** *

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

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=c

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

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

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.Sele

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

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

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: $$E

$$Excel-Macros$$ help me urgent

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

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 .

$$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@01CC3B1C.C8978CC0] Pipelines Division, Noida - 201 301 Tel: 0120-2448312 From: excel-macros@googlegroups.com [mailto:excel-macros@google

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

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://excelpoweruse

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

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 @

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

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

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

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

Re: $$Excel-Macros$$ Recovery plz

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, 20

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

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://trackin

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

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

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

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

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 Workbo

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

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 *N

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

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 0