**
*Suggestion:* Make the sheet's name dynamic in macro.
you can do something like this:
When you are on the sheet from where formula range has to be taken, use this
code, this will give you name of the sheet:
*shtname = Activesheet.Name*
Now when you are on the destination sheet, use this code,
Problem is with the data on the Data tab.
Almost all accounts have more than 1 entry which is causing mismatch in the
results.
On Thu, Nov 18, 2010 at 6:23 PM, Paul Schreiner wrote:
> I placed a "=countif" function in the column adjacent to your "test"
> =IF(H11<>F11,COUNTIF(Data!A:A,
You can take idea from what I have done in the attached file.
On Tue, Nov 16, 2010 at 3:38 PM, Surendra wrote:
> Good After Noon Team,
>
> Still, Waiting for your response.
>
>
> Regards,
> Surnedra
>
>
> On Mon, 15 Nov 2010 15:28:43 +0530 wrote
>
> >Hi Team,
> >
>
> >
> I need your help for c
Sub Protect_the_workbook()
ActiveWorkbook.Password = "password"
ActiveWorkbook.WritePassword = "password"
End Sub
Sub Unprotect_the_workbook()
ActiveWorkbook.Password = ""
ActiveWorkbook.WritePassword = ""
End Sub
On Fri, Nov 12, 2010 at 8:00 PM, Rajesh K R wrote:
> Hi Experts
Solution in the attachment.
Regards,
Ajay Varshney
On Fri, Oct 22, 2010 at 6:04 PM, ayoub Kakande wrote:
>
> Hello,
> Will greatly appreciate any help on this coz for over a week I have failed
> to get over it
> In need a formula to calculate the total best 8
>
> N.b
kill command is used for deleting a particular file from the system.
exp : Kill "location of the file"
location of the file should be in double inverted commas.
Regards,
Ajay Varshney
On Fri, Oct 22, 2010 at 5:39 PM, ghanshyam jaiswal wrote:
> Dear sir
>
> I am ghans
Solution is in the attachment.
I have used Pivot table and used NA for values of blank.
Ajay Varshney
On Wed, Oct 20, 2010 at 12:17 PM, Shrinivas Shevde
wrote:
> Dear All,
> Can Any one help me on graph ?
> Thanks in advance.
>
Follow this link, This can help you.
http://blog.invisibledenizen.org/2008/11/vba-function-to-download-files.html
On Mon, Sep 6, 2010 at 11:57 AM, kush sharma wrote:
>
>
> is there any VBA for downloading a particular file from a website and
> downloading it at a specified location?? if anyon
Try this code:
ActiveSheet.ChartObjects("Chart 1").Activate 'For selecting the
chart
ActiveChart.Legend.Select 'For selecting legend
Selection.Interior.Color = vbRed ' for coloring its interior
Selection.Font.Color = vbBlue 'for coloring its font
ActiveSheet.Cha
reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
> To unsubscribe from this group, send email to exce
roups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes
Hi,
Is there any way of creating pivot table on horizontal data? Means the
headings are in the rows (instead of columns) and data is in horizontal form
instead of vertical.
I can't use copy and transpose option because of macros and functions in the
workbook.
--
Regards,
Ajay Var
will change the format of all phone numbers to the correct phone.
On Thu, Jun 11, 2009 at 1:52 PM, Ajay Varshney
wrote:
> Hi,
>
> Check the attached file. It has the solution.
>
> Macro :
>
> Sub Change_The_Format()
>
> Application.ScreenUpdating = False
>
*Type phone number without any space, bracket, etc. then change the format
of the cells. Rigt Click>Format Cells>Number Tab>Select Special in Cetegory>
Choose English (U.S.) in Language>Choose Phone Number in Type> Click Ok.*
On Tue, Jun 9, 2009 at 5:08 PM, amrahs k wrote:
> Dear Harmeet an
he file in which I copied the code provided by you. Please have a look at
> it and let me know where I went wrong.
>
>
>
> Thanks & Regards..
>
>
>
> CA Vivek Jain
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-mac...@googlegroups.com] *On
**
*Check the attached file*
On Thu, Jun 4, 2009 at 3:32 PM, Sachin Shukla wrote:
> Dear All,
>
> Please help me on attached sheet.
>
> Thanks
>
> Sachin Shukla
>
> >
>
--~--~-~--~~~---~--~~
---
2007.
Regards,
Ajay Varshney
On Thu, May 7, 2009 at 11:37 AM, H Upadhyay wrote:
> Dear Group,
>
> 1 reuested to u pls if u r reverting some one's query then pls save ur
> attachment in XLS not XLSX,
>
> i thing there are some Learner like me who havent excel 2007, if file i
Hi Ashish,
How can we install OpenXL on Vista? Vista does not allow to install dotNet
framework 3.5.
Getting error (Attached) when installing Open XL on Vista.
Regards,
Ajay Varshney
Hi All,
I have written a code in excel vba which opens an existing word document,
copies a range from excel worksheet and then pastes that range on the word
document.
Code is working fine, if I paste the range as *MetafilePicture* but I need
to paste the range as *Bitmap*. When I am pasting it as
>From where can we download VB 33 lesson (39).doc ?
On Mon, Apr 27, 2009 at 2:37 PM, Suyog wrote:
>
>
> Hi All,
>
> Refer uploaded VB 33 lesson (39).doc for new comers. Refer all 33
> lessons & start your VBAmacros.
>
> Thanks
> SK
>
> >
>
--~--~-~--~~~---~--~
HI,
I have copied a pdf picture to an excel file. Now I want that picture to be
copied from excel into the word file by using VBA. Macro could be written in
Excel or Word.
Can somebody help me with the code for this.
I have copied the picture from pdf to excel manually. If somebody has code
fo
different
from each file. I am not using any activex control to view the pdf file.
I am using Adobe reader 8 and excel 2003.
You can help me with any example, then I will edit the code as per my
requirement.
Thanks,
Ajay Varshney
On Fri, Apr 17, 2009 at 7:56 PM, Ajit Navre wrote:
> Ajay,
>
&
Hi,
How can we copy (as image) specific portion from a PDF file and then paste
that copied part in the excel file at a specific location? Before pasting
new image we need to delete the old image. Please suggest.
We need to do it with Macros.
Regards,
Ajay Varshney
Hi,
Can somebody provide me SUB for FUNCTION code for deleting a Module from
Excel
Regards,
Ajay
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tut
Use pivot table, this will give you the required output, infact more than
required.
On Mon, Mar 30, 2009 at 12:43 PM, satish wrote:
>
> Hello group member
>
> I need an help with respect to "Count-if Function". this is what my
> query is
>
> say in "column A" there are many number of A, B, C
Use this code:
Private Sub CommandButton1_Click()
Dim A As Integer
Dim Shts As Worksheet
A = TextBox1.Value
If A = 123 Then
For Each Shts In ThisWorkbook.Worksheets
Shts.Unprotect Password:=123
Next
UserForm1.Hide
Else
For Each Shts In ThisWorkbook.Worksheets
Shts.Protect Password:=123
Next
UserFo
Save this addin anywhere on your hard disk, then open a new excel file or
the file in which you want to use this function.
Then use ctrl+O then locate this addin and click ok.
Then open all functions, then select Num2text fuction. Give the cell
referrence where your actua number is. This will con
HI,
Please find the attached file. Hope, this would solve your problem.
On Fri, Feb 27, 2009 at 9:59 PM, Paul Schreiner wrote:
> That's kind-of difficult.
> first of all.. checkboxes are not usually "tied" to rows.
> They're usually kind-of floating around the spreadsheet,
> but by COINCIDEN
m in sheet 2 and i want the
> reminder in sheet 1 as soon as i open the excel sheet.
>
> Regards
>
> On 3/11/09, Ajay Varshney wrote:
>>
>>
>> This is possible. Send me your original file on which you want to do this.
>> I will send you the solution.
>>
Hi Ashish,
We are waiting for your email on the details of the
prize.
On Tue, Mar 17, 2009 at 2:09 PM, Ajay Varshney
wrote:
> Hi Ashish,
>
> According to your email, we were suppose to get information about our gift.
> But as of now, we have not received any c
Hi Ashish,
According to your email, we were suppose to get information about our gift.
But as of now, we have not received any communication.
Regards,
Ajay Varshney
On Sun, Mar 15, 2009 at 7:42 AM, Aindril De wrote:
> Hey just noticed this mail...
>
> Congra
eir efforts in monetary terms only. So, each and every
>> one of please congratulate to them and give them a tough competition
>> this year.
>>
>> Post Group Name
>> 85 Dave
>> 62 Tom_Jeffries
>> 54 Nihar (Alokeshwar Tiwary)
&
This is not possible in Excel 2003
On Thu, Mar 12, 2009 at 8:05 PM, Harmeet Singh wrote:
> Would be easy if you use conditional formatting. Open excel, Goto format->
> conditional formatting then choose as shown in attachment.
> See solution in attached file.
>
> On Thu, Mar 12, 2009 at 5:21 P
You can use the option : Data > Import External Data > New Web Query
This is for first time.
Every time for refreshing the data : Data > Refresh Data
On Thu, Feb 26, 2009 at 3:37 PM, Anuj Jain wrote:
>
> Hello Freinds!!
>
> I am novice in Excel and want to inquire that can we link Excel to
>
Use these steps
Tools > Options > Under calculation , click on Automatic and click OK
Problem will be resolved.
On Thu, Feb 26, 2009 at 12:00 PM, Rajesh Srinivasaraghavan <
taur...@gmail.com> wrote:
> Hi,
> I have come across instances where the calculation settings have got
> modified from Cal
This is possible. Send me your original file on which you want to do this. I
will send you the solution.
On Sun, Mar 8, 2009 at 6:12 PM, santosh subudhi <
santoshkumar.subu...@gmail.com> wrote:
> Hello All,
>
> Please help me with below mail it is very urgent.
>
> Regards
> Santosh
>
>
> On 3
Attached file has the solution..
On Mon, Mar 9, 2009 at 9:29 PM, aquaflow wrote:
>
> CustNot1 t2 t3 t4 t_date t_time
>
> 35995 0 0 0 300 2008152 4159
> 35995 0 0 0 303 2008152 4159
> 35995 20 0 120 2
Hi Michelle,
You can create one excel file which contains all location names of US with
their time zones and then you can use Vlookup function. This would solve
your problem.
On Wed, Mar 11, 2009 at 3:53 AM, Michelle G wrote:
>
> Hi there,
>
> Does anyone know of a formula or macro to conve
Hi Puneet,
People are there in this group to help each other with their excel knowledge
and not to take challenges. It would be better if you do not use such
language. Hope, you understand what i mean.
I hope, other members of this group would agree with me.
If you have any problem and want tha
Code in the attached file can help you.
On Mon, Feb 2, 2009 at 3:45 PM, Alokeshwar Tiwary <
alokeshwar.tiw...@yahoo.com> wrote:
>
> See attached, this might help you.
>
>
> _
> "There are known know
send us your file, we will unhide the sheet and send back to you.
On Mon, Jan 19, 2009 at 4:23 PM, vinu wrote:
>
> its not working I tried it..
>
> On Jan 17, 2:34 pm, "vijender kumar" wrote:
> > Just go to
> >
> > Fomat > sheet > unhide the sheet.
> >
> > On 1/16/09, vinu wrote:
> >
>
You can use the below mentioned code. Just change the cell reference in the
bracket after range where you see A1.
Sub Speak_the_cell()
Application.Speech.Speak (Range("A1").Value)
End Sub
On Mon, Jan 19, 2009 at 7:02 AM, Bakul Patel wrote:
> G'day guys,
>
> I am trying to get a macro in ex
picture enhanced format or bitmap format.
Which code should i use for the same?
Regards,
Ajay Varshney
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros
*It is very easy, Use Pivot table.*
On Sat, Dec 27, 2008 at 1:30 PM, konark vyas wrote:
>
> Hi,
>>
>> I have a data range in sheet 1 and in sheet 2 i want to view some specific
>> information as attached. Please help me on this.
>>
>> Thanks in advance.
>>
>>
>>
>> Regards,
>>
>> Konark Vy
; Cell A1 = 12/20/2008 5:25:00 AM
> Cell B1 = 12/23/2008 1:00:00 PM
>
>
> calculate the number of hours and minutes between these above two dates.
>
> Answer Formate = __ *:* __ (hh*:*mm)
>
>
> Thanks for your help.
>
> Rgds,
>
> Sunny
> On
Use this formula
=DATEDIF(A1,B1,"D")*24 This if for calculating hours between two
dates.
=DATEDIF(A1,B1,"D")*24*60 This is for calculating minutes between two
dates.
Assumption : Cell "A1" has Start date and Cell "B1" has End date.
On Fri, Dec 19, 2008 at 11:10 AM, Santhosh Ku
Your problem solved in the attachment. This should help you. Let me know if
you still have any query.
On Thu, Dec 18, 2008 at 8:21 PM, xrull wrote:
> On Dec 18, 2:52 am, Ajay wrote:
> > On Dec 18, 11:08 am, xrull wrote:
> >
> >
> >
> > > I need some expert help.
> > > I'm a battering VBA co
Your problem resolved in the attached file.
On Wed, Dec 3, 2008 at 10:21 PM, yasir_shahjee wrote:
> Dear friends
>
> i attached a file kindly check it please.
>
> problem is that i want month wise sum of party so how i do this, when i use
> sumif formula i got total sum of party but i want jus
Why dont you use formula=DAYS360("Start Date","End Date")
You dont need to code anything for this.
On Fri, Dec 5, 2008 at 1:21 AM, larry wrote:
>
> I am trying to creat a code for caculating the number of days between
> two dates. N=A-N causes a type mismacth run time error. Also lookin
Before typing any such number you can use apostrophe ( ' ). This will solve
your problem.
On Mon, Dec 1, 2008 at 7:32 PM, kondaveti wrote:
> Hello all,
> When I am trying to write text "6-5", EXCEL automatically converting it
> into "5-Jun". How can I change this setting globally. As I know, u
Step 1 : Select the entire sheet.
Step 2: Press Ctrl + 1 or Click format on menu bar then click Cells
Step 3: Go to Protection tab and uncheck on "Locked" then click ok
Step 4: Select the cells that you want to be protected
Step 5: Go to Tools > Protection > Protect Sheet
Step 6: Uncheck the "Selec
*Use pivot table. Easiest way.*
On Thu, Dec 4, 2008 at 8:26 PM, rajesh mishra
wrote:
>
> Dear Dev,
>
> In your last mail your sheet is good but if you make a new sheet as per my
> requirement i am very thank full to you
>
> I attach my attedance sheet with the mail
>
> 1st sheet is master sh
**
**
*Use Text to Column, very easy, no macros.*
On Thu, Nov 20, 2008 at 8:44 PM, Tom Jeffries <[EMAIL PROTECTED]> wrote:
> The attached Workbook contains a macro(SplitCol) that does what you
> describe. If you have any questions let me know.
> Tom
>
> On Wed, Nov 19, 2008 at 10:13
Where is the ebook? It has only table of contents, but there is no content.
On Sun, Nov 30, 2008 at 1:29 PM, Sunil Thacker
<[EMAIL PROTECTED]>wrote:
> hi all please find this excel e-boooks..!! Please just say thanks if u
> find it useful..! he he
>
>
> cheer guys and gals...keep exceling :)
Check the named ranges and vlookup formulas,etc. there are many things wrong
in your file.
On Sun, Nov 16, 2008 at 10:17 AM, rajesh mishra <[EMAIL PROTECTED]
> wrote:
> Dear Sir,
>
> I am working with in factory there two shift working.I Attached the sheet
> with mail.Kindly give me prorper solut
Need to seee your code before telling you anything about the mistake
On Tue, Nov 18, 2008 at 1:53 AM, <[EMAIL PROTECTED]> wrote:
>
> I have a macro that is running a stored procedure in the back ground
> and then going on to the next sheet and repeating. The macro works
> fine when step thru it,
Use text to columns:
Steps: Select the data, click on "Data" in menu bar, then click on "Text to
Columns", Choose "Delimited", Click "Next", Check "Comma", click "Next",
Click "Finish"
Done
On Wed, Nov 19, 2008 at 8:43 PM, Mike <[EMAIL PROTECTED]> wrote:
>
> Hi,
> i have a data populated into a
ied number of worksheets ass you describe. If you have any questions
>> let me know.
>> Tom
>>
>> On Tue, Nov 11, 2008 at 7:56 AM, Ajay Varshney <
>> [EMAIL PROTECTED]> wrote:
>>
>>> Hi,
>>>
>>> Is there any macro using which i cou
Hi,
Is there any macro using which i could get number of sheets in a workbook
equal to number of days in a month.
For example : If i am preparing a report for October then I should get 31
sheets in the workbook and if i am preparing report for November then i
should get 30 sheets in the workbook.
=A2&" "&B2&" "&TEXT(C2,"HH:MM AM/PM")
Use the above formula
On Thu, Oct 30, 2008 at 11:15 AM, vinu <[EMAIL PROTECTED]> wrote:
>
> Hi this works well.
> How to concotenat the time formate for eg:
> MS Exce 12:15 AM how to do this..
>
> Regrds,
> vinu.
>
> On Oct 29, 9:18 am, "Bhavish Poddar"
=A1&" "&B1&" "&TEXT(C1,"HH:MM AM/PM")
Use the above forlula
On Thu, Oct 30, 2008 at 11:19 AM, vinu <[EMAIL PROTECTED]> wrote:
>
> How to concatenate the below one.
>
> A1=India
> B1=Bangalore
> C1=12:10Am
>
> Thanks in advance.
> Vinu.
>
> >
>
--~--~-~--~~~---~--~
download the software for cracking password. Install that software and you
can get to know your old password.
search on google for the software
On Thu, Oct 30, 2008 at 4:09 PM, Santhosh Kumar M K <[EMAIL PROTECTED]>wrote:
> Dear friends,
>
> I was Protected one excel workbook.But I forgot a pass
you need to double click on the plus sign which comes below the second
number (2).
On Thu, Oct 30, 2008 at 11:40 AM, vinu <[EMAIL PROTECTED]> wrote:
>
> Hello All,
>
> I have problem with double click activation in excel.
> I have data in A and C column. But if I enter 1 and 2 in B column,
> sel
Solution in the attached file.
On Sun, Oct 19, 2008 at 7:15 PM, Mattathil M. Pradeep
<[EMAIL PROTECTED]>wrote:
> Dears..
>
>
>
> How to copy particular data from one cell ? attached excel sheet for your
> reference.
>
>
>
> Thanks in advance
>
> PRADEEP
>
>
>
> >
>
>
--~--~
you can use the formula which is mentioned in the attached file.
On Tue, Oct 14, 2008 at 10:21 AM, Mayank Patel <[EMAIL PROTECTED]> wrote:
> Hi friends,
> Is there any worksheet function to get the day like Monday, Tuesday
> etc. from any given date in excel.
>
> Regards
>
> Mayank
>
> >
>
--~-
Check the formula from attached file.
You should use Workday formula
Regards,
Ajay Varshney
On Tue, Oct 7, 2008 at 12:45 AM, sanj <[EMAIL PROTECTED]> wrote:
>
> I have a date in a1; in a2 I want to add 2 working days.
> As per example: 3rd Oct, 2008 + 2 working days = 7th Octob
For changing text from small letter to capital letter. Use the formula
=Upper(range)
For changing text from capital letter to small letter. Use the formula
=Lower(range)
For changing text from any (small or capital letter) to proper way. as
first letter capital and rest small. then use formula =Pro
You check the links below and join the group
> >
>
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
What is the problem? What do you actually want to know?
There is a formula in column F : =IF(E17<>"","You Cant Left the Cell
Blank","") this formula means if cell in column E is not blank then
in the cell of column F it should show as "You Cant Left the Cell
Blank" otherwise it should not show a
According to me this is the best formula for Vlookup, Check the
attached file.
Regards,
Ajay
On Thu, Sep 4, 2008 at 10:55 AM, shaily goel <[EMAIL PROTECTED]>wrote:
>
> hi Arjum,
>
> pl find attached file
>
> Regards,
> Shaily
>
> On Thu, 04 Sep 2008 Arjunm1984 wrote :
> >
> >Hi Shaily,
> >
> >If
You can enter date in J5 and then select J5, K5 (Blank) and L5 (Blank) and
then click on the plus sign which you can see on right hand down side of
cell L5 and then strech your selection using mouse (dont leave first button
of your mouse until the selection is complete) till AW5 or till wherever yo
71 matches
Mail list logo
