Re: $$Excel-Macros$$ Track changes inside text box in Excel

Thanks for the reply. I have checked and the sheet is not protected. I can make changes in the cell and not in the text box. Excel is locking the text box when I enable the track changes as ON. (This is still not a macro related question, but I am posting that some one may throw light in this issue

$$Excel-Macros$$ How To Connect To Access Database Through VBA

Hi, I need a help to connect excel file to a database in Access, I've a table format in the attached file, can anyone make a macro to solve this query. 1) Macro should take inputs from a useform and saved the data in the table in access databse. Seq# should be unique and auto generated for every

Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet

Dear Dilip, I can't see the codes. How shal I get codes. Please help me..I am not comfortable with VBA. And what is the password. Thanks in advance Kalyan On Thu, Sep 9, 2010 at 12:01 AM, Dilip Pandey wrote: > Hi kalyan, > > This is not possible without vba as u r asking for a sheet to

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

You can copy the all the email ids after filtering them and then paste special and transpose them. Is this wht u r looking for ? On 9/9/10, Pankaj Kumar wrote: > > 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 C

$$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: 9899816107 e-mail: rajputpanka

RE: $$Excel-Macros$$ Macro to reshade every other row after column sort

Hi, I assume your shading is currently done manualy. It could easily done with VBA or even more easily with Conditional formatting, as long as you aren't currently using it for something else. Select all cells in the block Open the conditional formatting dialogue box Select 'Formula is'

$$Excel-Macros$$ Macro to reshade every other row after column sort

I have four worksheets (WS1, WS2, etc.), and on each sheet a dynamic name ranged (WS1Data, WS2Data, etc.). These named ranges always begin on B8 but the columns and rows they span will vary based on the data (so I can't use an absolute reference). The rows in the range are alternatively shaded. Ea

Re: $$Excel-Macros$$ Column Data in Rows Table

*(1) : Macro VBA-Excel Solution* Private Sub CommandButton1_Click() Dim SrceTbl As Range, DestTbl As Range Dim r As Long, nr As Long, c As Integer Set SrceTbl = Sheets("Sheet1").Cells(1, 1).CurrentRegion Set DestTbl = Sheets("Sheet2").Cells(2, 2) For r = 2 To SrceTbl.Rows.Count

Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet

Hi kalyan, This is not possible without vba as u r asking for a sheet to be available on password, else u can simply go ahead n use protect sheet option available under Tools menu. Best Regards, DILIPandey On 9/8/10, Kal xcel wrote: > Hi Dilip, > > Thanks a lot for your help, but I am not comfo

Re: $$Excel-Macros$$ An excel data entry problem

no problem welcome. On Wed, Sep 8, 2010 at 5:38 PM, api gud wrote: > Sorry for the inconvenience. I have disabled the macros..that > was not able to run the macro attached. Now its working perfectly. > > Thanks Ashish > > On Sep 8, 8:19 am, ashish koul wrote: > > hi > > > > try thi

Re: $$Excel-Macros$$ Re: Lookup from date series

hi Dilip, Thank u very much for contributing time for me. But I am facing some problem in the given file. Actually I need this: When I select 01.04.2010 to 30.04.2010 it will show april, if date is from 01.05.2010 to 31.05.2010 it will show may, when date will cross 30.04.2010 from 01.04.2010 it

Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet

Hi Dilip, Thanks a lot for your help, but I am not comfortable with VBA. is it possible without macro. Thanks Kalyan On Tue, Sep 7, 2010 at 8:15 PM, Dilip Pandey wrote: > Hi Vamsi, > > Password is there in the cell B1 of RSM sheet, which is there for the > owner/admin of the workbook. > >

Re: $$Excel-Macros$$ An excel data entry problem

Sorry for the inconvenience. I have disabled the macros..that was not able to run the macro attached. Now its working perfectly. Thanks Ashish On Sep 8, 8:19 am, ashish koul wrote: > hi > >  try this assuming sheet1 is master see if it helps > > Sub Macro1() > Dim i, z, k As Long > z = 1

$$Excel-Macros$$ MyVlookUp

Hi... Whats this MyVlookUp thing please clarify -- -- 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 @ h

Re: $$Excel-Macros$$ An excel data entry problem

have u checked that attachment its working fine at my place -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com *akoul*.wordpress.com My Linkedin Profile P Before printing, think ab

Re: $$Excel-Macros$$ An excel data entry problem

Hi Ashish, Thanks for your effort. I guess something is missing in this macro. Its not working properly. Please help me out. Regards Aparna On Sep 8, 8:19 am, ashish koul wrote: > hi > >  try this assuming sheet1 is master see if it helps > > Sub Macro1() > Dim i, z, k As Long > z = 1 > k = 50 >

$$Excel-Macros$$ Re: Column Data in Rows Table

hello Sayyad, without the use of vba, try the file transpose1.xls to link: https://sites.google.com/site/e90e50/scambio-file regards r On 8 Set, 08:30, Sayyad1284 wrote: > Hi , > > I have a case where I get the data in following format > > Name    A       B       C       D       E > AA      10

Re: $$Excel-Macros$$ Pls solve my Attendance file

Dear Aftab, Please find attachment with solution. Thanks, Noorain Ansari On Wed, Sep 8, 2010 at 3:06 PM, ALAM wrote: > Dear all, > >I want to make complete Attendance sheet in excel format > and other application or S/w. like FoxPro/ c++ /V.B. > > Note:-- > > 1. I have

Re: $$Excel-Macros$$ Column Data in Rows Table

Hi Dave , Thanks but if you see the output I am expecting I need data in 3 columns ..i.e. column headings also need to displayed against each cell On Sep 8, 2:02 pm, Dave Bonallack wrote: > Hi Sayyad, > > Have a look at the attached. > > Click the button on sheet 2. > > Regards - Dave > > > > >

$$Excel-Macros$$ Pls solve my Attendance file

Dear all, I want to make complete Attendance sheet in excel format and other application or S/w. like FoxPro/ c++ /V.B. Note:-- 1. I have three sheets in excel format ( *Hide File, Attendance Sheet, Output*) 2. Two sheets (*Hide file and Output*) are *Hide

RE: $$Excel-Macros$$ Column Data in Rows Table

Hi Sayyad, Have a look at the attached. Click the button on sheet 2. Regards - Dave > Date: Tue, 7 Sep 2010 23:30:20 -0700 > Subject: $$Excel-Macros$$ Column Data in Rows Table > From: anamika2...@gmail.com > To: excel-macros@googlegroups.com > > Hi , > > I have a case where I get the data

Re: $$Excel-Macros$$ Lookup from date series

File attached. Check whether it serve the purpose. Regards, C.G.Kumar On Wed, Sep 8, 2010 at 10:59 AM, Kal xcel wrote: > Dear Experts, > > I need a help, I want to lookup value from selected dates. > > File is attached > > Thanks in advance > > Kalyan > > -- > > -

Re: $$Excel-Macros$$ Rupee symbol on PC

Thanx a lot I would like to know how to have the new symbol in the below mentioned format : [>999]"Rs. "##\,##\,##\,##0.00;[>9]"Rs. "##\,##\,##0.00;Rs.##,##0.00 N.SHIVKUMAR -- -- Some important links for exce