Re: Re: $$Excel-Macros$$ I need VBA code to copy the cell value and paste in comment box for the same cell.

Thanks a ton to Ashish and Vaibav!! I looks good now. You guys are brilliant. :) On Wed, Aug 20, 2014 at 1:59 AM, Ashish Kumar wrote: > Vaibhav Bro, > > Superb!!! > > > On 20 August 2014 12:12, Vaibhav Joshi wrote: > >> FA >> >> Cheers!! >> >

$$Excel-Macros$$ VBA code for adding new row at the end of last row

Hello VBA/macro Expert group, I've attached file in which I want to add new row at the end of last used row. Using simple macro I can add blank row but I want to add pre-populated row with certain condition. Ex: *Col A:* It'll have ID# as A1 A2, A3A10. If I use Macro, it should insert new r

Fwd: Re: $$Excel-Macros$$ I need VBA code to copy the cell value and paste in comment box for the same cell.

ct cell for which you want comment to appear & run macro by clicking blue button. Cheers!! On Mon, Aug 18, 2014 at 9:16 PM, Pankaj Kumar wrote: > Thanks vaibav for your prompt response. It looks good but the problem with > this code is that whenever you double click on any cell in the

Re: $$Excel-Macros$$ I need VBA code to copy the cell value and paste in comment box for the same cell.

the cell whose text you want to read & msgbox > will popup with text in cell. > > Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal > Target As Range, Cancel As Boolean) > MsgBox Target.Text > End Sub > > Cheers!! > > > On Mon, Aug 18, 2014

$$Excel-Macros$$ I need VBA code to copy the cell value and paste in comment box for the same cell.

I need VBA code to copy the cell value and paste in comment box for the same cell. Example: If I select any cell or merged cells which has some text in it then code should copy the text and create a comment and paste the same text. I need this because when user can't see the entire text because

$$Excel-Macros$$ Hi

Hi, exper it urgent i need u r help i attached my excel sheet -- *Warm Regards Pankaj kumar M: 9899816107 e-mail: rajputpanka...@gmail.com rajputpank...@yahoo.in* * rajputpankaj1...@rediffmail.com

$$Excel-Macros$$ Urgent Querry

Hi, All Experts, Its Urgent -- I need u r help i have two column in excelsheet Data1 & Data 2 we have to match both data if its Match show "Match" or not Match shows "Mismatch" in next coloum,,,Pls provide me formulas I have attached my excelsheet *Warm Regards Pankaj ku

$$Excel-Macros$$ Time calculation

Hi, Experts I have a problem my worksheet is attched , i have to calculated total working hrs, pls help me -- *Warm Regards Pankaj kumar M: 9899816107 e-mail: rajputpanka...@gmail.com rajputpank...@yahoo.in* * rajputpankaj1...@rediffmail.com

$$Excel-Macros$$ I am only looking for e-mail id in different colums

Hi, Experts I need u r help, i have a excelsheet my problem is I am only looking for e-mail id in different colums ex in Colum F --- resume @alsachi.com if I do one by one copy & paste it's a lot of time , is any short cut to do it -- *Warm Regards Pankaj kumar M: 98998161

$$Excel-Macros$$ Need help

Hi all i have a excel sheet need help, i wanted to use excel formula not pivot table or chat -- *Warm Regards Pankaj kumar M: 9899816107 e-mail: rajputpanka...@gmail.com rajputpank...@yahoo.in* * rajputpankaj1...@rediffmail.com

$$Excel-Macros$$ Conditional Formating

Hi all, i am new in msexcel wanted to learned use of conditional formating, cananyone helped me to learned conditional formatting ,,,for a brief example -- *Warm Regards Pankaj kumar M: 9899816107 e-mail: rajputpanka...@gmail.com rajputpank...@yahoo.in* * rajputpankaj1

$$Excel-Macros$$ Time sheet calculation

-- *Warm Regards Pankaj kumar M: 9899816107 e-mail: rajputpanka...@gmail.com rajputpank...@yahoo.in* * rajputpankaj1...@rediffmail.com* -- -- Some important links for excel users: 1. Follow us

$$Excel-Macros$$ Time Calulation

Hi, All, i have a problem in excelsheet attached below -- *Warm Regards Pankaj kumar M: 9899816107 e-mail: rajputpanka...@gmail.com rajputpank...@yahoo.in* * rajputpankaj1...@rediffmail.com

$$Excel-Macros$$ I have a problem for following worksheet

Dear all, When i use the forumulla it shows value pls find attached sheep -- *Warm Regards Pankaj kumar M: 9899816107 e-mail: rajputpanka...@gmail.com rajputpank...@yahoo.in* * rajputpankaj1...@rediffmail.com

$$Excel-Macros$$ Hi all

Hi, All, I am fresher in ms excel & wanted to learned how to prepared Pivot table & report in Msexcel -- *Warm Regards Pankaj kumar M: 9899816107 e-mail: rajputpanka...@gmail.com rajputpank...@

Re: $$Excel-Macros$$ How to find duplicate records in excel

> Its cannot help me i provid you an example ; help me to find duplicate > records 678 567 890 678 456 456 789 678 567 890 678 678 567 890 678 456 456 789 678 567 890 678 678 567 890 678 456 456 789 678 567 890 678 -- *Warm Regards Pankaj kumar M: 9899816107 e-mail: rajpu

$$Excel-Macros$$ hi

Hi, Can anyone help me to understand what is Vlookup & Hlookup,for a short example how to use it ,, -- *Warm Regards Pankaj kumar M: 9899816107 e-mail: rajputpanka...@gmail.com rajputpank...@yaho

$$Excel-Macros$$ How to find duplicate records in excel

Hi, I have a problem i have a lot of data & i wanted to find duplicate record is there any fourmula or command in excel. -- *Warm Regards Pankaj kumar M: 9899816107 e-mail: rajputpanka...@gmail.com rajputpank...@yaho

$$Excel-Macros$$ Re: Remove the Password

you need files or just password --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.exceli

$$Excel-Macros$$ Re: Use of macros!

i know smwhat about using macrosbest way to learn thm is to start experimenting with anything..im on 9216796066.this is the thing by which we can reduce our working time to a great extent...in all macro is the ultimate tool to get in the world of prograqmming for non programmers