Dear Friends,
I am having important information in Sheet2 which wa named as "Fuel Item"
along with Sheet1 "Fuel Summary", i would like to hide the sheet2 and
protect it with password so that no one can access it at all,
i need a VBA Code or any suggestion
Thanking You,
With Regards,
P.V. Ra
Hi,
I copied a sheet from one excel file to another (right clicking on
sheet name and ticking "Copy" box). The effect was to change the
colour pallette in the destination sheet to be the same as the colour
pallette in the original sheet. How can I get the old colour pallette
back ?
I tried copyin
Dear Hari Nair,
If the values in quality column are unique then copy and paste the
following formula in column G2
=VLOOKUP(E2,RATE!$C$2:$D$8,2,FALSE)
for best performance sort the Rate sheet on quality column.
Kishan Reddy, K.
On Jul 22, 4:20 pm, HARI NAIR wrote:
> Dear Friends,
>
> I want ra
Hi All,
Can i get some VBA Pivot examples ?
Regartds,
Rajesh. NAir
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Linked
HLC
-- Forwarded message --
From: MNM
Date: Fri, Jul 23, 2010 at 7:12 AM
Subject: $$Excel-Macros$$ Auto Calculate Number to Percent
To: MS EXCEL AND VBA MACROS
Hi,
I am trying to figure out if there is a way to auto calculate number
entered into a column to total percent. Exa
Hi
This can't be done with worksheet functions without the use of another column,
because of circular referencing.
However, it can be done with macros, either automatically, or by button click.
So, which would you prefer: Worksheet functions with extra column, or VBA?
Regards - Dave.
> Date
I Don't think its possible by Self Calculating atleast u have to put
some criteria here
just add another column "D" for %age calculation
--
--
Some important links for excel users:
1. Follow us on TWITTER for ti
Hi Mahesh,
Convertword formula is working in your file only. If I open a new file it
doesn't work.
Please let me know what should I do?
regards,
Vijay Kumar Aggarwal
048542
On Wed, Jul 21, 2010 at 11:57 AM, Mahesh parab wrote:
> Hi
>
> find attach sheet to convert amount into word.
>
> On
Hi,
If I say clearly then this is not possible to change the "Hour Worked"
value in percentage in the same column.
The reason is that when a value is changed to percent what will
converted to a fraction.
Date User Hours Worked Hours Worked %
16-Jul ABC8
Hi,
I am trying to figure out if there is a way to auto calculate number
entered into a column to total percent. Example
Column A contains 'Date'
Column B contains 'User'
Column C contains 'Hours worked'
Based on the value in column B User 'XYZ' I should be able to convert
hours worked into tota
Thanks, everyone. What a JV mistake. :)
On Jul 21, 9:24 pm, "Soni.Rajender" wrote:
> Hi
>
> You can use the formulaes as below:
>
> = FIND(" ",A1,1) or
> =SEARCH(" ",A1,1)
>
> Regards
> Rajender Soni ! 750 322 55 50
>
> On Jul 22, 2:48 am, Edgar wrote:
>
>
>
> > I'm try
Hi,
When I tried it in XL2003, the macro recorder gave:
ActiveSheet.Shapes.AddLine(431.25, 188.25, 678#, 423.75).Select
Try pasting that into xl2007 and see what you get.
Regards - Dave.
> Date: Thu, 22 Jul 2010 09:07:29 -0700
> Subject: $$Excel-Macros$$ Inserting a Vertical
Hello
I have a xlsm (macro-enabled spreadsheet) file with IRM using free
Microsoft's authentication services (windows live based) to protect
the file from being redistributed without my knowledge and consent.
The IRM itself has been working flawlessly so far.
However, I have not managed to successf
Hi HARI,
Please look at that:
http://marchello.ccx-grads.org/files/PR.xls
All you need is key of your fields (dot-separated) and VLOOKUP
standart function.
You can press "F9" if your seetings do not allow automatic
calculation.
Enjoy!
On 22 Лип, 14:20, HARI NAIR wrote:
> Dear Friends,
>
> I wa
I've been trying to use the macro recorder to capture the code on
inserting a vertical line from the Insert-->Shapes part of the menu in
Excel 2007. For some reason it appears that the recorder does not
capture drawing tools.
I want to be able to place a line through VB and control the length,
wid
Thanks Dave. I will try this!
Regards
Rajesh
On Thu, Jul 22, 2010 at 6:37 PM, Dave Bonallack
wrote:
> Hi,
> Create a new sheet. On that, in large font, enter "Macros must be enabled
> to use this workbook."
> Create a workbook close event macro that makes all sheets xlveryhidden
> except the new
in addition of this macro,there is one more thing , if i want to edit one of
my cell, and want to allow multiple secletion, then how it could be done,
plz tell
On Thu, Jul 22, 2010 at 8:00 PM, sudhir kumar wrote:
> Dear Dave Bonallack sir thanks for sharing this important macro
>
>
>
>
>
> On
Dear Dave Bonallack sir thanks for sharing this important macro
On Thu, Jul 22, 2010 at 6:29 PM, Dave Bonallack
wrote:
> You're welcome.
> Dave.
>
> > From: vidyutm...@gmail.com
> > Date: Thu, 22 Jul 2010 17:42:58 +0530
> > Subject: Re: $$Excel-Macros$$ RE: Need macro for attd workbook
>
>
Sir i stuck in your macro. 1 ) filter is not working 2) I have
usecanother macro for that sheet then where should i put ur macro. my
macro as follows
'Private Sub Worksheet_Change(ByVal Target As Range)
Dim Cell As Range
Dim pcNum As Long
Dim party As String
Dim prod As String
Dim ws As Worksheet
thanks for the reply...
its possible to import data from excel to Access.
Debasish
On Jul 20, 7:01 pm, VILAS CHAVAN wrote:
> Hi
> is it posible, to export data excel to access using vba code
>
> vilas chavan
>
> On 7/19/10, Kishan Reddy, K wrote:
>
> > Hello,
>
> > Very simple.
>
> > Select the
I think that explains it. Thanks.
On Jul 21, 11:08 am, Stuart Redmann wrote:
> On 20 Jul., larry wrote:
>
> > > > I have a macro where I copy data into an array from one sheet and then
> > > > post it in another sheet and there is something odd. .8 becomes ,
> > > > 79, .15 becomes .1501.
Hi There,
See attached file.
Warm Regards,
Harmeet Singh
IT Analyst
McKinsey & Company
http://www.facebook.com/Harmeeet
On Thu, Jul 22, 2010 at 11:42 AM, Rave Patwal wrote:
> Please help to add the product of two columns e.g.
>
> Column1Column2
>
> 23 119
> 89
Use =SUMPRODUCT(A1:A3,B1:B3)
Assuming Column 1 is A and Column 2 is B
Cheers
Andy
On Thu, Jul 22, 2010 at 11:42 AM, Rave Patwal wrote:
> Please help to add the product of two columns e.g.
>
> Column1Column2
>
> 23 119
> 8954
> 63 32
>
>
Hi,Create a new sheet. On that, in large font, enter "Macros must be enabled to
use this workbook."Create a workbook close event macro that makes all sheets
xlveryhidden except the new sheet.Create a workbook open event macro that hides
the new sheet and unhides all the others.If the macros are
You're welcome.Dave.
> From: vidyutm...@gmail.com
> Date: Thu, 22 Jul 2010 17:42:58 +0530
> Subject: Re: $$Excel-Macros$$ RE: Need macro for attd workbook
> To: excel-macros@googlegroups.com
>
> Thank you so much sir "Dave Bonallack". Its what i was looking for. Thanks
> again
>
> On Thu, Jul
Dear Kishan Reddy
This is a very good tip and many thanks for sharing the same. I knew about
excel clip board for many years but this idea of using "Paste all" to
combine all sheets is really a magic.
Thanks
Chandru
On Thu, Jul 22, 2010 at 11:36 AM, Kishan Reddy, K <
kishanreddy.kethire...@gmail
Thank you so much sir "Dave Bonallack". Its what i was looking for. Thanks again
On Thu, Jul 22, 2010 at 5:37 PM, Dave Bonallack
wrote:
> Hi,
> Have a look at the attached.
> The macro prevents the selection of multiple cells.
> If the selected cell contains data, it will be locked.
> If the sele
Hi Group,
I need help in preventing unauthorized users from accessing my excel work
book(s). Right now i have written the following vba code to achieve my
objective. However, if some one were to choose to click 'Disable Macros',
they can still access the contents of my file.
Sub auto_open()
UserN
Hello Vidyut,
Please find the attached file for your reference.
Regards,
Beer.
On Thu, Jul 22, 2010 at 12:09 PM, vidyut more wrote:
> Hi respected members.
>
> i want ur help in macro. i v attd sample workbook, in that i want
> macro that can protect rows which is not empty and unprotect empt
Dear Friends,
I want rate automatically comes from rate sheet in Data sheet when I enter
the remaining details in the attached file, please help, Thanks in advance
Regards,
Hari
--
--
Some important links for exce
Hi,
Have a look at the attached.
The macro prevents the selection of multiple cells.
If the selected cell contains data, it will be locked.
If the selected cell is blank, it will be unlocked.
Once a blank cell is edited, it will be locked automatically.
The protection is not password protect
Hi Mr. Patwal,
Try using SumProduct funtion to achieve desired results...!!
SumProduct((First Column Reference),(Second Column Reference))
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
O
Hi Preeti,
Vlookup requires col_index_num and range_lookup to function properly,
If reqd., instead of Vlookup you can use Index, Match, Offset, SumIf,
Sumproduct etc as well. :)
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipa
Hi respected members.
i want ur help in macro. i v attd sample workbook, in that i want
macro that can protect rows which is not empty and unprotect empty
rows
--
--
Some important links for excel users:
1. Follow us
col_index_num is mandatory for vlookup function, range_lookup is
optional.
If range_lookup is not given it will take it as TRUE.
One important point for using Vlookup is that the table array should
be sorted on the first column.
On Jul 21, 8:31 pm, preeti vora wrote:
> Hi team,
>
> when we do v
Please help to add the product of two columns e.g.
Column1Column2
23 119
8954
63 32
Want to add (r1c1*r1c2+r2c1*r2c2+r3c1*r3c2)
Thanks
Ravi
--
--
So
Hello,
Open the Office clipboard: From Menu select Edit -> Office clipboard.
Office clipboard will appear on the right side.
Goto sheet 1 and select Data, and Press Control+C, Data will appear on
Office Clipboard.
Repeat the above step for all sheets.
Then use the Paste All Option on Office cl
Use = Search (" ",cellreference)
Like Search (" ", White Black) result will be 6
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Jo
Hi
You can use the formulaes as below:
= FIND(" ",A1,1) or
=SEARCH(" ",A1,1)
Regards
Rajender Soni ! 750 322 55 50
On Jul 22, 2:48 am, Edgar wrote:
> I'm trying to clean up some data. I've used SEARCH and FIND to try to
> identify the first space within a cell, but th
39 matches
Mail list logo
