Re: $$Excel-Macros$$ Need Urgent Help ~ Vlookup

2009-11-13 Thread Aindril De
Its OK Anish, I can understand the frustration... I am also sorry for my hard words.. CHEERS!! Andy On Fri, Nov 13, 2009 at 9:09 PM, Anish Shrivastava wrote: > Thanks Aindril for your help. > > N GROUP ...M REALLY SORRY For what I wrote...trust me I realized it later > tht it wasnt a right way..

Re: $$Excel-Macros$$ PLEASE SOLVE THE PROBLEM IN FILE ATTACHED i have not got the proper solution. please show in excel file

2009-11-13 Thread Paul Schreiner
It's pretty easy to get the first part except: Where does the "session" data come from? Can you send me a file with more data to work with? Otherwise, I have to spend more time creating "test" data than doing the coding! Paul From: Jitender To: jainayus...@g

Re: $$Excel-Macros$$ hi

2009-11-13 Thread Sandeep
Hi Use this in X5 =SUMIF($T$5:$T$717,"<="&X3,$M$5:$M$717) And this in Y5 =SUMIF($T$5:$T$717,"<="&Y3,$M$5:$M$717) - SUMIF($T$5:$T$717,"<="&X3,$M$5:$M$717) Then copy the Y5 formula and paste it in Z5 to AF5 Regards Sandeep - Original Message - From: Shraddha Shah To: excel-macros@

$$Excel-Macros$$ Excel Group (Outline) - Use VBA to hide or Show

2009-11-13 Thread PMC1
Hi, I import a worksheet into a workbook on a regular basis. The worksheet has some predefined Row and Column Groupings. Using code I want to manage which rows are displayed and which are not. Some the rows I want to hide and those I do want to display are at different levels so a blanket rule li

$$Excel-Macros$$ Re: Clean - clear pivot cache Excel 2003

2009-11-13 Thread MKamal
Hello again! This VBA code create 4 pivot table based on the same data cache; This is exactly what you have asked ! >Want: >a) vba routine to ensure that all pivots are based on the same pivot >cache >b) select one "mother pivot" cashe to be used by all pivots table Regards --

$$Excel-Macros$$ PLEASE SOLVE THE PROBLEM IN FILE ATTACHED i have not got the proper solution. please show in excel file

2009-11-13 Thread Jitender
On 11/12/09, Jitender wrote: > DEAR SIR/GURUS > > PLEASE SOLVE THE PUZZLE IN FILE . TRANSPOSE IS NOT A GOOD SOLUTION > > THANKS > -- > Jitender > > -- > -- > Some important links for excel users: > 1. Excel and VBA Tut

Re: $$Excel-Macros$$ Need Urgent Help ~ Vlookup

2009-11-13 Thread Anish Shrivastava
Thanks Aindril for your help. N GROUP ...M REALLY SORRY For what I wrote...trust me I realized it later tht it wasnt a right way...was kinda frustrated in office.. :( On 11/13/09, Aindril De wrote: > > Dear Anish, > > You would need a UDF for this: > > Use the following code : > > Option Explic

Re: $$Excel-Macros$$ unable to set the visible property of the worksheet class

2009-11-13 Thread Hemant Hegde
Hi Its because you have protected the workbook. Unprotect it Press Alt+t p w and then provide the password and then try :) Hemant Hegde 2009/11/12 mahesh parab > Dear All > > In attach sheet when i try to unhide sheet i am getting caption error. > steps are mention on below mention link > >

Re: $$Excel-Macros$$ Problem with Hyperlink

2009-11-13 Thread Hemant Hegde
Hi I don't know the exact reason for this problem. But I can suggest you to use HYPERLINK() Formula. Using this, you can make the hyperlinks dynamic, more stable (as u say it isn't right now) and intelligent! It can be little difficult but its is not a rocket science. You can google it or attach

Re: $$Excel-Macros$$ unable to set the visible property of the worksheet class

2009-11-13 Thread Norman May
The workbook is protected with a password. Norman May On Thu, Nov 12, 2009 at 11:09 AM, mahesh parab wrote: > Dear All > > In attach sheet when i try to unhide sheet i am getting caption error. > steps are mention on below mention link > > http://www.ehow.com/how_2132122_worksheet-another-user-

Re: $$Excel-Macros$$ Re: Store Cell formatting

2009-11-13 Thread Paul Schreiner
sorry.. I'm not much help there. I've never used .XLL files, and I'm HEAVILY into VBA... Perhaps someone else can give you the help you need. BTW:  What version of Excel are you using? Paul From: Hemant Hegde To: excel-macros@googlegroups.com Sent: Thu, Nove

Re: $$Excel-Macros$$ excel reminder

2009-11-13 Thread Paul Schreiner
yes, that's fairly simple. But, since you didn't give us much to go on, I'll have to be pretty generic and make lots of assumptions. first of all, you'll need a macro (since you wrote to this group, you probably already knew that) I'll "assume" that the calender of events is on a sheet called "

Re: $$Excel-Macros$$ Macro to Protect cell of a worksheet

2009-11-13 Thread Paul Schreiner
Yes, please, why do you need a "macro" to protect a cell? Do you understand how to lock a cell end turn on Protection? the manual process is: Select all cells in a worksheet. Select Format->Cells   On "Protection" tab, remove check from "Locked" checkbox In Excel2007, the Protection is on the "R

Re: $$Excel-Macros$$ Need Urgent Help ~ Vlookup

2009-11-13 Thread Sandeep Kumar Maurya
Hi Anish, See the attached file. Don't change position of 'Auto Reset', 'Counter' and 'Auto Switch' else it may not work properly. Also it can be done easily with VBA, so if you need then ask the solution in VBA and you will get a quick response from the group. Regards Sandeep On Fri, Nov 13, 2

Re: $$Excel-Macros$$ Macro to Protect cell of a worksheet

2009-11-13 Thread Aindril De
Debashish, Could you please elaborate the requirement. If possible with an example workbook. Regards, Andy On Fri, Nov 13, 2009 at 5:03 PM, DEBASHIS BANERJEE wrote: > > Dear Friend, > > I need a Macro to Protect Cell of a work Sheet . Kindly help . it is > Urgent . > > Thanks and regards > >

Re: $$Excel-Macros$$ Need Urgent Help ~ Vlookup

2009-11-13 Thread Anish Shrivastava
Hi Punit, Thanks for you helping attempt, but tht's not wht I want. You used just vlookup in 2 cells...I m afraid to say tht but even I know tht much of basics (No offence). Could you please let me know wht if the occurance is 3 times. :P Cheers!! ANISH On Fri, Nov 13, 2009 at 3:06 PM, punit pod

$$Excel-Macros$$ excel reminder

2009-11-13 Thread punit poddar
Hi Guys I needs your help, actually I have an excel file that basically contains date and the things to do on that date. e.g. 10/nov/09 - attend marriage 11/nov/09 - visit client 10/nov/09 - test and so on, now I want that whatever the to dos are there in the excel file to be done today (it may

Fwd: $$Excel-Macros$$ Problem with Hyperlink

2009-11-13 Thread DEBASHIS BANERJEE
-- Forwarded message -- From: DEBASHIS BANERJEE Date: Nov 12, 2009 1:34 PM Subject: $$Excel-Macros$$ Problem with Hyperlink To: excel-macros@googlegroups.com Dear Friends , I have workbook having multiple sheet. Each Page is connected with Hyperlink . Problem is that as soon as t

$$Excel-Macros$$ Macro to Protect cell of a worksheet

2009-11-13 Thread DEBASHIS BANERJEE
Dear Friend, I need a Macro to Protect Cell of a work Sheet . Kindly help . it is Urgent . Thanks and regards Debashis. -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Fre

$$Excel-Macros$$ Need Urgent Help ~ Vlookup

2009-11-13 Thread punit poddar
Hi You can use the file attached below: Punit -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http:/

$$Excel-Macros$$ Excel Reminder

2009-11-13 Thread punit poddar
Hi Guys I needs your help, actually I have an excel file that basically contains date and the things to do on that date. e.g. 10/nov/09 - attend marriage 11/nov/09 - visit client 10/nov/09 - test and so on, now I want that whatever the to dos are there in the excel file to be done today (it may

$$Excel-Macros$$ Need Urgent Help ~ Vlookup

2009-11-13 Thread Anish Shrivastava
Hello Experts, Once agian I am here with a new problem (Thanks for helping me earlier, on my code). This time I am stuck with Vlookup, actually I have a list of lot # for which I have to find TIC # from another table but the problem is it has got multiple occurances. Our simple vlookup picks the

Re: $$Excel-Macros$$ text and date in one cell

2009-11-13 Thread Dhartikumar Sahu
hi Prashanth Please find attached file as per your requirement. Dhartikumar On Thu, Nov 12, 2009 at 6:36 PM, Prashanth Banneni wrote: > Hi All, > > Can you help me how to get the desired output from the attached sheet. > > Many thanks in advance > > Best > Prashanth > > -- > > -