Dear Harpeet
You can download Microsoft Office Compatibility Pack from the below link:
http://office.microsoft.com/en-us/products/HA101686761033.aspx
Regards
Yahya
On Sat, Feb 6, 2010 at 9:19 PM, Harpreet Singh Gujral <
harpreetguj...@gmail.com> wrote:
> Hi Dilip,
>
> Th
Hi
I have a workbook which has a no of worksheets. I want to hide all those
worksheets automatically, when the value of a particular cell (Say C1) in
that worksheet is zero. Can someone help me with the code for it?
Regards
Yahya
Thank you, Ayush. This is exactly what I wanted.
Regards
Yahya
On Sun, Feb 7, 2010 at 1:21 PM, ayush jain wrote:
> Hi Yahya,
>
> Attached is the solution. Use the below code in ThisWorkbook code section.
>
> Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal
Dear Mark
I think you can do it by just using a Hyperlink. No need for macros. Please
see the attached file
Yahya
On Mon, Mar 22, 2010 at 2:37 AM, Markkim wrote:
> Hi
>
> I am wondering if anyone can help me creating a macro for the
> following..
> Get a reference from the se
has to be done manually.
I would like to have the autofilter automatically refresh when the cell
value is changed. (ie I want the autofilter to refilter the column D, taking
into account the changes in each cell of the column). A sample file is
attached
Your help is much appreciated.
Thanks Paul. This was what I needed. I used the code in the first sheet.
Regards
Yahya
On Mon, Apr 12, 2010 at 5:54 PM, Paul Schreiner wrote:
> You could create a Sheet Activate event that would refresh your filter:
>
> on the sheet tab name, right-click
>
> Private Sub Wor
-- Forwarded message --
From: Yahya
Date: Fri, Apr 16, 2010 at 10:07 PM
Subject: Re: $$Excel-Macros$$ Refresh Autofilter Automatically
To: chreiner_p...@att.net
Sorry Paul, to bother you again.
Everything was working fine till I sorted the worksheets. Now I am getting
an
blank) Please help.
Regards
Yahya
On Apr 12, 9:15 pm, Yahya wrote:
> Thanks Paul. This was what I needed. I used the code in the first sheet.
>
> Regards
>
> Yahya
>
> On Mon, Apr 12, 2010 at 5:54 PM, Paul Schreiner wrote:
>
>
>
> > You could create a
Find a folder named "XLSTART" in the Program files --->Microsoft Office --->
Office12 and place the excel file there.
Regards
Yahya
On Tue, Apr 20, 2010 at 10:05 AM, shivashankar katageri <
shankarkatag...@gmail.com> wrote:
> Dear all,
>
> please luk t
Dear all
I use the attached excel sheet to calculate the profit/loss in the trading
of individual stocks. The formula works fine in normal cases. But whenever
there is some bonus/stock split etc. it fails. Can someone help me to derive
a formula that will suit all cases?
--
Regards
Yahya
Dear all
Can someone help me in this or provide a better spreadsheet?
On Mon, Oct 18, 2010 at 8:47 AM, Yahya wrote:
>
> Dear all
>
> I use the attached excel sheet to calculate the profit/loss in the trading
> of individual stocks. The formula works fine in normal case
o this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.
Dear Tareq
Which are the programs you use to crack the
1. Excel file password
2. vba password
Thanks
Yahya
On Mon, May 18, 2009 at 4:52 PM, tariq wrote:
>
> hello mahesh,
>
> this file password is : AABBBAABBAAP
>
> AND ANY PASSWARD CRACKING SO MAIL ME ...
>
&
Dear Ashish
Which version of Excel you are using?
Yahya
On Fri, Jun 12, 2009 at 12:44 PM, Ashish Pradhan wrote:
>
> Hi
>
> I have downloaded some tables in excel using Copy/Paste Function (Not
> the "Get External Data" feature). Unfortunately, there are a lot of
&
Special.)
5. Select the Multiply radio button.
6. Click OK. All the hyperlinks are removed, but the text of the
hyperlinks remain.
7. Delete the cell you created in step 1.
Yahya
On Sat, Jun 13, 2009 at 11:38 AM, Ashish Pradhan wrote:
>
> Dear Yahya
>
> Thanks for y
Dear Manoj
For this, you have to download Microsoft Office Compatibility Pack from the
below link:
http://office.microsoft.com/en-us/products/HA101686761033.aspx
Yahya
On Wed, Sep 9, 2009 at 12:06 PM, Manoj Kukrej wrote:
> How I open xlsx file of 2007 in 2
Dear Mahesh
Try to use the attached program.
Yahya
On Fri, Sep 25, 2009 at 2:02 PM, Mahesh wrote:
> Dear friends,
>
> Need your help.
>
> i want to convert decimal coordinates into DDMMSS.
>
> 9.73877= 09 44 20
>
> --
me to
the previous cell where it was before (based on that cell ref). What I need
is to hyperlink the text so that even if the cell ref of that text changes,
the hyperlink will take me to it.
Attached a sample file.
Any solutions, please
Dear Ralf
Yes. It is working. Thanks
Yahya
On Sun, Oct 11, 2009 at 5:27 PM, RolfJ wrote:
>
> The simplest solution to this is to define names for your target
> cells.
>
> This is how you do that, e.g. for 'Ann': highlight the cell Ann in
> your Master sheet a
acros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><>&l
Hi Experts
I have an excel workbook, say Workbook1 with a vba on its workbook_open
event to hide all worksheets except one, as follows:
-
Private Sub Workbook_Open()
Dim sh As Worksheet
For Eac
Dears
Any solution, please !
On Mon, Mar 2, 2015 at 11:24 AM, Yahya Muhammad wrote:
>
> Hi Experts
>
> I have an excel workbook, say Workbook1 with a vba on its workbook_open
> event to hide all worksheets except
s that on workbook2 is the same event procedure
> as above. It is not possible that event procedure from one workbook
> influences another. Check macros in workbook2. Does all of workbooks go
> hidden when opening?
>
> Regards
>
> W dniu poniedziałek, 2 marca 2015 09:25:24 U
Hi Sumesh
Please see the attached file. It has both conversions.
On Tue, Apr 28, 2015 at 11:14 AM, Sumesh Nair wrote:
> Hi Excel Beginner,
>
> I want your help in converting the date in two columns in Excel.
>
> If in one column(A1) I will enter Hijri Date the next column(B1) should be
> change
Hi Prince
Thanks a lot. It's working fine.
On Wed, Dec 19, 2012 at 7:52 PM, Prince wrote:
> Hi Yahya,
>
> PFA.
>
> Regards
> Prince
>
> On Wednesday, December 19, 2012 7:21:41 PM UTC+5:30, Yahya Muhammad wrote:
>>
>>
>> Dear experts
>>
Dear experts
I have an excel file to track the bank transactions. It has a debit column
for the withdrawals and credit column for the deposits. I can get the
running totals by adding another column and just using simple excel
formulae. However, sometimes I want to find the running totals in the
ac
;&F2,A:A,"<="&G2)
>
>
>
> On Mon, Jan 7, 2013 at 7:06 PM, Yahya Muhammad wrote:
>
>>
>> Dear experts
>>
>> I have an excel file to track the bank transactions. It has a debit
>> column for the withdrawals and credit column for the depo
Thanks excel learner.
On Tue, Jan 8, 2013 at 7:16 AM, Ms-Exl-Learner wrote:
> *Compatible, Faster & Shorter Length formula
>
> **=SUMPRODUCT((A2:A11>=F2)*(A2:A11<= G2),(-B2:B11)+(C2:C11))*
>
>
>
>
> On 07-01-2013 9:00 PM, Yahya Muhammad wrote:
>
>
&
Dear Experts
I have a workbook with a no. of worksheets. New worksheets are being added
to it regularly. I am using below code to sort the worksheets after the
addition of any new sheets. Now I need your help to modify this code so
that it will keep some of the sheets (say named "Summary", "Profil
Thanks David. Got it.
On Fri, Jan 18, 2013 at 1:24 PM, David Grugeon wrote:
> Put the four sheets at the beginning of the workbook and change the "for x
> =1to worksheets.count". To "for x = 5 to worksheets.count"
>
>
> On Friday, 18 January 2013, Yahy
Dears
I have an excel userform with a combobox which select the items from
a column in a worksheet. This column can't be sorted. I would like to have
the list in the combobox to get sorted ascending, while initializing the
userform. I am now using below code to load the combobox with values. Can
Dear Anil
Thanks. However, I can't adapt this method , as my combo box is in a
userform and I cannot sort the column in the worksheet.
On Tue, Jan 29, 2013 at 9:12 AM, अनिल नारायण गवली
wrote:
> Dear Yahya,
>
> Pl see the attached sheet is it ok?
>
>
> Warm Regards,
Dear Anil
Thanks again. However, here also the sorting occurs in the sheet, which I
do not want.
On Tue, Jan 29, 2013 at 9:25 AM, अनिल नारायण गवली
wrote:
> Dear Yahya,
>
> See the attached sheet . is it ok??
>
> Wrm Regards,
> Gawli Anil
>
> On Tue, Jan 29, 2013 at
click button which column on Ascending & Decending then that column
> sort with other data.I send Example file pls see it
> Appreciate the help.
>
> Regards
> Amar
>
> On Tue, Jan 29, 2013 at 2:46 PM, Yahya Muhammad
> wrote:
> > Dear Anil
> >
> >
Hi
Please find the attachment with the solution.
On Tue, Feb 5, 2013 at 9:50 PM, Secret Shot wrote:
> Dear Group,
>
> I need your expertise, in creating Macro to hide rows, requirement is
> mention in attach file. I attached a sample file to explain my requirement.
> please Help.
>
> --
> Pank
Hi Amar
Please see attached file. I used check boxes to Hide/Unhide sheets.
On Mon, Feb 11, 2013 at 12:54 PM, amar takale wrote:
> Dear All,
> Pls suggest VBA Code I attached detailed in sheet
> Regards
> Amar
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>
Dear Kumar
Please see below link.
http://www.techonthenet.com/excel/cells/hide_formulas2007.php
On Mon, Feb 25, 2013 at 9:09 AM, kumar.ashish861
wrote:
> Hi Group,
>
> I want to hide a formula in cell. then, what should i do for this. plz
> provide solution for the same.
>
>
>
> Thanks
> As
Dear Kuldeep
Please see the attachment.
On Sat, Apr 20, 2013 at 8:00 AM, Kuldeep Singh wrote:
>
> Hi Experts,
>
> I want to hyperlink by sheets name. Example attached.
>
> Thanks in Advance..
>
> Regards,
> Kuldeep Singh
> Info Edge India Limited (naukri.com)
> Phone.: +91-0120-4841100, Ext
Dear Mickey
Yes. It can be achieved by creating Named Ranges. See below link:
http://excel.tips.net/T003466_Tying_a_Hyperlink_to_a_Specific_Cell.html
On Fri, Nov 22, 2013 at 1:01 AM, Mickey Davis wrote:
> I have a spreadsheet with links to various cells. The sheet is constantly
> changing, so
Hi Rajesh
Please find the attachment. Is this what you are looking for?
On Tue, Dec 3, 2013 at 3:53 AM, Rajesh Agarwal wrote:
>
>
> --
> *Rajesh Kumar Agarwal*
> *9811063001*
>
> --
> 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) ! Join officia
Hi Naidu
Please find the attachment.
On Thu, Jan 16, 2014 at 7:14 PM, Grkrishna Naidu wrote:
> Dear Experts
>
> I need your help to solve the issue
>
> I have have a master data under following heads
>
> PRODUCT CODE, PRODUCT NAME , START DATE, MRP, PTS, PTR
>
>
> I NEED THE OUTPUT DATA (
Try this :
http://www.utteraccess.com/forum/forums.html
On Sat, Feb 22, 2014 at 7:40 AM, Amit.Desai (MERU)
wrote:
> Dear Friends,
>
>
>
> Please suggest any good group for MS Access.
>
>
>
> Regards,
>
> *Amit Desai *-
>
>
>
> --
> Disclaimer: This message and it
Dear Haseeb
This is much better than what I expected ! Thanks a lot !!
On Sat, Mar 3, 2012 at 1:23 AM, Haseeb Avarakkan wrote:
> Hi Yahya, See the attached.
>
> ___
> HTH, Haseeb
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) U
Dear Subhash
In addition to Rajan's excellent solution, if you just want to toggle
between sheet 2 and 11, you can use hyperlink in both of the sheets. For
this just type "Take me to Sheet 12" in any empty cells of Sheet 1 and
right click on it. Hyper link >> Link to >> Place in this document >>C
Hi experts
I want to compile the annual leave schedule of each staff in the department
in excel. The idea is to have all the schedule in one work sheet, for easy
comparison and to know the leave overlapping,if any, at one glance.
Currently I am using the attached sheet, which I think, can be
modif
Dear Paul
Thanks for the support. Yours is an excellent attendance tracker, which is
much more than what I needed. Can I have a simple, single sheet vacation
planner, similar to the one I have attached ?
On Wed, Oct 24, 2012 at 9:19 PM, Paul Schreiner wrote:
> YahYa,
>
> Here is a
n,
> As long as ever you can.” - John Wesley
> *-
>
>
> --
> *From:* Yahya Muhammad
> *To:* excel-macros@googlegroups.com
> *Sent:* Thu, October 25, 2012 4:00:10 AM
>
> *Subject:* Re: $$Excel-Macros$$ Highlight annual leave schedule of each
> staff for easy comparison
>
. When I
select any worksheet name from the combo box, it should take me to that
particular worksheet. Can someone help me with a solution please?
Thanks and regards
Yahya
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles
ear Yahya,
>
>
> Please try below code and see attached sheet..
>
> Private Sub ComboBox1_Change()
> Sheets(ComboBox1.Value).Activate
> End Sub
>
> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
> Dim sh As Worksheet
> For Each sh In Worksheets
> Sh
; Private Sub Worksheet_Activate()
> Sheet1.ComboBox1.Clear
> Dim sh As Worksheet
> For Each sh In Worksheets
> Sheet1.ComboBox1.AddItem (sh.Name)
> Next
> End Sub
>
> On Mon, Nov 28, 2011 at 11:09 AM, Yahya Muhammad wrote:
>
>>
>> Thanks Noorain. But the issu
Thanks Noorain and Ashish
On Mon, Nov 28, 2011 at 10:58 AM, NOORAIN ANSARI
wrote:
> Dear Yahya,
>
> Please check attached sheet with Userform.
>
>
> On Mon, Nov 28, 2011 at 12:47 PM, Yahya Muhammad wrote:
>
>> Thanks Ashish. It does the trick. Just one more question.
Dear Saurabh
Please visit below url. A similar case is neatly explained there.
http://www.get-digital-help.com/2010/07/17/create-dependent-drop-down-lists-containing-unique-distinct-values-in-excel/
Regards
Yahya
On Tue, Dec 13, 2011 at 9:05 PM, dguillett1 wrote:
> You don’t
Dear Yasir
Please find the solution in the attached file.
On Sat, Jan 28, 2012 at 10:12 AM, yasir_shahjee wrote:
> Respected Masters,
>
> Kindly check attached sheet. i need Time calculate in Hours. hopefully its
> really easier for Masters.
>
>
> thanks
>
> --
> Yasir Waheed
> Factory Manager
Hi Priyanka
Yes. But there is a work around for it using VBA . But without using any
codes. It goes like this:
1. Right click on the sheet tab to be made hidden, View Code. See the
properties menu on the left bottom window. Choose the visible mode as "2-
XLSheetVeryHidden"
2. Then
54 matches
Mail list logo