Re: $$Excel-Macros$$ Filtering in Excel

2010-04-01 Thread Dipika Mallya
t; > Hope it Will Help > Happy to Help > :) > Shyam > > > > > > > > > > On Thu, Apr 1, 2010 at 4:19 PM, Dipika Mallya > wrote: >> write in here: http://anonomi.com/DM >> >> yourorgname.net/branch/div/emplmgr/mgr/smgr/jmgr/sup/sub >>

Re: $$Excel-Macros$$ Filtering in Excel

2010-04-01 Thread Dipika Mallya
write in here: http://anonomi.com/DM yourorgname.net/branch/div/emplmgr/mgr/smgr/jmgr/sup/sub in excel format. On Wed, Mar 31, 2010 at 6:36 PM, Shimmy wrote: > Hello EXCEL_lent people. > > I am working for an emerging organisation/company. I would like to > create a spreadsheet in Excel for my

Re: $$Excel-Macros$$ need help

2010-04-01 Thread Dipika Mallya
yes. what do you want to automate. On Wed, Mar 31, 2010 at 11:47 PM, Shilpa Rao wrote: > HI > any automation tools getting graphs in excel or any other automation tools > in excel to get report or any free softwares to get report automated. > > > On Sat, Mar 20, 2010 at 2:47 PM, yogananda muthai

Re: $$Excel-Macros$$ Track changes macro

2010-04-01 Thread Dipika Mallya
can you elaborate unauthroised access / On Thu, Apr 1, 2010 at 12:04 AM, seema mba wrote: > Hello Master, > > I have got a macro to track changes made in excel sheet. But the changes > are tracked in sheet1 of the same work book. I want a macro which keeps the > track of changes, in a different

Re: $$Excel-Macros$$ Re: Please help In seperating alphabets and numbers from a cell

2010-04-01 Thread Dipika Mallya
Great point Paul, @Abhi To add to Paul's Excell insight with a working example, Suppose two functional links. http://j.mp/gate2010csit http://j.mp/gate2010cs exist Does your function need to identify the csit link from the cs link or not. Regards, DM http://anonomi.com/iname http://anonomi.co

Re: $$Excel-Macros$$ Data Import

2010-04-01 Thread Dipika Mallya
On.Count >1l goto next worksheet. On Thu, Apr 1, 2010 at 11:44 AM, Mahesh wrote: > Dear All, > > Need ur expat advise... > > I got around 20 text files in a day,which had 13 to 15 columns separated by > "|" this sign. each file contains around 15 lacs or more line items. > > when i import that

Re: $$Excel-Macros$$ Re: How to remove Invisible symbols in a cell.

2010-03-31 Thread Dipika Mallya
try the inbuilt custom reformatter method. with regards, DM On Wed, Mar 31, 2010 at 5:35 PM, nike wrote: > Hi Paul Willekens, > some of the cells are followed by " mm/dd/ hh:mm"(24Hrs ) format > some of the followed by "mm/dd/ hh:mm AM/PM" i want "mm/dd/ > hh:mm AM/PM". > > thx for