Re: $$Excel-Macros$$ Re: Hi Anoop

No prob bro... On Fri, May 3, 2013 at 12:20 PM, Mathan wrote: > Hi Anoop, > > Just wanted to let you know the result of implementation of your effort. > It saved 35 Hours per month.. :-) > > Thanks again ! > > Mathan > > > > > On Thu, May 2, 2013 at 12:47 PM, Mathan wrote: > >> Hi Anoop,

Re: $$Excel-Macros$$ Re: Hi Anoop

Hi Anoop, Just wanted to let you know the result of implementation of your effort. It saved 35 Hours per month.. :-) Thanks again ! Mathan On Thu, May 2, 2013 at 12:47 PM, Mathan wrote: > Hi Anoop, > > It's working fine. Thanks a lot ! :-) > > Your dedication is much appreciated ! >

Re: $$Excel-Macros$$ Re: Hi Anoop

Hi Anoop, It's working fine. Thanks a lot ! :-) Your dedication is much appreciated ! Regards, Mathan On Thu, May 2, 2013 at 8:58 AM, Anoop K Sharma wrote: > Try this... You can change code as per your requirement. > > Regards, > Anoop > > > On Wed, May 1, 2013 at 12:25 PM, Mathan wrote: > >

Re: $$Excel-Macros$$ Re: Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF & .htm

file attached with modifications disadvantages is that it will ask to attach for every row as an attachments. Regards, Anil Gawli On Mon, May 21, 2012 at 5:44 PM, Anil Gawli wrote: > File attached for ur Reference. > > > On Mon, May 21, 2012 at 5:25 PM, renuka chari wrote: > >> Hi All >> >> Ac

Re: $$Excel-Macros$$ Re: Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF & .htm

File attached for ur Reference. On Mon, May 21, 2012 at 5:25 PM, renuka chari wrote: > Hi All > > Actually i need Export ladger data from tally in ".htm" format exported > data saved in one perticular folder, then i need to send each individual > file willbe sending to the individual receipitent

$$Excel-Macros$$ Re: Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF & .htm

Hi All Actually i need Export ladger data from tally in ".htm" format exported data saved in one perticular folder, then i need to send each individual file willbe sending to the individual receipitent Ex: "xyz.htm file wilbe sending to the xyz customer and "xyz2.htm" file will be sending to t

RE: $$Excel-Macros$$ Re: Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF & .htm

@googlegroups.com Subject: $$Excel-Macros$$ Re: Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF & .htm Hi rajan thanks for ur replay but i need not like that 2 payslips are sending to 2 employees individually in at a time

Re: $$Excel-Macros$$ Re: Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF & .htm

http://www.4tops.com/mailmergeemailpdf.htm     From: LAKSHMAN PRASAD To: "excel-macros@googlegroups.com" Sent: Saturday, May 19, 2012 5:23 PM Subject: Re: $$Excel-Macros$$ Re: Hi all Experts Cna u share a Macro for outlook emails sending Specific Te

Re: $$Excel-Macros$$ Re: Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF & .htm

http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm       From: LAKSHMAN PRASAD To: "excel-macros@googlegroups.com" Sent: Saturday, May 19, 2012 5:32 PM Subject: Re: $$Excel-Macros$$ Re: Hi all Experts Cna u share a Macro for outlook emai

Re: $$Excel-Macros$$ Re: Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF & .htm

If you want With Attachments formats of word and html it would be possible.         From: LAKSHMAN PRASAD To: "excel-macros@googlegroups.com" Sent: Saturday, May 19, 2012 5:23 PM Subject: Re: $$Excel-Macros$$ Re: Hi all Experts Cna u share a

Re: $$Excel-Macros$$ Re: Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF & .htm

If you want With Attachments formats of word it would be possible.         From: renuka chari To: excel-macros@googlegroups.com Sent: Saturday, May 19, 2012 4:57 PM Subject: $$Excel-Macros$$ Re: Hi all Experts Cna u share a Macro for outlook emails sending

$$Excel-Macros$$ Re: Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF & .htm

Hi rajan thanks for ur replay but i need not like that 2 payslips are sending to 2 employees individually in at a time how is it possible? On Thursday, 17 May 2012 17:24:23 UTC+5:30, renuka chari wrote: > > Dear experts > > Excel macro for sendin outlook emails from Specific Temp

RE: $$Excel-Macros$$ Re: Hi friends, I want to know

acros@googlegroups.com] On Behalf Of anil kumar Sent: Monday, April 30, 2012 12:05 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Hi friends, I want to know I exprot data from busy in 5 workbook. and now i open 1 workbook wnat to copy other 4 workbook data in open wor

Re: $$Excel-Macros$$ Re: Hi friends, I want to know

m: anil kumar Sent: Monday, April 30, 2012 6:58 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Hi friends, I want to know Hello sir, How r u, there is no need of sample sheet, simply u have 4-5 workbook of any data. and now u have to copy all data from 4-5 workbook. than we

Re: $$Excel-Macros$$ Re: Hi friends, I want to know

Hello sir, How r u, there is no need of sample sheet, simply u have 4-5 workbook of any data. and now u have to copy all data from 4-5 workbook. than we have to open 1 by 1 workbook and copy in 1 sheet. now i want to know that can i open 1 sheet from that 4-5 workbook copy all data in 1 sheet.

Re: $$Excel-Macros$$ Re: Hi friends, I want to know

Hi Anil,   can u share sample sheet with example.     Regards LAKSHMAN From: anil kumar To: excel-macros@googlegroups.com Sent: Monday, April 30, 2012 12:35 PM Subject: Re: $$Excel-Macros$$ Re: Hi friends, I want to know I exprot data from busy in 5 workbook

Re: $$Excel-Macros$$ Re: Hi friends, I want to know

I exprot data from busy in 5 workbook. and now i open 1 workbook wnat to copy other 4 workbook data in open workbook -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code

RE: $$Excel-Macros$$ Re: Hi friends, I want to know

hole table of data (by default uses ODBC that someone else mentioned, in the background, but not VBA). Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of anil kumar Sent: Sunday, April 29, 2012 10:21 PM To: excel-macros@googlegroups.com Subject: Re: $$

Re: $$Excel-Macros$$ Re: Hi friends, I want to know

Hello sir, First of all thanks, secondly I don't know vba so can't use it. is excel have any formula. plz tell me. Thanks & Regards Anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Hel

$$Excel-Macros$$ Re: Hi friends, I want to know

Try this link and change the code accordingly. http://www.excelfox.com/forum/f13/excel-excel-data-transfer-without-opening-any-files-source-target-339/ On Sunday, 29 April 2012 02:05:34 UTC+5:30, excelGeek wrote: > > Dear Anil, > > Yes it is possible by using odbc connection with the workbook a

$$Excel-Macros$$ Re: Hi friends, I want to know

Dear Anil, Yes it is possible by using odbc connection with the workbook and query to copy the data from source to destination where source is your 5 workbook and the destination is your sheet where you want to paste the data. Regards Lalit Mohan On Saturday, 28 April 2012 14:04:43 UTC+5:30, a

$$Excel-Macros$$ Re: Hi everyone,

HI following link will solve your issue http://ubitmenu.en.softonic.com/ Take care self and other Regards Hemal -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Pr

Re: $$Excel-Macros$$ Re: hi can you solve this

hi maries thank you very much On Dec 9, 5:12 pm, Maries wrote: > Hi, > > Find the attached file. > > Regards, > > MARIES. > > On Fri, Dec 9, 2011 at 12:55 PM, Renukachari Kasee wrote: > > > > > hi thanks for you valuble replay > > > but i need like this can you see this attachment > > > On 8 Dec

Re: $$Excel-Macros$$ Re: hi can you solve this

Hi, Find the attached file. Regards, MARIES. On Fri, Dec 9, 2011 at 12:55 PM, Renukachari Kasee wrote: > hi thanks for you valuble replay > > but i need like this can you see this attachment > > > > On 8 December 2011 18:56, Renukachari Kasee wrote: > >> >> *(¨`•.•´¨) Always >> `•.¸(¨`•.•´¨)

$$Excel-Macros$$ Re: hi can you solve this

hi thanks for you valuble replay but i need like this can you see this attachment On 8 December 2011 18:56, Renukachari Kasee wrote: > > *(¨`•.•´¨) Always > `•.¸(¨`•.•´¨) Keep > (¨`•.•´¨)¸.•´ Smiling!! > `•.¸.•´ > Thanks & Regards´¨) > ¸ •´ ¸.•*´¨) ¸.•*¨) > (¸.•´ (¸.•* ♥♥♥...♪♪

Re: $$Excel-Macros$$ Re: hi experts solve this problem

13500 13300 13100 12900 12700 12500 12300 Don Guillett SalesAid Software dguille...@gmail.com From: Renukachari Kasee Sent: Tuesday, December 06, 2011 2:30 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: hi experts solve this

$$Excel-Macros$$ Re: hi experts solve this problem

sorry Don Guillett its working good but chart was not shown ur done good work once i will check this Code and inform you soon thanks On Dec 6, 1:30 pm, Renukachari Kasee wrote: > hi > Don Guillett > thanks for your response > > once check this file > > here max is 14000 then this macro was not w

Re: $$Excel-Macros$$ Re: Hi

Hi Mudit, See Below Links http://www.excel-vba.com/ http://www.ozgrid.com/VBA/ http://www.exceltip.com/book-1931841047.html http://www.cpearson.com/excel/Downloads.aspx http://www.contextures.com/tiptech.html *Best Regards,* *Venkat * *Chennai* *My Linked in profile

$$Excel-Macros$$ Re: Hi

Please help me. On Tue, Sep 6, 2011 at 10:37 AM, Mudit Gandhi wrote: > Hi group > > I am beginner at macro so i want a pdf tutorials in which i could get all > the formulaes used in macro with examples. > > Thanks for ur help > Mudit > -- ---

Re: $$Excel-Macros$$ Re: Hi Experts help needed for stock entry

hi Ashish First of all thaks.I tried your code but the color code index is not working well,after the macro2() running it fails to set color code index property, how can i solve it. Regards Rajesh kainikkara On 11/17/10, OpenExcel.com wrote: > Hi Rajesh, > > I modified your code. You may try thes

$$Excel-Macros$$ Re: Hi Experts help needed for stock entry

Hi Rajesh, I modified your code. You may try these codes: For Sheet1: Event Macro Private Sub Worksheet_SelectionChange(ByVal Target As Range) Application.EnableEvents = False Columns(3).Interior.ColorIndex = xlNone Cells(ActiveCell.Row, 3).Interior.Color = vbYellow Applica

$$Excel-Macros$$ Re: Hi....

Hi Sasikanth, This is very wonderful. There are so many websites available to give you a start. Buy some good Microsoft Press books: http://www.excelitems.com/2009/03/free-e-book-on-vba-and-vsto-macros-and.html Also subscribe us on Facebook and twitter for regular tips and updates: Facebook - ht

$$Excel-Macros$$ Re: Hi guys I need your help again.

Hi, why not using Keyboar-ShortCut: Ctrl + PgUp and Ctrl+PgDown Regards, siti On 23 Agu, 21:21, shariqcoo...@gmail.com wrote: > Hi, > Can any one tell me how we can link the macro code to hyperlink. > I want to navigate the sheet by click the next or previous by using > Activesheet.next.sel

$$Excel-Macros$$ Re: Hi guys I need your help again.

Alternate proposal Instead of creating the links in each sheet dynamically, I think it is easy to create a customised toolbar with two buttons for your purpose, which can be used on any sheet, that is active. Regards, Kishan Reddy, K On Aug 23, 7:21 pm, shariqcoo...@gmail.com wrote: > Hi, > > C

$$Excel-Macros$$ Re: Hi, need your help - urgent

Hi Thanks for the help, In this I want that if the user can increase or decrease the size of the image, it will change, but next time when the image gets loaded it should have its original dimensions, the image should live within the cell, should not go beyond the cell's dimensions. Regards Raje

$$Excel-Macros$$ Re: Hi!!!!!!!!! to all Member

I also faced the same issue, As of now, if i need to reply to a post, i copy the subject of the post and then set it as a subject of my email to the group, and within that email i attach the files(if any) If there is any other way to attach files to the replies, please let us know Harry On May

$$Excel-Macros$$ Re: hi sir please help (Getting range reference from user)

Dear Ashish, Below is the modified code. Just a little modification in your existing code and it is working fine. Sub Macro1() i = Application.InputBox("enter range") ' If you want to select A2:B5 then enter as A2:B5 Dim As Range Set = ActiveSheet.Range(i) Sheet1.Activate ActiveShe

$$Excel-Macros$$ Re: hi all backup code

This code will definetly serve your purpose. Use Location = "E:\abdc" Filename = "MyFile_Backup_" & Format(Now(),"YY-MM-DD HH:MM:SS") & ".xls" Thisworkbook.SaveCopyAs (Location & Filename) Please note that I have not use "SaveAs " You can this code and see what is the difference between the

$$Excel-Macros$$ Re: hi all backup code

First of all, Excel already has an AutoRecover feature that saves the file every X minutes to a separate location... but I don't like it either. What do you mean by "automatically"? for instance,  I have a "save event" that does a "SaveCopyAs" like: Option Explicit Private Sub Workbook_BeforeS

$$Excel-Macros$$ Re: hi all backup code

*This would help..* ActiveWorkbook.SaveAs "c:\Backup_ManageAPP.xls" Thanks & Regards, Harmeet Singh Sent via BlackBerry Wireless On Tue, Sep 15, 2009 at 9:37 PM, ashish koul wrote: > hi > > > i need a code which will automatically create a backup of my file at the > location i speci

$$Excel-Macros$$ Re: hi to know what exactly i wanted to do added the sheet

Hi Umesh, Try below link. Thanks. Can't access your account?

$$Excel-Macros$$ Re: hi to know what exactly i wanted to do added the sheet

HI DILIP I HAVE A PROBLEM REGARDING FORGETTING MY GMAIL PASSWORD HOW CAN RECALL AND ALSO PASSWORD SAVE IN MY CPMPUTER SO I CAN OPEN MAIL BUT I DON'T WHAT IS MY PASSWORD --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: hi to know what exactly i wanted to do added the sheet

You are always welcome..!! -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 9/13/09, ashish koul wrote: > > thanks a lot brother > > On Sun, Sep 13, 2009 at 4:51 PM, Dilip Pandey wrote: > >> Hi Ashish, >> >>

$$Excel-Macros$$ Re: hi to know what exactly i wanted to do added the sheet

Hi Ashish, I did not find any macro in the file which you have provided and morevoer I am using Excel 2003 because of which I am facing little difficulties. But your problem is solved and attached in this email (offcourse it is in Excel 2003 format). Thanks. -- DILIP KUMAR PANDEY MBA-HR,B CO

$$Excel-Macros$$ Re: hi daniel i was trying this code also but it is showing some errors can u check plzzzzzzzz

Your code works fine, just put : If Asc(UCase(Right(c.Value, 1))) <= 64 Or Asc(UCase(Right(c.Value, 1))) >= 91 Then Instead of : If Asc UCase(Right(c.Value,1)) <= 64 OR Asc UCase(Right(c.Value,1)) >=91 Then Regards. Daniel From: excel-macros@googlegroups.com [mailto:excel-ma

$$Excel-Macros$$ Re: hi thanks for the help

Hi, See attached file. Select the range of mail addresses and execute the "test" macro. HTH Daniel From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of ashish koul Sent: lundi 7 septembre 2009 08:05 To: excel-macros@googlegroups.com Subject: $$Exce

$$Excel-Macros$$ Re: hi thanks for the help

*Sorry, attached wrong file**try the attached file.* On Mon, Sep 7, 2009 at 2:27 PM, Harmeet Singh wrote: > Just added some lines to Daniel's code. > See attached file... > > > On Mon, Sep 7, 2009 at 11:34 AM, ashish koul wrote: > >> hi >> >> can you please give ma co

$$Excel-Macros$$ Re: hi thanks for the help

Just added some lines to Daniel's code. See attached file... On Mon, Sep 7, 2009 at 11:34 AM, ashish koul wrote: > hi > > can you please give ma codes which will remove the unwated or_ at the > end of emailds in attachment > > > thanks > > ashish > > > > > -- Thanks & Regards, H

$$Excel-Macros$$ Re: Hi My All Friends Urgent

Thanks On Fri, Aug 28, 2009 at 6:54 PM, Aindril De wrote: > Hi Amresh, > > This can be achieved doing the following steps: > > 1) Select the entire sheet. > 2) Right Click on the selected area and select Format Cells. > 3) In the format cells dialog box choose the Protection Tab. > 4) Click on t

$$Excel-Macros$$ Re: Hi My All Friends Urgent

Hi Amresh, This can be achieved doing the following steps: 1) Select the entire sheet. 2) Right Click on the selected area and select Format Cells. 3) In the format cells dialog box choose the Protection Tab. 4) Click on the Locked and uncheck it. 5) Click OK. 6) Now select the cell that you want

$$Excel-Macros$$ Re: Hi Frnd Plz Help

Hello, This is the formula you would use in your results cell: =COUNTIFS(A1:A6,$B$8,A1:A6,$C$8) Where A1:A6 is you range of 24,35,36,38,37,48,42 and $B$8 & $C$8 are your criteria parameters. You can have a number if nested criterias in the COUNTIFS function. Regards.

$$Excel-Macros$$ Re: Hi Frnd Plz Solve This Pro

Thanks Dilip Kumar Aamir Shahzad - Original Message - From: Dilip Pandey To: excel-macros@googlegroups.com Sent: Wednesday, July 29, 2009 3:50 PM Subject: $$Excel-Macros$$ Re: Hi Frnd Plz Solve This Pro Hi Aamir, After "O" column, other columns are hidden ti

$$Excel-Macros$$ Re: Hi Frnd Plz Solve This Pro

Hi Anil, Select entire sheet and then go to format->Columns->Width and enter 8 and press Enter. You will see all columns. Columns are not hidden but their width have made to be 0. Regards, Upendra Singh +91-9910227325, +91-9310760597 -

$$Excel-Macros$$ Re: Hi Frnd Plz Solve This Pro

zad > > - Original Message - > *From:* Dilip Pandey > *To:* excel-macros@googlegroups.com > *Sent:* Monday, July 27, 2009 3:15 PM > *Subject:* $$Excel-Macros$$ Re: Hi Frnd Plz Solve This Pro > > Hi Anil, > > The last column is formatted now and workbook is attached h

$$Excel-Macros$$ Re: hi

Dear Ashwani, Please find attached the solution. Please let me know if you need any further help on this. Regards, Andy On Wed, Jul 29, 2009 at 10:11 AM, Ash Singh wrote: > Hi All, > > Please find attached the excel sheet with problem statement. > > > > -- > Regards, > Ashwani Singh > > > > -

$$Excel-Macros$$ Re: Hi Frnd Plz Solve This Pro

Dear Delip Kumar, Can you tell me after "O" column how other columns are disabled. And I disable rows. Regards, Aamir Shahzad - Original Message - From: Dilip Pandey To: excel-macros@googlegroups.com Sent: Monday, July 27, 2009 3:15 PM Subject: $$Excel-Macros$$ R

$$Excel-Macros$$ Re: HI !!!!!!!!All Need Urgent help!!!!!!!!!!!!!!!!!!!

That sounds like a nice problem for the solver add-in. all linear constraints. That will tell you if its possible or not. I dont think a macro is needed? On Jun 24, 11:51 am, Abdul Rehman wrote: > Hi All, > > Is it possible to program a excel sheet to schedule 4 call center agents > working i

$$Excel-Macros$$ Re: Hi Urgent Excel help required.!!!!!!!! URGENT!!!!!!!!!!!!!!!!!

heading.   Regards, Shahina --- On Sat, 5/23/09, msakibkhan wrote: From: msakibkhan Subject: $$Excel-Macros$$ Re: Hi Urgent Excel help required. To: "MS EXCEL AND VBA MACROS" Date: Saturday, May 23, 2009, 3:29 PM Yea I think it's a better solution, but Shahina want to copy on

$$Excel-Macros$$ Re: hi

Dear Harmeet Found your solution very simple and to the point... Thank u very much On Tue, Jun 2, 2009 at 8:19 PM, Harmeet Singh wrote: > Wat about my solution, its the shortest > > see attached file > > On Fri, May 29, 2009 at 2:47 PM, satish wrote: > >> Hey People >> I need a small

$$Excel-Macros$$ Re: hi

Wat about my solution, its the shortest see attached file On Fri, May 29, 2009 at 2:47 PM, satish wrote: > Hey People > I need a small help, some of you might even find silly > > I have big list of 12 to 16 digit Numbers e.g., 15145745854501. First i > want to convert all the number to 16 d

$$Excel-Macros$$ Re: hi

Try rhis formula to get the 16 digit number. CELL B2 :- =TEXT(A2,REPT("0",16)) Then these to get the 4-digit and 12 digit parts. =LEFT(B2, 4) =RIGHT(B2, 12) --~--~-~--~~~---~--~~ --

$$Excel-Macros$$ Re: hi

Dear Satish, Attached file is the solution of your question. Regards, Lavprasad On Fri, May 29, 2009 at 2:47 PM, satish wrote: > Hey People > I need a small help, some of you might even find silly > > I have big list of 12 to 16 digit Numbers e.g., 15145745854501. First i > want to conv

$$Excel-Macros$$ Re: hi

try below code: ActiveWorkbook.SaveAs "c:\dhartikumar - " & Format(Date, "dd-mmm-") & ".xls" On Wed, May 27, 2009 at 5:52 PM, Dhartikumar Sahu wrote: > hi all > > can anybody help me for saving the file with current date. (e.g. > dhartikumar - 27 May 2009) > in macro code. > > Thanks & Rega

$$Excel-Macros$$ Re: hi

You're leaving WAY too much information out. For instance, what version of Excel are you using? What format do you want to save it in? WHERE do you want to save it? What do you want to call it? and... How much experience do you have with VBA? = The diff

$$Excel-Macros$$ Re: Hi Urgent Excel help required.

Yea I think it's a better solution, but Shahina want to copy only visible rows if you don't know.. On May 22, 8:37 pm, TAlgo wrote: > Try this if this helps > > Sub CopyPaste() > Dim ws As Worksheet > For Each ws In Worksheets > > If ws.Name <> "JAN" Then > ws.Select > ws.Applicatio

$$Excel-Macros$$ Re: Hi Urgent Excel help required.

Try this if this helps Sub CopyPaste() Dim ws As Worksheet For Each ws In Worksheets If ws.Name <> "JAN" Then ws.Select ws.Application.Run "Macro1" End If Next End Sub Sub Macro1() Range("A2:B13").Select ' select all the data range Selection.Copy Sheets("Summary Sheet").Select ActiveSheet.Paste

$$Excel-Macros$$ Re: Hi Urgent Excel help required.

check the article below, this should give you a start for what your are looking to do http://funwithexcel.blogspot.com/2009/05/macro-to-copy-worksheets-from-master.html In this I have shown how to copy the whole excel sheet, you got to tweak a bit, get the active cell and paste all sheets one by

$$Excel-Macros$$ Re: Hi I would require help on vlookup with search option

nice!!! On Fri, Apr 3, 2009 at 8:33 PM, Alpesh Juvarewala wrote: > Hi, > Pls find the attached solution. The trick is to use wild card > character. The limitation is that the text should not be repeated in > any other cell or else the result may not be as per expectation. > > > > 2009/4/3 hari

$$Excel-Macros$$ Re: Hi I would require help on vlookup with search option

Hi Aplesh / Kgrabbs, Thank you very much. Regards Hari Kumar -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of kgrabbs Sent: Friday, April 03, 2009 6:32 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Re: Hi I would

$$Excel-Macros$$ Re: Hi I would require help on vlookup with search option

I had not known you can add wild cards to vlookups. That is really cool. One note of caution is that I got false positives when entering the name George. The method stated above will display results upon the first match, which in this case was "George, Bush" and not "George" as in Jefferson. T

$$Excel-Macros$$ Re: Hi I would require help on vlookup with search option

Hi, Pls find the attached solution. The trick is to use wild card character. The limitation is that the text should not be repeated in any other cell or else the result may not be as per expectation. 2009/4/3 hari : > Hi All, > > > > I would require the output “city name from sheet “Data” on i

$$Excel-Macros$$ Re: Hi

You check the links below and join the group > > > --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at

$$Excel-Macros$$ Re: Hi

Hi Dalvi, Thanks for invitation.I want to join but how, please explain. Naveen On 9/4/08, Dalvi, Kundan <[EMAIL PROTECTED]> wrote: > > > Hi, > > Would like to jon this community for learning excel macros. > > Kundan Dalvi > LEHMAN BROTHERS INDIA > Finance - BPM > * 8-053-3924 > [EMAIL PROTECTED