Dear Vinod,
Have a look in attached Zipped,It will help you.
Hope it Will Help
On Tue, Apr 27, 2010 at 11:39 PM, vinod rao wrote:
> Hello,
> I want a conditional formating for the string found "to be done" in column F
> and colour the entire row.
>
> Example
> in cell F17 i found t
Hi John,
What is 'StartCellR'?
Also, if you paste this formula {=(Sum(AllBLs*(PF=Range(A6).Value)))} straight
into a cell, you will find that xl won't accept it.
You can't enter VBA notation into a cell.
Try:
"=SUM(AllBLs*(PF=A6))"
Regards - Dave.
> Date: Tue, 27 Apr 2010 13:
Sample workbook please. All formatting as origianl, and data you want compared.
Dave
> Date: Tue, 27 Apr 2010 07:51:10 -0700
> Subject: Re: $$Excel-Macros$$ How to compare two Excel sheets
> From: sudhir.p...@gmail.com
> To: excel-macros@googlegroups.com
>
> Dear friends , i m waiting for repl
HI Sudhir,
You can create a new sheet and compare the two in it starting from the first
cell . Use the formula " = A1 in SHeet1=A1 in sheet2 ".
The similar cells will give TRUE as result and different will display FALSE.
Sincere Regards,
Anurag
-Original Message-
From: excel-macros@
Hi, I have a macro that refuses to run when it reaches the following
command:
StartCellR.Offset(1, 0).FormulaArray =
"=(Sum(AllBLs*(PF=Range(A6).Value)))"
AllBLs is a named range
PF is a named range
I am trying to get excel to sum the values in ALLBLs that correspond
to a certain value
Hello,
I want a conditional formating for the string found "to be done" in column F
and colour the entire row.
Example
in cell F17 i found to be done then the entire row should colour
next if it is in say cell F25 then it should colour entire row of that cell
Regards,
Vinod
--
Hi Sudhir,
Would it be possible for you to attach both the sheets, i will try to work
on it.
If possible, please specify which sheet would serve as the master against
which the other sheet will be compared.
Cheers!
Harry
On Tue, Apr 27, 2010 at 9:25 PM, sudhir kumar wrote:
> Thanks Harpreetj
Thanks Harpreetji, for your valuable solution
I have an another problem,
I have two excel sheets, both are having same format, and
contain huge
amount of data.
now i want to compare them, old one with the new one. and i want to
find out which data is deleted, which one is added, and w
Hi All,
My excel containd the following rows and columns:
I want to convert this data into an xml file based on the path mentioned in the
2nd column
Data
Path
Name
ocim:root/ocim:name[xsi type:"myname"]/ocim:firstname
Name2
ocim:root/ocim:name[xsi type:"myname"]/ocim:Last
Hi,
I created a sheet in Excel 2007 and added a few buttons to it via the
form controls toolbar. When I duplicate the sheet (right click->move
or copy) I get a copy of the sheet but without the form controls.
Any ideas?
Thanks.
--
Dear friends , i m waiting for reply,
thanks
On Apr 26, 8:59 pm, sudhir wrote:
> Dear friends,
> I have two excel sheets, both are having same format, and contain huge
> amount of data.
> now i want to compare them, old one with the new one. and i want to
> find out which data is deleted, which o
Hello All,
How to calculate Median in Pivot.
Regards
Gopi Krishnan
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Linked
Hi Friends,
If you have got any macro or VB module which compiles data from different excel
into single one which are lying in same folder, please provide me.
Thanks,
Hitesh.
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] O
Dear Sir
I have used this code in one of my project viz.
Private Sub Worksheet_Activate()
Sheet2.Protect "1823"
Dim pass As String
pass = InputBox("N Shivkumar has for obvious reasons set a Password, kindly
enter password to unprotect sheet")
If pass = "1823" Then
Sheet2.Unprotect "1823"
El
Thanks a lot for your solution. I got it..
Regards,
Vinu.
On Apr 24, 9:28 pm, Harsh Gharpure wrote:
> For the data range you have specified, following is the solution:
>
> A B C (formula)
>
> 25 0 -100 2 -> = countif(a1:a7,">0") -
Hi OSA,
To prevent the user opening a workbook with macros disabled:
Create a new sheet, and write on it in large text, "You can't use this workbook
with macros disabled."
Use a workbook close macro to make all other sheets xlveryhidden.
Use a workbook open macro to unhide all sheets except t
Huh?
Date: Mon, 26 Apr 2010 21:18:44 -0700
Subject: $$Excel-Macros$$ please help me for Excel Conditional formula with
example
From: vikask...@gmail.com
To: excel-macros@googlegroups.com
Dear All,
Please help me for excel condition formula's, pls send formula with example
...pls it's
Hi,
I saved a excel file on share drive. I want that everybody can access that
file but unable to copy that file or data from that file without my
permission.
Is it possible? If yes, then tell me how?
Regards,
Vijay
--
---
Hi Steve,
Please find attached excel for solution. Select the cells ( from first 3
columns) where you want to fill data and go to "MyTools" in menubar and
press "Fill Data".
Regards,
Swapnil.
On Mon, Apr 26, 2010 at 9:59 AM, Steve wrote:
> I have spreadsheets of imported data from another pro
19 matches
Mail list logo
