*Thanks Milindthanks a lot.*
On Mon, Mar 7, 2011 at 10:05 AM, mkarnik wrote:
> Quick reply for 2nd point:
> IN VBE,
> Select:
> Tools / VBA Project Propoerties / Protection
> Now enable "Lock Project for Viewing", enter password twice and click
> on OK.
> Most Imp: Do not forget the passowr
Quick reply for 2nd point:
IN VBE,
Select:
Tools / VBA Project Propoerties / Protection
Now enable "Lock Project for Viewing", enter password twice and click
on OK.
Most Imp: Do not forget the passowrd.
regards,
Milind
On Mar 6, 3:52 pm, "Indrajit $nai" wrote:
> Hi All,
>
> I need a urgent help
Hi ZAC,
I have created a user form as per your needs. The shortcut is CTRL + Y and
userform will pop up on this shortcut. The data will be updated on click of
submit button.
The fields will reset on data successfully updated.
Please have a look and let me know if any further assistance is require
Just have to add ' in front of Time to make it text. Then can be used in the
formula as desired outcome
_
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Amitabh Bose
Sent: Friday, August 07, 2009 3:45 PM
To: VBA_ Google
Subject: $$Excel-Macros$$ Ur
Hi All,
Apologies for sending this request. I seem to have found out the solution. I
wasted one whole hour trying to figure out something which was simple, but I
seem to have over looked how the formatting is done. Please do not waste your
time on this request.
Apologies once again.
some cells aren´t entered as date. Their values are text with the format
xx-xx-xx
You´ve to enter every cell and change it to date, and then format the number
as you wish...
2009/7/13 sachin patil
> Hi,
>
> I'm Very new for this group.I'm facing problem in Excel in Date Formatting.
> When I'
Hi Sachin,
You have entered date which seems as date but actually are strings. You have
to write dated in the format mm/dd/yy. So your date should be 03/31/09, not
31-03-09.
This will solve your problem
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
Hi,
Use text to column wizard in 3rd step select date and "DMY" format all your
dates will be converted to data format
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of sachin patil
Sent: 13 July 2009 PM 03:00
To: Excel
S
Hello,
Plz let me know below query.
On Thu, Jul 2, 2009 at 2:26 PM, vinod rao wrote:
> Hello,
>
> Can i know how was radio icon created linked to year 1,2 3.?
>
> Thanks in advance.
> Vinod
>
> On Wed, Jul 1, 2009 at 5:09 PM, Sachin Shukla wrote:
>
>> Dear Dilip,
>>
>> Thanks a lot. Its working
Hello,
Can i know how was radio icon created linked to year 1,2 3.?
Thanks in advance.
Vinod
On Wed, Jul 1, 2009 at 5:09 PM, Sachin Shukla wrote:
> Dear Dilip,
>
> Thanks a lot. Its working.
>
>
> Thanks
>
> Sachin Shukal
>
> On Wed, Jul 1, 2009 at 3:57 PM, Dilip Pandey wrote:
>
>> Hi Sachin
Dear Dilip,
Thanks a lot. Its working.
Thanks
Sachin Shukal
On Wed, Jul 1, 2009 at 3:57 PM, Dilip Pandey wrote:
> Hi Sachin,
>
> Attached sheet has been solved. Thanks,
> --
> DILIP KUMAR PANDEY
> MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.c
Hi Sachin,
Attached sheet has been solved. Thanks,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Tue, Jun 30, 2009 at 11:53 AM, Sachin Shukla wrote:
> Dear All,
>
> Please provied me help on attached sheet
Dear Daniel,
Thanks a lot for prompt respense. your formula is working properly.
But I could not understood logic. Can you explain your fourmula please?.
Why you multiply by 5 in (g3-1).
Thanks
Sachin Shukla
On Tue, Jun 30, 2009 at 7:25 PM, Daniel wrote:
> Try :
>
> =SUM(OFFSET(D13,(G3-1)*
I forget to link Here is the file.
- Original Message -
From: Sachin Shukla
To: excel-macros@googlegroups.com
Sent: Tuesday, June 30, 2009 11:53 AM
Subject: $$Excel-Macros$$ Urgent Help Required
Dear All,
Please provied me help on attached sheet.
Thanks
Sachin Sh
Hello Sachin can find the attached solution for your problem, You are doing it
in a long way (wrong) as there are only 9 choices and you are going to use
about 27 conditions (if conditions) for your solution, but i used only 8.
Remember if you are using IF function for a problem with N choices
Try :
=SUM(OFFSET(D13,(G3-1)*5,0,D2,1))
In cell D45.
HTH
Daniel
De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
la part de Sachin Shukla
Envoyé : mardi 30 juin 2009 08:23
À : excel-macros@googlegroups.com
Objet : [Norton AntiSpam] $$Excel-Macros$$ Urgent Help Re
Hi Sachin,
Please find enclosed the file as per your requirement.
Please let me know does that suffice your need.
On 6/30/09, Sachin Shukla wrote:
>
> Dear All,
>
> Please provied me help on attached sheet.
>
>
> Thanks
>
> Sachin Shukla
>
> >
>
>
--
Thanks & Regards
Ankit Mehra
--~--~---
Hi Dilip,
Thanks a lot for your respose.
This is something which i am expecting to perform. However, i forgot to
mention one thing in my previous mail.
It would be great if a macro could be created, where all these things (which
you have made in the file) could be automatically keeping in mind t
Can you please send the sample text file..
Regards,
Andy
On Fri, Jun 12, 2009 at 8:10 AM, Balachander S wrote:
> May be this is very simple for you experts . I am unable to crack the
> converiosn from Test file to excel for the data below.
>
> The fields are not aligned to draw column lines for
Good idea,
but we can come out of that situation.
Harish, Just put a line in the macro before msgbox:
activeworbook.save
hope that solves the issue
On Tue, Apr 14, 2009 at 8:55 PM, santosh bahuguna wrote:
>
> working with share file is much diffcult to fix this problem in excel
> becouse ev
working with share file is much diffcult to fix this problem in excel
becouse every user will seat in different different pcs and everytime
user have save the data to make the data sheet update my suguestion is
this please user msaccess to perform this task
thank
santosh bahuguna
On 4/11/09,
Hi Harmeet,
I used the other macro to fix my date and time issue since I was trying to
link this date and time with availble field in raw data but this was
refreshing so time was also refreshed but anyway I have fixed that but
eventually I have found that the data acquired is always misses the fir
One more thing,
You can also use shortcuts to enter time/date.
*Ctrl+;* to enter date
and *Ctrl+shift+;* to enter time.
On Mon, Apr 13, 2009 at 7:00 PM, Harmeet Singh wrote:
> Hi Harish,
> First of all, Thanks a lot for appreciation.
> If now I do the changes that you have mentioned in your ma
Hi Harish,
First of all, Thanks a lot for appreciation.
If now I do the changes that you have mentioned in your mail, will be a
spoon feeding.
I have not protected the code that I have sent you. It would be a good
learning for you if you try and do it by yourself. You just need to write
two lines s
Thanks a lot Harmeet...
Can u also get me one more functionality here that as soon as one agent
acquires the job time and date he acquired also appears and untill he
finishes the job by selecting as close which will be a drop down in next
column to acquired time column. Once agent uses close from d
25 matches
Mail list logo
