Hi Amar,
As Ravinder said your question was not clear. I tried to resolve your
query, plz find attachment. If this is not you are looking for let us be
clear on your question.
Regards,
Kartik
On Mon, Oct 7, 2013 at 4:36 PM, amar takale amartak...@gmail.com wrote:
Dear Experts
Pls anybody
Another way, little longer in code :D and just a little faster
I'am using manual method, fist, openit as textfile and split by
delimiter, then copy each column to specified destination
in attached sample with 500k row data, can processed in 2,6 seconds @ my
old comp
On 09-10-2013 13:13,
Dear Harisha,
The files which u have sent is in different format. kindly send proper format.
Warm Regards,
Gawli Anil
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Wed, Oct 9, 2013 at 2:54 PM, Hari harisha.prabha...@gmail.com wrote:
Dear Excel
Dear Sir,
I have an excel file in which there are 300 names are there they are
given different targets. Now I have to take print outs of these 300 names.
I have prepared drop down list of 300 names in cell A7 in attached sample
file.
My requirement is that I want 300 sheets according to
Dear Sir,
Please check that there is no changes done in your attached file.
Regards,
Mukesh Kumar
On Wed, Oct 9, 2013 at 4:46 PM, Ravinder ravinderexcelgr...@gmail.comwrote:
pfa
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Mukesh
Thanks a lot Ravinder ji for your help.
On Wed, Oct 9, 2013 at 6:05 PM, Ravinder ravinderexcelgr...@gmail.comwrote:
PFA..actually if you will try to rename excel sheet with “M/s Ram Niwas
Sons, K”, excel does not allow u rename and len of sheetname should not be
more than 31 character, so I
Hi,
I am copying the date as text from one sheet and pasting to another sheet using
the code activesheet.paste. when i do it so, it is converting to general number
41135.
after formatting to d/mm/, the date that is having greater than 12 get
converted exactly to d/mm/ where as date
please share ur vba code with example sheet
.
Enjoy
Team XLS
On Thu, Oct 10, 2013 at 6:39 AM, Viswanathan Yoganathan
viswanathan.yoganat...@asia.xchanging.com wrote:
Hi,
I am copying the date as text from one sheet and pasting to another sheet
using the code
