when you type a data ( event a dot ) in a cell,
the old data (incl. FORMULA) in the cell will be removed
and replaced with the new data.
with macro you can "automatically" keep the old data
(and stored in another place)
and then enter the new value in the same cell
cmiiw
On Mon, May 23, 2011 at
Hey Thanks Mahesh...its working fine for me...:)
On Sun, May 22, 2011 at 12:07 AM, Mahesh parab wrote:
> Hi Sagar
>
> find attach, check whether its as per u r requirement.
>
>
> Thanks,
> Mahesh
>
> On Wed, May 18, 2011 at 9:42 AM, sagar aher wrote:
>
>> Hi,
>>
>> Thanks ashish & Mahesh.
>>
Is there a way to keep the formula in the cell when you enter your own
value? Thanks in advance
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/excel
Thank you Asish. This works great!
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent: Friday, May 20, 2011 10:36 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Macro for Converting txt to xls using Text
Import Wizar
Ashsih,
Format of file is attached but no data
On Sat, May 21, 2011 at 8:29 AM, Skanda wrote:
>
>
> On Sat, May 21, 2011 at 12:39 AM, ashish koul wrote:
>
>> can you attach the sample file
>>
>>
>> On Fri, May 20, 2011 at 10:07 PM, Skanda wrote:
>>
>>> There are two data files say temp1_mon.
Hi Kannan,
To create a report in this format is not advisable. The data have to be in
contiguous, there should not be merged cell in between them. Maintain
listing productivity and broker productivity separately.
if you maintain it this way the data can be pulled in a numbers of ways in
seconds.
