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 co
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 tha
Thanks a lot Ravinder ji for your help.
On Wed, Oct 9, 2013 at 6:05 PM, Ravinder wrote:
> 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 have taken only 31 chara
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 wrote:
> pfa
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Mukesh Kumar
> *Sent:* Wednes
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 dropdow
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 wrote:
> Dear Excel gurus,
>
> Please suggest m
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, An
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 wrote:
> Dear Experts
>
> Pls anybody guide me on this is
