'
Range("G8").Select
End Sub
Also is this method RIGHT ? [ The correct way pl. ]
ALso sir, will it retain the other non-zero values. ?
=mangal ho
On 3/6/13, Prince wrote:
> By using VBA :
>
> Sheet1.range("$A1$AZ1048576").clearcontents.
>
> regar
Dear Sir,
I have ANY excel sheet ,some cells have value ZERO [ numeric 0 ]. I
would like to BLANK or DELETE the numeric 0 , [Other cells may contain
any ALPHA-NUMERIC values. ] Pl Help.
=mangal ho
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW
wrote:
> You need to provide a file with more info and a detailed explanation of what
> you want with examples.
>
>
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
> -Original Message-
> From: Somnath Khadilkar
> Sent: Mo
Sir, any help ?
=Mangal Ho
On 4/10/12, Somnath Khadilkar wrote:
> Sir,
> A while ago, you had sent me a file, [ which I am enclosing ] to
> convert the DATA file into MANY SHEETS depeding upon filter condition,
> That is V useful, but I would like to generate NewFIles [ inst
Happy Birthday Mr. Don,
May God Bless you with Long Life & Peaceful Future
Somnath Khadilkar
On 4/14/12, Ayush Jain wrote:
> Dear members,
>
> Don Guillett has been selected as 'Most Helpful Member' for the month of
> March'12
> He has been helping forum m
. Good design???
>
>
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
> -Original Message-
> From: Somnath Khadilkar
> Sent: Monday, April 09, 2012 9:58 AM
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel
r the day.
>
>
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
> -----Original Message-
> From: Somnath Khadilkar
> Sent: Monday, April 09, 2012 11:58 AM
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ SPLIT in
> with/without macros and use only ONE file. Good design???
>
>
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
> -Original Message-
> From: Somnath Khadilkar
> Sent: Monday, April 09, 2012 9:58 AM
> To: excel-macros@g
hat the excel file will conatin? Only one Row?
>
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of Somnath Khadilkar
> Sent: Apr/Mon/2012 08:11
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Ma
perticular
city/item-codeXX ]
=mangal ho
On 4/9/12, Rajan_Verma wrote:
> Can you add more data and explain how you want to bifurcate the data?
>
> Rajan.
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of Som
dv.
PS: if the file exists --- may be just OVERwrite it...[ if possible
w/o prompting the user]
=mangal ho
On 4/9/12, Somnath Khadilkar wrote:
> Dear Sir,
> MY request is to get the data into MULTIFLE FILES depending upon
> FILTER Selected. The file names should be say ahm-item-1, ah
Dear Sir,
MY request is to get the data into MULTIFLE FILES depending upon
FILTER Selected. The file names should be say ahm-item-1, ahm-item-2
etc.. [ these will be unique combination] in a subdirectory named say
XXYY, which will cotain ALL colms for the selected filters on col. A
& B
so a
s varies
daily ] and my recorded macro is of THAT days record length. [ say
21000, and todays is say 21500 records, I guess you got it. ]
=mangal ho
On 2/6/12, dguillett1 wrote:
> Glad to help
>
>
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
> -Origi
/sheet will be
SLICED into col1 ffiles of colm 2 sheets with the remaining 3 thru 7
colm only. Well I need the S No 1 thru as many rows as a NEW Col in
each sheet.
If still unclear I will share a work file. [ I dont know if its called
DOUBLE LOOPING ]
On 2/24/12, Somnath Khadilkar wrote:
>
if exists. ]
On 2/6/12, dguillett1 wrote:
> Glad to help
>
>
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
> -Original Message-
> From: Somnath Khadilkar
> Sent: Sunday, February 05, 2012 8:43 PM
> To: excel-macros@googlegroups.com
> S
l Message-
> From: Somnath Khadilkar
> Sent: Sunday, February 05, 2012 11:32 AM
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ Need a small MACRO to SPLIT
>
> Good even...
>I have attached a sample file
>
> depending upon colm A I need to split
Good even...
I have attached a sample file
depending upon colm A I need to split the whole DATA sheets into
multiple sheets in the same/diff. file each sheets be named as per the
COLM 'A', if possible. These entries are from few to many 100 K [ max
distinct cities < 25, however]
=mangal ho
Good Morning.
I receive XL file comprising 1-sheet. Depending upon Colm 'A' I
need to SPLIT this single sheet into MULTIPLE sheets [ with this colm
as it name. ] The Distinct entries in this colm. would be less than
say 25, but the no of entries cud be anything say 10 to 100 K.
Regards
--
F
18 matches
Mail list logo
