Sorry it took so long to respond. I am in Kuwait and my internet sucks!
I think we are talking about the same thing.
I want one main sheet that will be a database for all of my transactions for
every account (Checking, Savings, Credit Card, etc.) I would then like to
have a sheet for each of
Hi Ramesh,
Thanks for the tip but its showing the formule of current cell only not for
entire work sheet.
Is there any another way to use this tip Kindly share the same.
*
BR
MSN*
On Mon, Jun 8, 2009 at 9:50 AM, Ramesh Katta kr.sap...@gmail.com wrote:
Hi all,
Name : Ramesh
Subject :
dear ramesh,this is because u are dragging the cell downward for using same
formula...
if u want to drag the cell downwards without changing the data range pls
make use of $ sign eg- =COUNTIF(B$2:B$11,F)
hope ur doubt is clear..
MANOJ N KARATE.
Sub Engineer (Roads) W.S.
Municipal Corporation of
Hi Manoj,
The tip Ctrl + ` shows the all formulas in the worksheet. For testing
purpose I attached a excel file just open it the press Ctrl + ` you
will seen all formulas.
ThanksRegards
Ramesh
On Mon, Jun 8, 2009 at 3:01 AM, Manoj S
Negimanojsnegi.uttranc...@gmail.com wrote:
Hi Ramesh,
I know it has to be done with a macro. I'm just not sure how (and if
it is possible) to use the find method and search in rows hidden by a
filter.
If you have an idea let me know. Thank you.
On Sat, Jun 6, 2009 at 1:11 AM, Nishant Jainnishantjai...@gmail.com wrote:
this is possible if you
Hi,
here is my problem. I would like to click on a button in my worksheet
and doing so opening a web query window with a given address. The aim
is not to retrieve data but just to open the web querry window
(without going to Data/Import External Data/New web query ...
The button is there. It is
Dear Members,
My deep thanks to the members who have submitted their tips for the
Week # 24 and supported this initiative.
I am looking for tremendous response form each one of you to submit
tips in the group. This will increase the engagement in the group and
will certainly improve the
HI All,
Name : Harmeet
Subject : Enter Date
Tip : Press Ctrl+;
Regards,
Harmeet
On Fri, Jun 5, 2009 at 9:11 PM, Ayush jainayus...@gmail.com wrote:
Hello Everyone,
Please submit your tip in this post for Week # 24. I am looking for
your overwhelming response in this competition.You
HI All,
Name : Harmeet
Subject : Select Active Column
Tip : Press Ctrl+Space bar
Regards,
Harmeet
On Fri, Jun 5, 2009 at 9:11 PM, Ayush jainayus...@gmail.com wrote:
Hello Everyone,
Please submit your tip in this post for Week # 24. I am looking for
your overwhelming response in this
HI All,
Name : Harmeet
Subject : Hidden text in Formula
Tip : *=2018+1056-4*120+N(My Salary + Bonus - 4 weekly loan
repayments)
*
BY using *N() *formula You can enter hidden text in your formula.
Try it.
Regards,
Harmeet
On Fri, Jun 5, 2009 at 9:11 PM, Ayush
HI All,
Name : Harmeet
Subject : Enter Time
Tip :
CTRL SHIFT : Enters the time
CTRL SHIFT Creates an outline box around whatever you select
CTRL SHIFT _ Removes the outline box around whatever has an
outline
CTRL SHIFT * Highlights all
Hi,
If the FIND thingy doesn't work with filter-hidden rows, try just looping
through each cell in the range you want:
Something like:
For each c in Range(A2:A1000)
If c.value = Your criteria here Then Msgbox Bing! It's here!
Next c
Replace the Message Box with whatever code you
Hi Harmeet,
I think this is a very good tip.
Regards - Dave.
Date: Tue, 9 Jun 2009 00:29:31 +0530
Subject: $$Excel-Macros$$ Re: BEST EXCEL TIP WEEK # 24 Submit TIP and Win
PRIZE
From: harmeet.hew...@gmail.com
To: excel-macros@googlegroups.com
HI All,
Name : Harmeet
Subject : Hidden
You can simply use record macro and do all the process through,then you
get it in VBA. You can see the VBA code in VBE editor
On Mon, Jun 8, 2009 at 2:36 PM, Philippe lamy.phili...@gmail.com wrote:
Hi,
here is my problem. I would like to click on a button in my worksheet
and doing so
Hi Ashish
i have alrady mail this query to this group, now can any one help to write
macro for attach excel sheet.
if any one can mail me steps it will be helpful for me.
Thanks in advance
--~--~-~--~~~---~--~~
Name : Abdul Rasheed
Subject : Save As
Tip : Press F12
Regards
Abdul Rasheed
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and
Hi Steef,
I don't know the program/algorithm/software you are using for barcode
scanning. But this could be of some help to you.
Jumping to right of cell - ActiveCell.Offset(0,1)
Selected cell jump 1 row down and 1 column left - Activecell.Offset
(1,-1)
-
Hi Mahesh,
The Group is not for providing start-to-end solutions. Try solving the
problem and we all are here to technically assist you whenever and
wherever you're stuck. I charge for solving such queries, since these
eat time.
-
Regards
Ashish Jain
18 matches
Mail list logo