Dear Excel Experts
I want to select a date which is either equals to or lesser than the
select date.
For Example
in Column 1 I have different dates
01-Apr-2010
01-Jul-2010
15-Aug-2010
01-Oct-2010
15-Nov-2010
08-Aug-2010
(sorted and un sorted both)
In Cell B2 I have entered a date, say.
dear
B Sharma
please send me the sheets
sanjib
On Wed, Oct 12, 2011 at 12:37 PM, B Sharma sharma@gmail.com wrote:
Dear Excel Experts
I want to select a date which is either equals to or lesser than the
select date.
For Example
in Column 1 I have different dates
01-Apr-2010
Dear All,
I need shortcut key for all border.plz help me.
Regards,
Ankit
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our
Dear Suman,
Please use the below mentioned formula
Function put_date(input_your_date As String) As String
Dim splt
splt = Split(input_your_date, /)
put_date = Format(DateSerial(splt(2), splt(1), splt(0)), mm-dd-)
End Function
On Tue, Oct 11, 2011 at 6:38 PM, Suman ksuman1...@gmail.com
*Hi,
Pls use
CTRL+SHIFT+ *
Regards
Amresh
On Wed, Oct 12, 2011 at 12:19 AM, Ankit Agrawal
ankit.agrawal...@gmail.comwrote:
Dear All,
I need shortcut key for all border.plz help me.
Regards,
Ankit
--
--
Hi Expert,
I needed the formula which can extract the specific content from a Text, below
is some sample excel cells
To simplify this there is / sign after each content, and I need exact data
which start after 4th / and till 5th / (which is mention below in Red).
Can anybody tell me the
Dear Ankit,
Please find below Short Cut keys,I hope it will help to you.
1. *Apply* an outline border
*[Ctrl]+[Shift]+[] *
2. Remove the outline border
*[Ctrl]+[Shift]+[_] *
3. Toggle the left border on the selected cells
[*Alt]+[L] *
4. Toggle the right border on the selected cells
Hi,
How can I insert one Header footer for entire workbook.
Regards,
Ankit
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join
Thanks but it is not working.
Regards,
Ankit
On Wed, Oct 12, 2011 at 2:55 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Ankit,
Please find below Short Cut keys,I hope it will help to you.
1. *Apply* an outline border
*[Ctrl]+[Shift]+[] *
2. Remove the outline border
Hi Anil,
I Assume that your data is in Column A and your first row is having the
column header.
So your data will start from 2nd row of Column A (i.e. from A2 cell)
A1 Data
A2 /ENTRY-10 OCT TRF/REF 6004ABS6834230 /ORD/ Q-FAST TELECOM BV
STRIJKVIERTEL 26 A 3454 PMDE MEERN /BNF/ INVOICENO
Dear Ankit,
Please Click on the first worksheet tab, and while holding down shift, click
on the
last worksheet tab to group the sheets.
Then click *FILE* in the menu, select PAGE SETUP and click the HEADER/FOOTER
tab. Add your header as you normally would and it will be assigned to all
selected
I need it in 2007.
Regards,
Ankit
On Wed, Oct 12, 2011 at 3:34 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Ankit,
Please Click on the first worksheet tab, and while holding down shift,
click on the
last worksheet tab to group the sheets.
Then click *FILE* in the menu, select
Hi experts,
How to open a file from user via browse in VBA
Thanks
Akhilesh
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our
reference : Microsoft Office 10 object libarary need to download
Private Sub Command0_Click()
Dim fd As FileDialog
Set fd = Application.FileDialog(msoFileDialogFilePicker)
Dim vrtSelectedItem As Variant
With fd
If .Show = -1 Then
For Each vrtSelectedItem In .SelectedItems
MsgBox The path is:
Hi,
You can use Application.findFile(FileFilter) method.
On Wed, Oct 12, 2011 at 3:56 PM, airen airen1...@gmail.com wrote:
Hi experts,
How to open a file from user via browse in VBA
Thanks
Akhilesh
--
--
Dear Anil,
See attached sheet if it help to u..
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Wed, Oct 12, 2011 at 1:20 PM, Anil Bhange
Amazing... Ms-Exl-learner...
This is exactly what I wanted... I was pretty sure this forum only can help me
with solution...
Thanks once again.. this saves my lot of time...
Regards,Anil Bhange
IP Phone - 512320 | Mobile - 90290 32123
From: excel-macros@googlegroups.com
Dear Sanjib.
there is no option there to attach the file
please help
On Oct 12, 12:16 pm, Sanjib Chatterjee chatterjee.kolk...@gmail.com
wrote:
dear
B Sharma
please send me the sheets
sanjib
On Wed, Oct 12, 2011 at 12:37 PM, B Sharma sharma@gmail.com wrote:
Dear Excel
Hi Anil,
Thanks for your reply and you are welcome!
But I am a part time visitor of this group and you can find my replies only
for the questions which is interesting to work with it.
From my point of view many of the extra-ordinary excel forums / discussion
groups are available and this is one
Dear Sunil,
Please try below code...
First you add Microsoft Outlook Library..
Step: Press Alt+F11-Tools-Reference-check Microsoft Outlook 12.0 Object
Library..then run code...
hope it wil be help to u..
Sub mail_current_workbook()
Dim olApp As Outlook.Application
Dim olMail As
My Dearest,
I have required a business billing format where we can genrate the company
invoice it will convert in to PDF also send to respective people. pls
give me format for it if you have any.
Regards
Amresh
--
B. sharma.
goto vba = module1=paste the code
in excel write a date = inset the function from userdefined function
Sanjib
On Wed, Oct 12, 2011 at 4:43 PM, B Sharma sharma@gmail.com wrote:
Dear Sanjib.
there is no option there to attach the file
please help
On Oct 12, 12:16
Dear All,
If an excel file contains 1000's of emails ids in a column say as below :
'pi...@gmail.com --- in Cell A1
'ti...@gmail.com--- in Cell A2
li...@yahoo.com --- in Cell A3
zi...@yahoo.com--- in Cell A4
I need a formula to make all these email id as : *pi...@gmail.com,
Hi Sanjib ... can you please send me your email id so that i can
send you a sample file..
On Oct 12, 5:02 pm, Sanjib Chatterjee chatterjee.kolk...@gmail.com
wrote:
B. sharma.
goto vba = module1=paste the code
in excel write a date = inset the function from userdefined function
Hi,
In this case it should be 01-oct-2010
Thanks
Airen
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @
Hi.apply this formula in cell C3 =B1+MAX(IF(A1:A6-B1=0,A1:A6-
B1,-1000)) followed by hitting shift+control+enter
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
You say “single LINE”. Do you mean one cell ? If so, NO.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Ahmed Honest
Sent: Wednesday, October 12, 2011 7:12 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Solution Request
Dear All,
If an excel file contains 1000's of
Hello newsgroup,
I tried the following code to create an ActiveX checkbox under Excel:
- Create new workbook.
- Add following code to worksheet 1
Sub test()
Me.Shapes.AddOLEObject Forms.CheckBox.1, , False, False, , , ,
100, 100, 100, 100
End Sub
- Execute code
Now I have got a worksheet
Thanks people.
Airen
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @
**Hi,
Hope it helps.
Regards
Shiek
On Wed, Oct 12, 2011 at 6:24 PM, dguillett1 dguille...@gmail.com wrote:
You say “single LINE”. Do you mean one cell ? If so, NO.
Don Guillett
SalesAid Software
dguille...@gmail.com
*From:* Ahmed Honest ahmedhon...@gmail.com
*Sent:* Wednesday,
Dear Mr. Shiek,
Tons of thanks for your help. I hope that U achieved it by VBA but is there
any formula of excel to achieve this?
Dear Mr. Don Guillet,
Thanks for your inputs as well...!
Regards
Ahmed Bawazir
On Wed, Oct 12, 2011 at 4:02 PM, Shiek Peer Mohd shiekp...@gmail.comwrote:
**Hi,
Hi Expert,
how to create a macro for Microsoft outlook. Eg.if i just run the macro the
selected file should attached in new mail.
--
*Regards*
**Sunil B.N
***9035858585
--
--
Some important links for excel
Hi,
I have a workbook with around 100 worksheets. The first sheet acts as
a summary/introductory or front end and has links to other sub-
sheets. In the first sub-sheet I've created a button containing a
macro that returns you to the introduction sheet. What I'd like to do
is copy this button
Here's the formula, where your dates start from A2 to A7
=SUMPRODUCT(MAX(($A$2:$A$7=B2)*($A$2:$A$7)))
Regards
Sam Mathai Chacko
On Wed, Oct 12, 2011 at 5:45 PM, B Sharma sharma@gmail.com wrote:
Hi Sanjib ... can you please send me your email id so that i can
send you a sample file..
Dont Use Shapes , use this Code
ActiveSheet.OLEObjects.Add(classtype:=Forms.Checkbox.1)
On Wed, Oct 12, 2011 at 6:26 PM, Stuart Redmann dertop...@web.de wrote:
Hello newsgroup,
I tried the following code to create an ActiveX checkbox under Excel:
- Create new workbook.
- Add following
Put this macro in the THISWORKBOOK module. Now when you double click cell a1
in any sheet you will go to sheet1
Change name and cell to suit
Private Sub Workbook_SheetBeforeDoubleClick _
(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
If Target = Sh.Range(a1) Then
it is so easy, if you use hyperlink instead of button
Divaker
On Wed, Oct 12, 2011 at 5:15 PM, Eddie eddiejame...@googlemail.com wrote:
Hi,
I have a workbook with around 100 worksheets. The first sheet acts as
a summary/introductory or front end and has links to other sub-
sheets. In the
I Create a macro to an Index Sheet..
Hope it will be Usable
Sub MakeComponentinRunTImeOnSpreadSheet()
On Error Resume Next
Dim cb As OLEObject
n = 5
For i = 1 To 10
Set cb = ActiveSheet.OLEObjects.Add(classtype:=Forms.Checkbox.1)
With cb
.Top = n
please Ignore previouse Mail
Sub MakeMyIndex()
Dim intICounter As Integer
Dim intTotalSheet As Integer
Dim wksIndexAs Worksheet
Dim shButtonAs Shape
Set wksIndex = Worksheets.Add
wksIndex.Name = Index
intTotalSheet =
I tend to agree with Divakar. But in case you'd still want to go with the
original request, here's the macro
Sub CopyShapesAcross()
Dim shp As Shape
Dim lngLoop As Long
Application.ScreenUpdating = False
Set shp = Sheets(1).Shapes(NameOfShape)
For lngLoop = 2 To Sheets.Count
Hi All,
Can anyone help us.
Regards,
Satvik
Sent from BlackBerry® on Airtel
-Original Message-
From: sunil bn bnsuni...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Wed, 12 Oct 2011 16:38:29
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject:
Hello Anil,
A short version to Ms.Exl.Learner
=TRIM(MID(SUBSTITUTE(A2,/,REPT( ,255)),4*255,255))
HTH
Haseeb
For help tips visit;
http://www.excelfox.com/forum/forum.php
--
--
Some important links for excel
if you want to see the Properties .. you can select Property Option from
Developer Tab in Control Menu
On Wed, Oct 12, 2011 at 8:48 PM, rajan verma rajanverma1...@gmail.comwrote:
Dont Use Shapes , use this Code
ActiveSheet.OLEObjects.Add(classtype:=Forms.Checkbox.1)
On Wed, Oct 12,
Hi Anil,
Designed a formula using Substitute function. See the attachment and
let me know if this helps.
Regards,
DILIPandey
On 10/12/11, Anil Bhange anil.bha...@tatacommunications.com wrote:
Hi Expert,
I needed the formula which can extract the specific content from a Text,
below is some
Hi Suman,
Attached file has the solution.
As the dates provided by you, were in Text format, hence I multiplied
them by 1 and then just changed the format in mm/dd/.
Let me know in case of any queries.
Regards,
DILIPandey
On 10/11/11, Suman ksuman1...@gmail.com wrote:
Hi,
Good evening to
Hi,
Use the formula :-
=OFFSET($A$1,MATCH($B$1,$A$1:$A$6,1)-1,0)
Sample worksheet is also attached for your ready reference. Let me
know if this suits your requirements.
Regards,
DILIPandey
On 10/12/11, B Sharma sharma@gmail.com wrote:
Dear Excel Experts
I want to select a date
Hi,
Hope these help, Drag the file down untill last row of the data sheet.
On Wed, Oct 12, 2011 at 6:40 PM, Ahmed Honest ahmedhon...@gmail.com wrote:
Dear Mr. Shiek,
Tons of thanks for your help. I hope that U achieved it by VBA but is there
any formula of excel to achieve this?
Dear Mr.
Dear Mr. Chethan,
Just a Lovely, Damm and Beyond imagination solution. You Made my Day. I am
speechless for your solution. Billions of Thanks...!
Dear Mr. Don Guillet,
Thanks for your input as well, but would like to request you to go through
the solution how this has been achieved this will
Hi Group,
Need a small help, i have a code which runs on the data and seggregates the
details as per the Country, but additional to that i require the Country
name should come on the top of each rows which are divided by country in the
first column and the heading should be applicable to all the
Hi All,
I want to make chart range dynamic For example, range A1:g1
represents series for the first week and I want to extend the range
for the second week means I want to change the range to A1:N1. Please
help me to make it dynamic
Thanks
Atul
--
You can use Offset Function to Create Dynamic Name Range and can use this
Range as Chart Data Source
=offset($A$2,,,Counta($A:$A),counta(ROw(2))
Create a New Name Range and put this Function there ..
On Thu, Oct 13, 2011 at 5:32 AM, Atul atul_pate...@yahoo.com wrote:
Hi All,
I want to make
Right Click on sheet tab
Select all Sheets
ctrl+f2
type header and footer
It will insert all entire worksheet.
On Wed, Oct 12, 2011 at 3:16 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
After worksheet selection press ctrl+F2 for Page
Setup...
On Wed, Oct 12,
Hi,
I need your help on using conditional formatting for a cell contaning
date.worksheet1 has range A1:b10 which contains name of holiday in col
A and dates in col B. Range b1:b10 is defined name as 'Holidays'.
Worksheet2 contains dates in col A where I want to insert specific
colour using
Hey Ankit,
Please see below image :
For all border press Alt+H+B+A
For outline border Ctrl+Shift+
for all border commands
press Alt+H+B+ then press character which is showing in the image below:
[image: Picture1.jpg]
Kaяan
http://www.facebook.com/singhkarann
Hi
Try this
In a excel file select any area
Then start recording macro ( alt + t + m + r ) save macro in personal file
Insure that you will not change selection before stop the macro recording
Assign border to selection as per your req.
Stop recording macro
Press alt + f8
Select recorded macro
Hi Guys can anyone help me on this please
Thanks
Prasad
Sent from BlackBerry® on Airtel
-Original Message-
From: Mr Excellent suryaprasad...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 13 Oct 2011 04:52:12
To: excel-macros@googlegroups.com
Reply-To:
Hi,
Even to me 1st and 2nd is working rest all other is not applying... Pls
help...
Regards,
Sunil B.N
+91 9035 8585 85
On 13 Oct 2011 10:25, Ankit Agrawal ankit.agrawal...@gmail.com wrote:
Dear All,
I am trying but it is not doing.Plz help me to solve out it.
Regards,
Ankit
On
Hi,
Its excel 2007..Its not working in excel2003...
Regards
Sunil
On 13 Oct 2011 10:38, karan 1237 karan1...@gmail.com wrote:
Hey Ankit,
Please see below image :
For all border press Alt+H+B+A
For outline border Ctrl+Shift+
for all border commands
press Alt+H+B+ then press character
58 matches
Mail list logo