$$Excel-Macros$$ Hide Coloum

2010-06-29 Thread Sachin Shukla
Dear All, Is it possible to hide or unhide coloum or row with password without macro ? Thanks in Advance Sachin Shukla -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and

$$Excel-Macros$$ Remove Password in Excel Sheet

2010-05-04 Thread Sachin Shukla
Dear All, I have sheet which is password protected. I forget the password. Please suggest me how i open this file and remove the password. Thanks in advance Sachin Shukla -- -- Some important links for excel

Re: $$Excel-Macros$$ Cell Formating

2010-02-26 Thread Sachin Shukla
Dear Mr. Pandey, It's happen even I open new sheet. I thiks somewhere problem in setting. What's your suggestion?. Thanks Sachin Shukla On Fri, Feb 26, 2010 at 2:53 PM, ankur wrote: > format the cells of whole sheet in general format... > > > if still problem &g

$$Excel-Macros$$ Cell Formating

2010-02-26 Thread Sachin Shukla
Dear All, If I put a data on sheet say in cell A1 I put 45 number, cell automatic convert in Date formate . How I remove this problem to my entire work book and sheet. I use Excel 2007 Thanks Sachin Shukla

$$Excel-Macros$$ Formating of Cell

2010-01-24 Thread Sachin Shukla
Dear All, Please help me on formating of cell: for example supoose I put the data in cell A1 say 5000 Its automatically converted into date formate insted of number formate. Please help me. Thanks in Advance Sachin Shukla

Re: $$Excel-Macros$$ Name of last Month

2010-01-13 Thread Sachin Shukla
Dear Mahesh, Please find attached soluation Thanks Sachin Shukla On 1/13/10, Mahesh wrote: > > Dear Friends, > > I need your help, > > I have to prepare the monthly Reports in which the heading contains the > name of last month. > > For Example:- > > 1.

Re: $$Excel-Macros$$ Combining mulitple rows into one row

2010-01-12 Thread Sachin Shukla
Dear, PFA soluation. Thanks sachin shukla On 1/12/10, AlwaysLearing wrote: > > Hey Guys, > I have a spreadsheet that has multiple rows of data for each employee > with each row containing the date they worked and for how long. For > example, Mr. Smith worked on 7/1/09 for 8

Re: $$Excel-Macros$$ Re: Cell Movement

2009-12-24 Thread Sachin Shukla
ANDEY >MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 110062 > > > On 12/24/09, Sachin Shukla wrote: >> >> Dear Mr. Pandey, >> >&g

$$Excel-Macros$$ Help required on cell movement

2009-12-24 Thread Sachin Shukla
Dear All, Please help me on attached file. Thanks in advance Sachin Shukla -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http

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

2009-07-01 Thread Sachin Shukla
n...@gmail.com > dilipan...@yahoo.com > New Delhi - 110062 > > On Tue, Jun 30, 2009 at 11:53 AM, Sachin Shukla wrote: > >> Dear All, >> >> Please provied me he

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

2009-06-30 Thread Sachin Shukla
Dear Daniel, Thanks a lot for prompt respense. your formula is working properly. But I could not understood logic. Can you explain your fourmula please?. Why you multiply by 5 in (g3-1). Thanks Sachin Shukla On Tue, Jun 30, 2009 at 7:25 PM, Daniel wrote: > Try : > > =SUM(OFFSET(

$$Excel-Macros$$ Urgent Help Required

2009-06-30 Thread Sachin Shukla
Dear All, Please provied me help on attached sheet. Thanks Sachin Shukla --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text

$$Excel-Macros$$ Help Required

2009-06-04 Thread Sachin Shukla
Dear All, Please help me on attached sheet. Thanks Sachin Shukla --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free

$$Excel-Macros$$ Help required

2009-06-02 Thread Sachin Shukla
Dear All, Please help me on analysis of different senarion. details question and sheet attached. Thanks Sachin Shukla --~--~-~--~~~---~--~~ - Some important links for excel

$$Excel-Macros$$ Fwd: Excel Bible 2007, Shortcuts, Functions & More..!

2009-05-15 Thread Sachin Shukla
Dear All, Please find some excellent books on excel and vba Thanks Sachin Shukla -- Forwarded message -- From: Sachin Shukla Date: Sat, Sep 13, 2008 at 10:41 AM Subject: Fwd: Excel Bible 2007, Shortcuts, Functions & More..! To: Ankit Garg , Neeta , niraj.par...@newriver

$$Excel-Macros$$ Re: F4 Repeat No Longer Available in Excel 2007

2009-05-12 Thread Sachin Shukla
use CTRL - R Thanks Sachin Shukla On Tue, May 12, 2009 at 12:39 AM, Rene Resendez wrote: > > I use to be able to just about use F4 to repeat the last command in > Excel 2003, my company just upgraded to Excel 2007. Now that function > is longer available. > > Does anyone

$$Excel-Macros$$ Learn VBA

2009-04-27 Thread Sachin Shukla
Dear All, I want to learn VBA in excel. Please help me. Thanks Sachin Shukla --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and

$$Excel-Macros$$ Help required Colour on Rows and Column

2009-03-25 Thread Sachin Shukla
Dear All, Please help me on said subjects . I attached sheet for same problem. Thanks in Advance Sachin Shukla Business Analyst New Delhi --~--~-~--~~~---~--~~ - Some important