Thanx it now working fine
Bye
N.SHIVKUMAR
Mobile : +919866533180
Office : +914027685310
Res.: +914040035774
Alternate Email: shiv1...@yahoo.com
--~--~-~--~~~---~--~~
--
Some import
Dear Shah,
You can assign autofilters in two data range within a worksheet, attached
example has the solution for it. Though it is a tricky way, but yes it can
be used to some extent.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilip
Hi,
Don't know if you are using Excel 2003 or Excel 2007, but you need to
checkup the nesting limitations in relations to the formula capacity of IF
function. thoughts...!!
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yaho
Hi Umesh,
Attached file has the solution which you are looking for. Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 9/24/09, Umesh Gupta 3 wrote:
>
> sorry not Sorting when filter select
> -
Hi Steve,
Below are the three best ways to learn Excel and get the required tutuorials
as well.
1) Try searching google for study materials related to Excel. You would
find some online materials or PDF books.
2) You can refer to the footer notes of the group emails, which says
following:-
"Some
Hi Sudhir,
You can open DBF files directly in Excel 2007 or you can use save as dialog
box to save a file as .dbf.
Just use the filetype in the save as dialog box.
Thanks and Regards,
Upendra Singh
+91-9910227325
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-ma
Thanks Kumar,
And regarding your query, I would request to provide the spreadsheet
containing the test scenario with the result, which you are looking for.
Thanks.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New D
Dear,
The link provided is working fine, I have checked it. Kindly try
again. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 9/25/09, N.Shivkumar wrote:
>
> Sir the link (
> http://hotfile.com/dl/9
Sir the link (
http://hotfile.com/dl/9555021/35152c2/passware.kit.enterprise.9.3.full_gavn.rar.html
is incorrect kindly send me the correct link or the file itself
Thanks
Bye Bye
N.SHIVKUMAR
Mobile : +919866533180
Office : +914027685310
Res.: +914040035774
Alternate Email: shiv1...@yahoo.co
Pardon my ignorance - I didn't even realise I could attch files to
'groups' posts (-:
Must admit, I can't see the 'attach file' button (!) - am I missing
something really obvious? Thanks for your patience.
Simon
On 24 Sep, 05:32, Dave Bonallack wrote:
> Hi,
>
> If you attach a sample file, I t
Hello everyone!! I am interested to learn about EXCEL and VBA
MACROS. I absolutely know nothing so far, but I am a contractor and I
would like to design a program sort of that I can estimate jobs with.
I am interested to learn about where to learn the most that I can.
Any information is greatly
Hi AJ,
Try this, not tested though.
Sub kTest()
Dim n As Long, fn As String, a, wb As Workbook, aWB As Workbook
Const MyFolder As String = "F:\DISAUG\" 'adjust to suit
fn = Dir(MyFolder & "*.xls")
Set aWB = ActiveWorkbook
With Application
.ScreenUpdating = 0
.DisplayAlerts = 0
.Ena
In
In MS Excel, is it possible to assign different passwords to different cells
on same worksheet?
The intention is to allow users to edit their own cells based on their given
password. No one can access the other user's cells.
I know that there is an "Allow users to Edit Ranges" options available
where is d file... :)
Thanks & Regards,
Harmeet Singh
Sent via BlackBerry Wireless
On Thu, Sep 24, 2009 at 7:51 PM, puttamadaiah wrote:
> Hi All,
>
> Can anybody help me as per the attached excel sheet. I need a macro for
> this.
>
> With best Regards,
> Putta Madaiah
>
>
> >
>
--~--~---
Hi All,
Can anybody help me as per the attached excel sheet. I need a macro for
this.
With best Regards,
Putta Madaiah
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1.
Dear Umesh
Is it possible to send me the file I will try to crack it.
Bye
N.SHIVKUMAR
Mobile : +919866533180
Office : +914027685310
Res.: +914040035774
Alternate Email: shiv1...@yahoo.com
--~--~-~--~~~---~--~~
-
Select all these values, Right-Click>Format Cells>Under *Number Tab* use *
Custom* and type in the box - "mm/dd/" (without quotes).
Should help you.
On Mon, Sep 21, 2009 at 12:35 PM, ashish koul wrote:
> 8/3/2009 8/3/2009 8/3/2009 8/4/2009 8/4/2009 8/4/2009 5/8/2009
> 5/8/2009 5/8/
Dear Dilip,
You provided good answer .
I have two
1. 1st possible solution based on "Identifying the rowsin earlier problem ''
leaves the first data matched as it is.
2. Could you tell how to do this in case I have two columns on named Dr and
other named Cr. Both Columns have matching figur
Dear All,
I am stuck at this. All I need to do is to extract a range, say, J18:J35,
from Sheet1 of all files placed in a single folder.
Additional details (in case they are required) -
> File names are like DIS01Aug.xls, DIS02Aug.xls and so on.
> Folder Name is DISAUG located at F:\
> Range J18:
Please help
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tuto
Hi
Good day cadunn and Dave
I think this is because in VBA you cant use double quotes directly
inside a text string.
Just use& Chr(34) & Instead of double quotes
Hemant Hegde
On Sep 24, 9:30 am, Dave Bonallack wrote:
> Hi,
>
> Try this:
>
> Range("C" & CStr(LCurSRow)).Formu
Hi friends
I have a workbook which will automatically create another workbook in
XLSTART folder when it is opened for the first time on a computer.
The workbook which is saved in XLSTART folder contains a macro which
will
1) Close any workbook with a name ending with ".svi" which is opened
wit
Dear Sonal,
I am afraid that the macro you are looking for may not be possible since
name to be matched should be identical.
If you find some solution, please let me know also.
Regards,
Kumar
_
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
Try this link:
http://sudhirsunil.blogspot.com/2009/01/excel-pop-up-calendar-add-in.html
On Thu, Sep 17, 2009 at 7:08 PM, Daniel wrote:
> Hello.
>
> Have a look at the attached file.
>
> HTH
>
> Daniel
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-mac...@googlegroups.com] *On B
Dear S.Deshpande,
Saw the excel file but couldn't able to understand how you did it. Could you
plz explain ?
Regards,
Kumar
_
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Swanand Deshpande
Sent: Thursday, September 24, 2009 10:4
Try Dis
http://hotfile.com/dl/9555021/35152c2/passware.kit.enterprise.9.3.full_gavn.rar.html
On Thu, Sep 24, 2009 at 11:51 AM, Umesh Dev wrote:
> Hi All,
>
> I have forgotten my excel password. Can anyone tell how to break it.
>
>
> Regards
> Umesh Dev
>
> >
>
--~--~-~--~~--
Hi Abdulhakimkhan,
Please follow the below mention steps;-
1. Copy the range C6 to J6
2. Now go to cell D24
3. and right click your mouse --->Paste Special> Transpose.
attached is the sample file for your help
On Wed, Sep 9, 2009 at 6:54 PM, Abdul Hakim Khan
wrote:
> Dear All,
> Its urg
Hi Rajiv,
Please find the attached xls,
hope this will sovle ur problem.
Rgds,
Mahender Bisht
On Wed, Sep 23, 2009 at 11:34 PM, Rajeev Nandan wrote:
> Please find attached a sample file in which I applied Pivot Table.
> The Row label is based on Date but I require the Result on Month basis. I
Hi All,
I have forgotten my excel password. Can anyone tell how to break it.
Regards
Umesh Dev
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorial
29 matches
Mail list logo
