Hi Ashutosh,
Absolute refrencing won't help you here.
If you have control of the spread-sheet, and you can easily re-structure it,
change the vertical list to a horizontal one.
If you can't do that, select the refrence list, then copy. find an unused pert
of the sheet. Click in a cell, then r
Hi Ashutosh,
Use the same formula as =$A1 instead of =A1.
U will get the desire results.
Rgds,
Mahender Bisht
On Thu, Jul 2, 2009 at 9:46 AM, ASHUTOSH AGARWAL wrote:
> Hi All,
>
> Genrally in spreadheet, if you copy a formule in other rows, formula is
> changed according to row number. e.g. we
download the addin, copy the same, go to tools>addins>browse for a new file
and paste the copied addin which u downloaded.and confirm it by pressing
ok..
Check in tools, u will have a new option for duplicate master...
cheers..
On Thu, Jul 2, 2009 at 7:08 AM, Mahesh wrote:
> Hi Sai,
>
> Ple
Hi,
You can use =$A1 and drag it across columns
Cheers
Prashanth
On Thu, Jul 2, 2009 at 9:46 AM, ASHUTOSH AGARWAL wrote:
> Hi All,
>
> Genrally in spreadheet, if you copy a formule in other rows, formula is
> changed according to row number. e.g. we have a cell with formula ""=A1" and
> now we
Hey Ashothosh,
Please make use of absolute cell reference.
http://www.techonthenet.com/excel/questions/referencing.php
Regards,
Rajesh Kunder
On Thu, Jul 2, 2009 at 9:46 AM, ASHUTOSH AGARWAL wrote:
> Hi All,
>
> Genrally in spreadheet, if you copy a formule in other row
Hi All,
Genrally in spreadheet, if you copy a formule in other rows, formula is
changed according to row number. e.g. we have a cell with formula ""=A1" and
now we copy this formula across columns to the right. Naturally, this
results in the Formula reference changing to =B1, =C1, =D1 etc.
Howev
Hi Sai,
Please tell how it work?
Rgds,
Mahender Bisht
On Wed, Jul 1, 2009 at 3:03 PM, sai prasath wrote:
> Hi frnds,
>
> here i have attached as "addin" "The Duplicate Master.xl", which is very
> useful to find the duplicates and delete. this is very custom, i guess many
> of you guys know abou
Hi Larry,
Usual cause of that behaviour is other event macros.
Start with: Application.EnableEvents = False
Then your code.
Then at the end: Application.EnableEvents = True
Regards - Dave.
> Date: Wed, 1 Jul 2009 10:22:49 -0700
> Subject: $$Excel-Macros$$ Stop with output subroutine
> From:
Hi,
I am stuck with a problem now which is hunting me since days now.
I had to sort all the document and folder structure that was there in our
repository which was a mesh pending for ages.
Now i am now trying to have all the list in an excel file as a content so as
to find the document easily. It
I am working on a macro where I would like the program to run the main
subroutine and then run the output subroutine once and end the
program. Instead, it appears to be returning to the main program and
doing more calculations and coming back to the output again. Any ideas
on what I am missing? I
Hi Doug,
I think I would keep a sheet in the workbook called 'Template' which contains
all the formatting you want. Then each day, make a copy of that sheet, and
rename the copy as needed. Don't ever put data into your Template sheet. Just
use it to create new sheets.
Regards - Dave.
> Date
I concur
Regards - Dave.
Date: Wed, 1 Jul 2009 19:58:20 +0530
Subject: $$Excel-Macros$$ Re:
From: vishvesh.chau...@gmail.com
To: excel-macros@googlegroups.com
Really good bakul. I'm using excel since started using computers but its new to
me. Thanks.
On Wed, Jul 1, 2009 at 4:57 PM, Bakul
Just a quick question.
I'm writing a workbook in which a new worksheet will be added every
day. Each worksheet contains a number of cells with the same
conditional formatting applied. Is there any advantage to applying the
formatting through VBA code as opposed to applying it through the
Format
Hi All,
To copy paste for all the cells. Lets say you have the data in A3 and you
want to copy to C3:C4 cells.Using mouse to select all the cells is
little bit difficult.
Now you can do the same with below easy steps.
1. Select B3.
2. Then *Ctrl+C* to copy the data
3. Click once in
Dear Amol,
Please find attached the file with the solution.
Regards,
Andy
On Wed, Jul 1, 2009 at 7:15 PM, Amol Shende wrote:
> Dear Friends,
>
> Pl help me to enter in the yellow cell the information from table 2 based
> on the highlighted (red) date
>
>
>
>
> *06/02/2009* ** ** *Date* *0
Really good bakul. I'm using excel since started using computers but its new
to me. Thanks.
On Wed, Jul 1, 2009 at 4:57 PM, Bakul Patel wrote:
> Name: Bakul Patel
> Tip: Dictionary in excel
>
> If you want to use dictionary in excel, just press ALT key & click on cell
> which has the word. you w
Hi Anmol,
Task achieved. Solved sheet is also attached. Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Wed, Jul 1, 2009 at 5:45 PM, Amol Shende wrote:
> Dear Friends,
>
> Pl help me to enter in th
Hi Amol,
Attached is the solution. Hope this is what u want.
Regards,
Saurabh Patel
_
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Amol Shende
Sent: Wednesday, July 01, 2009 5:45 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$
Name: Bakul Patel
Tip: Dictionary in excel
If you want to use dictionary in excel, just press ALT key & click on cell
which has the word. you will get the meaning of the word.
Cheers,
Bakul
--- On Tue, 6/30/09, Ramesh Katta wrote:
From: Ramesh Katta
Subject: $$Excel-Macros$$ Re:
To:
Dear Friends,
Pl help me to enter in the yellow cell the information from table 2 based on
the highlighted (red) date
*06/02/2009* ** ** *Date* *0 - 1 * *DURATION (Hrs.)* *No. of instances*
** *06/01/09* 16 *0 - 1* *06/02/09* 8 *1 - 2* *06/03/09* 10 *2 - 3
* *06/04/09* 11 *3 -
Dear Dilip,
Thanks a lot. Its working.
Thanks
Sachin Shukal
On Wed, Jul 1, 2009 at 3:57 PM, Dilip Pandey wrote:
> Hi Sachin,
>
> Attached sheet has been solved. Thanks,
> --
> DILIP KUMAR PANDEY
> MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.c
Thanks
On 7/1/09, Dilip Pandey wrote:
>
> *Hi Amresh,*
>
> Please find the workbook attached with the example of Advance Filter.
> Thanks.
>
> --
> DILIP KUMAR PANDEY
> MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 110062
>
>
> On W
Hi Thomas,
Your query has been solved and attached herewith. Thanks.
Thanks & Regards
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Mon, Jun 29, 2009 at 6:52 AM, TERTIUS KOSHY THOMAS <
tert...@hees.hitach
Hi,
Check the attached file. Overdue tasks/ projects will be highlighted
automatically.
Thanks,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Mon, Jun 29, 2009 at 7:34 PM, wrote:
>
> Any help?
>
> -O
Hi Sachin,
Attached sheet has been solved. Thanks,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Tue, Jun 30, 2009 at 11:53 AM, Sachin Shukla wrote:
> Dear All,
>
> Please provied me help on attached sheet
Please tell me about advance filter with shortcut
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
Dear Friends,
Name: Narendra Ashara
Tip: Use Units of measure without changing numbers to Text
To display a unit of measure (eg. lb., kg., km., in., etc...) in a cell
without changing the number to text, you can create a custom number format.
1) Select the cells containing the numbers;
2) In the
Hi Dear Members,
Name: Ramesh Katta
Tip: Create chart by pressing F11 function key.
We can create a chart quickly without having to use the chart button
on the toolbar by pressing the function key F11 whilst inside a range
of data.
I have attached a workbook for reference just press F11 on data
28 matches
Mail list logo
