Re: $$Excel-Macros$$ sumifs formula doesn't work

2011-02-19 Thread ashish koul
see it it helps On Sun, Feb 20, 2011 at 3:10 AM, sudhir kumar wrote: > HI > All Dear Friends, > > Please help on attached file. > > thanking you > > Regards > Sudhir Verma > > > > --

$$Excel-Macros$$ sumifs formula doesn't work

2011-02-19 Thread sudhir kumar
HI All Dear Friends, Please help on attached file. thanking you Regards Sudhir Verma -- -- Some impor

RE: $$Excel-Macros$$ Special Suffix Identification

2011-02-19 Thread Pehrson, Dave
Ashish This works great, thanks for your support and insight. This is just what I was looking for. Regards Dave From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: Friday, February 18, 2011 9:43 PM To: excel-macros@googlegroups.com

$$Excel-Macros$$ Fwd: FW: Leave planner & tracker1.xlsx

2011-02-19 Thread Rajasekhar Praharaju
hi, I will be preparing the leaveplanner tracker report frequently . i will colour the specific day when i am absent on particular day.finallyon the end of the month i will count the different colours and place the number. Please provide the formula or vba macro to perform this activity. than

RE: $$Excel-Macros$$ $$Excel Macros$$ help me regarding copy only conditional formating with formula & extending formula.

2011-02-19 Thread Daniel
Hello, Use the following macro : Sub test1() [K21].FormatConditions(1).Delete With [K21:V130] .FormatConditions.Add xlCellValue, xlGreater, "=SI(K$20=""c"";$F21;$G21)" .FormatConditions(1).Font.ColorIndex = 2 .FormatConditions(1).Interior.ColorIndex = 1 .FormatConditio

excel-macros@googlegroups.com

2011-02-19 Thread Venkatesan c
Dear All, I want to Export data to Excel 2007 from SQL Server 2000 table.Kindly help on this. -- *Regards,* *Venkat* -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : h

RE: $$Excel-Macros$$ I need to extract data from a sheet to another in the same workbook - please help.

2011-02-19 Thread Daniel
Hello, An empty sample file, with only the headers would help. If it's not possible, please indicate which are the headers and their respective columns. Regards. Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Suhas Envoyé 

$$Excel-Macros$$ I need to extract data from a sheet to another in the same workbook - please help.

2011-02-19 Thread Suhas
Hi. I am currently recording my accounts in Excel. The main accounts sheet contains the data of - customers - invoices - date and amount. Now According to the customers, I need to maintain the individual accounts of these customers in their corresponding/respective sheets in the same/different work

Re: $$Excel-Macros$$ Re: how i convert pdf file to Excel using macro.

2011-02-19 Thread rashid memon
Dear Sir, I want to import data column wise... Excel File is attached for example thanks On Sat, Feb 19, 2011 at 12:34 PM, Ayush wrote: > Hi Rashid, > > You can find the macro at the link below : > http://quickvba.blogspot.com/2010/12/import-pdf-in-excel.html > > Let us know if you have any q