Hello Dear,
Try the following link
http://www.cpearson.com/excel/topic.aspx
There is a details of all functions and formulas.
On Mon, May 3, 2010 at 8:47 PM, D Kumar wrote:
> Hi All,
>
> I am not a perfect in excel but i have a little bit knowledge of some
> formulas, is anyone in group
Hi, Try this code:
Sub GetSheetInfo()
A = ActiveSheet.Name
B = 2
For Each s In Sheets
If s.Name <> A Then
Cells(B, 1) = s.Name
Cells(B, 2) = "=" & s.Name & "!A4"
Cells(B, 3) = "=" & s.Name & "!B30"
Cells(B, 4) = "=" & s.Name & "!C30"
Cells(B, 5) = "=" & s.Name & "!D30"
Cells(B, 6) = "=" & s.Na
>
> Hi All
>
> I have data in my excel sheet as follows'
> *Status * *a* *b* *c* *d*
> *e* *g* *h* *i**
>
>
> *Work in
> Progress sfdf
Hi All
I have data in my excel sheet as follows'
*Status * *a* *b* *c* *d*
*e* *g* *h* *i**
*Work in Progress
sfdf shdflsdf lflsdfj
Hi All I have data in my excel sheet as follows' *Status**
**a ** **b ** **c****d **
**e****g ** **h** **i **
**j *
Work in Progresssfdf shdflsdf lflsdfj d
Hi Dave,
Thank you so much - this is great.
Is there any way of having the output on the new page be a cell
reference rather than the value? That way if someone changes the value
on a sheet it will update automatically? The people I am giving this
to will not remember to delete the sheet and run
Hi All
I have data in my excel sheet as follows'
*Status* *a* *b* *c* *d* *e* *g* *h* *i* *j* Work in Progress sfdf shdflsdf
lflsdfj dfhdsfh ljhslhsdfl a a a aa Closed fdfg ksgdfkgf kgafkgsfkd
klghfksdfk kgfkgsfdk kghsfdkgsdf khgdfksdf kjdshfkgf sdfhsdf Assigned
sjfgsdfg ksgfsdg gsdfdgf klgfkgs gf
Hi All,
I am not a perfect in excel but i have a little bit knowledge of some
formulas, is anyone in group can help me to learn more about excel with
ready reference.
Regards
Dheeraj S Chauhan
***All things are difficult before they are esay***
--
---
HI,
u can use folder lock software , it is very gud...
On Mon, May 3, 2010 at 8:49 AM, Harpreet Singh Gujral <
harpreetguj...@gmail.com> wrote:
> Hi Ashish/Jai/Group,
>
> I am also looking for some kind of Folder protection program..
>
> Please advise
>
> Cheers!
>
> Harry
>
> On M
Hi,
Do not select entire column just select the specific range. If you have data
till 1000th row then select the 1000 rows of first three columns.
For ex:
if you have data of 1000 line
then your selection will be from cell A1 to C1000 i.e. your range will be
A1:C1000
So instead of selecting enti
On Apr 27, 2:41 am, Swapnil Palande wrote:
> Hi Rupin,
>
> Please find attached excel for solution. Select the range and press Ctrl and
> Q.
>
> Regards,
>
> Swapnil.
>
> On Mon, Apr 26, 2010 at 2:59 PM, Rupin Goel wrote:
Thank you for your help. It seems someone was asking the same
question
On Apr 27, 2:43 am, Swapnil Palande wrote:
> 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.
Thank you for the help, it works much be
Hey if in case you don't have the excel 2007 and you have to work on
xl 2003 then you may use the concatenate or & function to work on the
above fove formula.
On May 2, 8:17 am, "Asheesh Arora" wrote:
> Dear All,
>
> Please help,
>
> In column A:A dates are there
> In column B:B Condition are th
Can you please give me the example so that we can atleast try to help
you out with query.
On May 2, 6:58 pm, sidhantha suchit wrote:
> hi
>
> sir
>
> I m new to this group right now i m doing a project on stock market and i
> have to do lot of calculation ,I know its my duty but can if any one he
Hi,
Harpreet
*ren aaa.{21EC2020-3AEA-1069-A2DD-08002B30309D} aaa *
*how to use*
open notepad and paste this command *ren
aaa.{21EC2020-3AEA-1069-A2DD-08002B30309D} aaa *and save as key.bat file
name
after make key.bat file
make new folder in desktop and in folder put key.bat file and pro
Can you please give me the example so that we can atleast try to help
you out with query.
On May 2, 6:58 pm, sidhantha suchit wrote:
> hi
>
> sir
>
> I m new to this group right now i m doing a project on stock market and i
> have to do lot of calculation ,I know its my duty but can if any one he
16 matches
Mail list logo
