Hi,
Thanks for your prompt response.
I am using Office 2007.
My requirement is to first create a rule that will sort the mails depending
on the deadlines. Secondly create a list of mails received.
Thanks & Regards,
Yogesh Kudva
On Sun, Nov 28, 2010 at 11:59 AM, wrote:
> Dear Yogesh,
>
> Pl
Dear Ashish / Experts
Its wonderfull, its solved what i need.
But i need VBA code for this because i need to send this file to my higher
officials if formulas are there it wont be look good.
and for drop box (Column XFD) u put only those destinations which are in
Master sheet, if i need to add m
Again a recommendation, if it is transfer in to the PDF with password.can it
possible.
Regards,
Ankit
On Mon, Nov 29, 2010 at 11:19 AM, Ankit Agrawal
wrote:
> thank you sir,
>
> Its done dana done.
>
>
> On Sun, Nov 28, 2010 at 11:12 AM, wrote:
>
>> Dear Ankit,
>>
>> Thanks for your appreciatio
thank you sir,
Its done dana done.
On Sun, Nov 28, 2010 at 11:12 AM, wrote:
> Dear Ankit,
>
> Thanks for your appreciation, Is your query solved. If not then what type
> of error is occurring.
>
> You need to create payslips folder in C drive. And all files are stored in
> that folder.
>
> Pl n
Hi ashish, is sumif is ok for you ?? If you still not fond the solution you can
first make pivot and use lookup.
Thanxs & Regards,
Dheeraj S Chauhan
*All things are difficult before they are easy*
Sent from my Nokia phone
-Original Message-
From: ashish koul
Sent: 28/11/2010 17:17:23
S
with UDF you can not:
look here:
http://spreadsheetpage.com/index.php/oddity/a_user_define_function_cant_change_the_worksheet_oh_yeah/
regards
r
2010/11/28 Rahul Kamal Gandhi
> Guys, Can anyone Help me to Bold the text with the help of Formula
>
> Eg.
>
> A1 Cell Contains "ABC"
>
> I Want to
Hi guys i need badly your help,
i want to copy the information of the range of cells from A7:G11 if the
condition is true, in this case i want it to copy the information of the
rows 8 and 10 to sheet number 2, thank you very much in advance, i put in
anex an example of what i need.
Jorge
--
---
Suppose I have a file which contains names of the candidates along with
their date of birth. Now if i want to sort out names which have birthday
falling in the month of november.
How do I do that.
Please note that DOB is mm/dd/ format.
S.No
Beneficiary Name
Ward No
DOB
1
Ambarish G
Hi Rahul,
You can do this with the help of replace option.
Ist open the replace option by pressing ctrl + H.
2nd on "Find What" option write abc or any text you want to bold.
3rd on "Replace With" write abc or any text you want to bold.
4th on the right hand side of the "Replace with" option y
Hi Ashish
what i exactly want is that for attendance record i using an excel
file which 12 pages for entry and 1 page for printing purpose. in the
sheet for printing i create a macro , its working well but every month
i have to change the selected sheet name January, February etc.
instead of this i
I think same post is replicated here. Duplicate posting :)
Thanks,
DILIPandey
On 11/28/10, Rahul Kamal Gandhi wrote:
> Guys, Can anyone Help me to Bold the text with the help of Formula
>
> Eg.
>
> A1 Cell Contains "ABC"
>
> I Want to write the formula in any cell, lets take Cell B1 =AnyFormula(
Hi Rahul,
I dont think there is any existing function using which you can bold
at text. Considering your problem, I have thought of one smart way :-
let say A1 has the text which needs to be bold. Go to B1 and type the
formula =a1. Now apply conditional formatting in B1 that if cell B1 is
not blan
Hi,
Anyone can press Alt+F11 to go to visual basic editor but if the vba
project is password protected then they wld not be able to see the
code.
Your way is also good.
Best Regards,
DILIPandey
On 11/27/10, Rajesh K R wrote:
> Hi Dilip
> i tried your code its working well, but if anybody press
try this see if it helps
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 1 And Target.Column = 1 Then
On Error Resume Next
Sheets(Range("a1").Text).Activate
End If
End Sub
On Sun, Nov 28, 2010 at 5:32 PM, Rajesh K R wrote:
> Hi experts
>
> How can i select a sheet from fil
Guys, Can anyone Help me to Bold the text with the help of Formula
Eg.
A1 Cell Contains "ABC"
I Want to write the formula in any cell, lets take Cell B1 =AnyFormula(A1)
And My output should be *ABC* But in Bold Format
Any Formula or Code. Please Guys I am Struck
Regards,
Rahul Gandhi
+91-
Hi experts
How can i select a sheet from file having many sheets just type the
sheet name in cell A1 in
sheet1.
Thanks in advance
Rajesh Kainikkara
--
--
Some important links for excel users:
1. Follow us on TWITTER
try this macro
Sub delete()
Dim FoundCell As Range
Dim myRng As Range
Dim sh As Worksheet
Set sh = Sheets("Dump")
Set myRng = sh.Range("A:A")
Set FoundCell =
myRng.Find(What:=Sheets("main").Range("b16").Value, After:=Range("a1"), _
L
use sumif check the attachment see if it helps
On Sun, Nov 28, 2010 at 2:06 PM, neil johnson wrote:
> Hi Everyone.
>
> I have large data in excel. for example in sheet 1. and we have name in
> sheet 2 . I use vlookup function and fetch the production using vlookup .
> now when i saw the total th
dear Dilip & ashish koul
Sheets("Dump").Range("a1:D65356").Clear
If i do the above line in attached project then entire data will be deleted.
My doubt is only pink color data display should be deleted from dump sheet. (I
have attached file again to try to understanding you my doubt )
Wi
Hi Everyone.
I have large data in excel. for example in sheet 1. and we have name in
sheet 2 . I use vlookup function and fetch the production using vlookup .
now when i saw the total there is difference between two . When i see in the
sheet 1 . there is duplicate name as well as value is differen
Dear Yogesh,
Pl state your requirement in terms if action to be performed on receipt of
email.
Also mention which version of Excel you are using.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Yogesh Kudva
Sender: excel-macros@googlegroups.com
Date: Sat, 27 Nov 2010 21:
Dear Ankit,
Thanks for your appreciation, Is your query solved. If not then what type of
error is occurring.
You need to create payslips folder in C drive. And all files are stored in that
folder.
Pl note folder name is Payslips and not payslip.
The location and name of folder can be also cha
22 matches
Mail list logo
