Re: $$Excel-Macros$$ Re: headcout dashboard report

2010-11-30 Thread anandydr
Hi, Sent the dashboard to all those who need it. I have collected these from internet and none of them were create by me, still they have helped me a lot in my work. I have been unable to find a way to attach files to my posts would some one explain how it is done? Thanks, Anand On Nov 30, 5:39

Re: $$Excel-Macros$$ Need help on excel sheet

2010-11-30 Thread Manjunath C
No, I have different data (place wise) in 5 tabs, my expectation is that wile pasting the raw data in the first sheet , it should divide the data as per the region or place wise in the remaining sheet and that needs to be seperated in different individual sheet in my desktop or in a different file

RE: $$Excel-Macros$$ issue with Data validation

2010-11-30 Thread Rushiraj Patel
Dear Anil, I am having the same issue. Please share the file which Mr. Anand Kumar had mailed you back yesterday. It will help me a lot. Tnx & Regards, Rushiraj Patel _ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of anil panchal

$$Excel-Macros$$ Trying to print specific worksheet from outlook attachment

2010-11-30 Thread J
Hi everyone- I'm trying to use VBA to print a specific "(1)ORDER FORM" worksheet from workbooks that I'm receiving in Outlook. I've constructed the following, but it keeps erring out when reaches the Worksheet("(1)ORDER FORM").Printout line. I receive errors ranging from error 9 to error 462 to er

Re: $$Excel-Macros$$ Convert PDF to excel

2010-11-30 Thread in . vaibhav
Hi, You can use verypdf to convert pdf to excel Sent on my BlackBerry® from Vodafone -Original Message- From: Skanda Sender: excel-macros@googlegroups.com Date: Tue, 30 Nov 2010 11:29:26 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Convert PDF to excel hi All

$$Excel-Macros$$ Convert PDF to excel

2010-11-30 Thread Skanda
hi All, How to convert PDF file to an excel file? Thanks, Skanda. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedI

$$Excel-Macros$$ This is your last chance to enroll at Master of Macros - $40 off

2010-11-30 Thread Ayush
Dear discussexcel.com member, Hope you are doing well ! This is your last chance to get your Master of Macros membership with a $40 discount. This is exclusively given to members of this group and you are the one.Congratulations. Your discount coupon: DISCUSSEXCEL expiring in 5 daysrush now

Re: $$Excel-Macros$$ Re: headcout dashboard report

2010-11-30 Thread Ahmed Honest
Dear Anand, As per your below mail i think that you have mailed to concerned person personal email. But would request you to be kind enough to send me as well. Appreciate and thanks in advance..!! Regards Ahmed Bawazir On Tue, Nov 30, 2010 at 8:30 AM, anandydr wrote: > Hi, > > Just mailed you

Re: $$Excel-Macros$$ Fwd: Help required for formule

2010-11-30 Thread Jagadeesh B S
* Hello all, I am very thank full to all of you.. I got the best solution for my query form Ashish Koul. Thanks for all amrahs , Ashish Koul and Ashish Koul for helping me in this regard. Thanks for the group members and the our group owners for provide excellent platform to learn and he

Re: $$Excel-Macros$$ Need help on excel sheet

2010-11-30 Thread Frank Linden
Hello,   Do you mean that you want to collect the data on all 5 sheets and add it to a 6th sheet and then save the workbook with all 6 sheets? Or do you need to take the data from the 5 sheets and put it on one sheet, then saving a new workbook with only one sheet?       --- On Tue, 11/30/10, Man

Re: $$Excel-Macros$$ Bold a Text with Help Of Formula

2010-11-30 Thread in . vaibhav
Hi, If possible send that file and how do u send email through Outlook, OL express or through CDO. Sent on my BlackBerry® from Vodafone -Original Message- From: Rahul Kamal Gandhi Date: Tue, 30 Nov 2010 12:57:55 To: in.vaib...@googlemail.com Cc: excel-macros@googlegroups.com Subject:

RE: $$Excel-Macros$$

2010-11-30 Thread Dave Bonallack
Hi, Thanks Anund. Anindya, are you using XL2003 or 2007? When you want to conditional format a whole block of data like the table I sent you, XL is very helpful and you only need to enter the formula once. First you need to select the whole table. You will notice that when you select a group of

$$Excel-Macros$$ Need assistance in macro training

2010-11-30 Thread Manjunath C
Hi , This is Manjunath from chennai, I am more interested to learn Macro. Can any one help me how to learn macro with the begining stage. Or suggest me if any trainer or institution in chennai. more appreciated in advance for you assistance. Thanks Manjunath -- ---

Re: $$Excel-Macros$$ Need it in seperate excel sheets

2010-11-30 Thread Aindril De
Hi Manjunath, The solution provided in the link should suffice: http://www.mvps.org/dmcritchie/excel/saveas.htm Regards, Aindril On Tue, Nov 30, 2010 at 2:50 PM, Manjunath C wrote: > Hi > > Can anyone help me, as I Have data in each tab, I need

$$Excel-Macros$$ Need it in seperate excel sheets

2010-11-30 Thread Manjunath C
Hi Can anyone help me, as I Have data in each tab, I need it in sperate excel sheet. Any macros available - appreciate your help in advance. Thanks Manjunath -- -- Some important links for excel users: 1. Follow us

$$Excel-Macros$$ Need help on excel sheet

2010-11-30 Thread Manjunath C
Hi All, Can anyone help me, I have data in 5 tabs, now i need to make it in seperate excel sheet and paste it local desktop. Any macros available - appreciate your help in advance. Thanks Manjunath -- -- Some impor

Re: $$Excel-Macros$$ Bold a Text with Help Of Formula

2010-11-30 Thread Rahul Kamal Gandhi
Vaibhav, I wrote an macro in excel where in the macro automatically find the to, cc, subject, mail body, attachment name, attachment extention, and attachment path, send on behalf of name The above attributes are already been defined in excel What actually I want is to do some formatting in ma

Re: $$Excel-Macros$$ Bold a Text with Help Of Formula

2010-11-30 Thread in.vaib...@googlemail.com
Dear Rahul Pl explain the procedure, if you are saying you will be sending it to 9000, then will you be using mail merge or not. If not how u will be sending (i.e. using which application) to 9000 employees. Rgds Vaibhav J On Tue, Nov 30, 2010 at 9:21 AM, Rahul Gandhi. wrote: > Sir, > > Tha

Re: $$Excel-Macros$$

2010-11-30 Thread anandydr
Hi, Just saw your query and the solution both. Doing this would be simple though. > Then you have formed a separate drop down column in G2 putting the months as > reference - *How did you do this particular step??* This step is done through data validation. In Excel 2007 you can find this in Dat