try this
Sub test()
Application.CommandBars(Workbook tabs).ShowPopup
End Sub
On Wed, Oct 2, 2013 at 11:26 AM, Jewel Sharma jewelsha...@gmail.com wrote:
Hi,
I have a workbook with 8 worksheets; wherein I anticipate the user would
move to and fro between them in the course of using the
Also if u want to add worksheet navigation button on right click try this
*Add below code to workbook open module*
Private Sub Workbook_Open()
On Error Resume Next
'Delete the new button if already exists
' name of the new button is New Button
Hi Ashish,
This is great, but doesn't meet my need. Allow me to explain:
The workbook will have certain hidden sheets that the user does not need
to interact with. That is why I'm hiding the *Sheet tabs.* So, I need a
Navigation Pane that would allow the user to move only to the 8
worksheets
y dont u try pivot table
On Wed, Oct 2, 2013 at 12:28 PM, Chandra Shekar
chandrashekarb@gmail.com wrote:
Hello Asish,
Please find attached file I have got this result using SUM and IF formula
is there any other way to get the same result.
Regards,
Chandra
On Wed, Oct 2, 2013 at
Can anyone help me with a code
On Sep 24, 2013 9:11 PM, joseph camill joseph.cam...@gmail.com wrote:
Thanks for your response. I know to do it manually but my charts gets
updated very often. So I am looking for an automation.
On Sep 24, 2013 6:54 PM, Johnnyboy5 intermediatec...@gmail.com
try attached file
On Wed, Oct 2, 2013 at 12:01 PM, Jewel Sharma jewelsha...@gmail.com wrote:
Hi Ashish,
This is great, but doesn't meet my need. Allow me to explain:
The workbook will have certain hidden sheets that the user does not need
to interact with. That is why I'm hiding the *Sheet
please share the chart
On Wed, Oct 2, 2013 at 12:39 PM, joseph camill joseph.cam...@gmail.comwrote:
Can anyone help me with a code
On Sep 24, 2013 9:11 PM, joseph camill joseph.cam...@gmail.com wrote:
Thanks for your response. I know to do it manually but my charts gets
updated very often.
On Tuesday, October 1, 2013 10:18:15 PM UTC+8, asd...@gmail.com wrote:
vba returns total Fridays in A2:A6. If A2:A6 all are Fridays. The value
should be 5.
run your vba, the result as shown on Snap2.png is not I wanted.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna
Brilliant mate. Works very well.
On Wednesday, October 2, 2013 3:11:27 PM UTC+8, ashish wrote:
try attached file
On Wed, Oct 2, 2013 at 12:01 PM, Jewel Sharma jewel...@gmail.comjavascript:
wrote:
Hi Ashish,
This is great, but doesn't meet my need. Allow me to explain:
The workbook
Every 4 weeks are considered as 1 period that is the logic. And weeks are
starting from sun to sat.
This year was started on tuesday so last year's 2 days are also considered
in this calculations.
Sent from my iPhone
On Oct 2, 2013, at 10:17 AM, ashish koul koul.ash...@gmail.com wrote:
can u
On Wednesday, October 2, 2013 4:07:13 PM UTC+8, ashish wrote:
can u share hw wuld u like to see thn
if SUM((WEEKDAY(A2:A6)=6)) = 5 then ..
On Wed, Oct 2, 2013 at 1:01 PM, asd...@gmail.com javascript: wrote:
On Tuesday, October 1, 2013 10:18:15 PM UTC+8, asd...@gmail.com
=IF(B3=1,PR -1 ,IF(AND(MOD(B2,4)=0,MOD(B3,4)0),PR -
RIGHT(E2,LEN(E2)-4)+1,E2))
On Wed, Oct 2, 2013 at 1:43 PM, Avinash Patil avinash007pa...@gmail.comwrote:
Every 4 weeks are considered as 1 period that is the logic. And weeks are
starting from sun to sat.
This year was started on tuesday
Hi Experts,
We have 10 associates, they are updating the data in different excel
workbooks. at the end of the day i have to collate all those workbooks into
one. is there any way if we provide them one workbook with share mode. If
they update the data in the sheet. Only i have to get the
no its not possible with only excel... need to create another database like
..ms access or sql
.
Enjoy
Team XLS
On Wed, Oct 2, 2013 at 3:53 PM, Bv Dileep bvdil...@gmail.com wrote:
Hi Experts,
We have 10 associates, they are updating the data in different excel
Hi, Just now I heard that creating forms and bit of VB code will work is it
true?
On Oct 2, 2013 4:21 PM, xlstime xlst...@gmail.com wrote:
no its not possible with only excel... need to create another database
like ..ms access or sql
.
Enjoy
Team XLS
On Wed, Oct
123trainings provides the best MSBI Online
Traininghttp://123trainings.com/it-ms-bi-online-training.html from
Hyderabad.. we have dedicated faculty who can guide the students in the
best way.. our faculty has more than 5 years of Experience and they are
working from top MNCs.. Our motto is to
Can u explain it in detail
Sent on my BlackBerry® from Vodafone
-Original Message-
From: asd...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Wed, 2 Oct 2013 01:22:20
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re:
123trainings provides the best Cognos Online
Traininghttp://123trainings.com/it-ibm-cognos-online-training.htmlfrom
Hyderabad.. we have dedicated faculty who can guide the students in
the best way.. our faculty has more than 5 years of Experience and they are
working from top MNCs.. Our
On Tuesday, October 1, 2013 10:18:15 PM UTC+8, asd...@gmail.com wrote:
vba returns total Fridays in A2:A6. If A2:A6 all are Fridays. The value
should be 5.
--
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 official Facebook page of
On Tuesday, October 1, 2013 10:18:15 PM UTC+8, asd...@gmail.com wrote:
vba returns total Fridays in A2:A6. If A2:A6 all are Fridays. The value
should be 5.
Plse refer to the attached example.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
Hi, could please send me any tutorial link or document. That would be great.
On Oct 2, 2013 5:32 PM, koul.ash...@gmail.com wrote:
**
Use excel as front end and access as back end to store information
Create an access database with tables , etc save it in a share folder
Create userform in
*try these *
*https://app.box.com/s/zxhxpoitad7sih0wpigl
*
*https://app.box.com/s/szaxukie20xnutka8f3e*https://app.box.com/s/szaxukie20xnutka8f3e
*
https://www.facebook.com/photo.php?fbid=525682004167816set=a.209740072428679.47011.15180389897type=1theater
*
On Wed, Oct 2, 2013 at 6:13 PM, B
Thanks for your quick response. And please do let me know in this forum is
anyone resides in Hyderabad and if you are ready to teach VBA. Please let
me know
On Oct 2, 2013 6:15 PM, ashish koul koul.ash...@gmail.com wrote:
*try these *
*https://app.box.com/s/zxhxpoitad7sih0wpigl
*
Hi,
I know how to insert the image. The thing is I want the cell to always be
always the same size.
Any advice ?
Thanks.
--
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 official Facebook page of this forum @
try this see if it helps
Sub test()
ActiveSheet.Pictures.Insert (C:\Users\admin\Desktop\Excel Tips
Tricks\01.jpg)
With ActiveSheet.Shapes(ActiveSheet.Shapes.Count)
.Left = Range(a1).Left
.Top = Range(a1).Top
.Width = Range(a1).Width
.Height = Range(a1).Height
End With
End Sub
Hi Experts,
PFA, kindly let me know is there any formula to sum-up the col B nos into
col D.
As of now I am doing it manually, but it's very long term process!
Kindly let me know is there any way out to do it through any formula.
Thanks in advance.
--
Indrajit
Disclaimer:
This electronic
Hi All,
Any update on this?
Regards,
Ashwani
On Wed, Oct 2, 2013 at 7:20 PM, ashwani agnihotri
ashwani.agniho...@gmail.com wrote:
Hi All,
I have attached an excel for reference I want to know if I can create a
dashboard werein if I select a team , the rest of the data about the team
link is :
https://secure.fundsupermart.com/main/fundinfo/dailyPricesHistory.tpl?id=DBSAUD
--
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 official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use
You can use the the links (linked tables) as like original table.
Means,
You can directly open the link and paste the data.
You can refer the linked table in queries, forms, reports and even macros
modules.
Regards,
Kishan Reddy, K
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And
Dileep,
You can contact me, I am sending my contact details through mail.
Regards,
Kishan Reddy, K
On Wednesday, October 2, 2013 6:34:34 PM UTC+5:30, Bv Dileep wrote:
Thanks for your quick response. And please do let me know in this forum is
anyone resides in Hyderabad and if you are ready
30 matches
Mail list logo