That's something interesting work around. Good one Daniel :)
Thanks & Regards
Ashish Jain
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com
Thanks Ayush for the honour.
It's my pleasure along with other top posters/excel enthusiasts who
loves to share their knowledge by helping other users.
Thanks & Regards
Ashish Jain
(Microsoft Certified Application Specialist)
(Microsoft Certified Professio
Hey Shreedhar,
It seems some program/macro has been assigned to this key combination.
To disable the key combination and return to default key combination,
use:
Application.OnKey "^~"
Run this one line code on your colleague system and let us know, if it
solves your issue or not.
_
Any help on this would really great.
Thank You,
Shreedar
On Thu, Dec 2, 2010 at 7:01 PM, Shreedar Pandurangaiah <
shreedar.panduranga...@gmail.com> wrote:
> Hi Group,
>
> While I am able to use the Ctrl + Tilde, to see the hidden formulas in the
> spreadsheet. My colleague is not able to do that
The parameters of =offset are:
OFFSET(reference,rows,cols,height,width)
the "Reference" is the Base Cell
Rows is the number of rows from the base cell to start the selection.
and Height is the number of rows to select.
So...
YOU have:
OFFSET(
Reference = Sheet1!$B$8,
rows = 0,
cols = 1,
height =
I need this to be automated (i.e., with a formula or macro), and it
needs to handle the fact that the source data is part of a dynamic
range and will often change. But I used your transpose idea and came
up with this macro, which does the job:
Sheets("Sheet1").Range("MyRange").Copy
Sheets("Sheet4"
I'm trying to create a dynamic range to identify the rows in Column C
that have the text "Hello" in the corresponding row in column B.
For example:
B C
8 ABC 3
9 EFG 5
10 XYZ 12
11 Hello 16
12 Hello 17
13 Hello 23
In this example, the dynamic range needs to select C11:C13 (i.e., the
cells co
Dear Group,
I am proud to announce that Ashish Jain who runs OpenExcel.com is the
Top Poster of the Nov'10. I encourage you all to keep helping and
learning others.
Feel free to share the ideas to increase the engagement and learning
in group.
Dear Ashish, Many Many thanks for your contribution.
Hi Ramkesh,
There are some inbuilt functionlality under Pivot table using which we can
achive the desired result.
Please check the attach spreadhseet in which the result is obtained using
"Calculated Field" option of Pivot Table.
Let me know if you have any questions.
Best Regards,
DILIPandey
O
Dear Mahapatra,
It can simply be done by using data validation.
Use following formula under custom option of Data Validation:-
=AND(LEN(A1)<=8,LEFT(A1,3)="SCN")
Sample file is also attached with this email.
Best Regards,
DILIPandey
On Fri, Dec 3, 2010 at 4:57 PM, Raj Mahapatra wrote:
> HI G
Dear All
I am designing a user form but new to this, so i need help on prgramming.
The logic i am mentioning here as under:
Threre are 2 comboBoxes, one calender, and amount file.
What i want
1. Which date i would select that should show in Label4
2. First i would select an Type from ComboBox1("c
HI Group,
I want to restrict some fields in user form as we have data validation in
excel.
can you please suggest me the macros using data validation
following are my requirements
1. I want to restrict to 8 digits in a text box, in which first 3
characters has to be "SCN"
2. I want to use combo
OK... here's what I came up with.
I'm sure there are MANY other ways of doing this, but this uses some
concepts that it would be good for you to know.
You described two problems:
1) Sometimes, there is a single space after the first character of the movement
type: "D 0970"
2) Add a suffix to the
Sorry, got distracted.
I'll take a look and post something soon.
Paul
- Original Message
> From: JsinSk
> To: MS EXCEL AND VBA MACROS
> Sent: Wed, December 1, 2010 12:24:49 PM
> Subject: Re: $$Excel-Macros$$ Sheet rename based on data in sheet & delete row
>
> Paul,
>
> I have a an
I tried to log into the group and see if this question has been addressed,
but the Discussions are temporarily unavailable.
So.. I'm sorry if this has been answered.
If this is as simple as you say..
Simply select the column data, and copy to the Clipboard (ctrl-C)
Go to the destination sheet (She
Harmeet Singh escreveu:
>Hi Dave,
>
>Thanks for the correction and sorry for being so dumb :D.
>
>Warm Regards,
>
>Harmeet Singh
>IT Analyst
>McKinsey & Company
>http://www.facebook.com/Harmeeet
>
>
>On Fri, Dec 3, 2010 at 1:16 PM, Dave Bonallack
>wrote:
>
>> Hi,
>> Harmet, your formula is us
Hello Group,
Any updates regarding my query?
Thanking you in anticipation.
Yours truly,
Yogesh Kudva
On Nov 29, 11:27 am, Yogesh Kudva wrote:
> Hi,
>
> Thanks for your prompt response.
>
> I am using Office 2007.
>
> My requirement is to first create a rule that will sort the mails depending
Hi
I am a management student and have to formulate a macro for tour
travel. I have some basic idea but it would be great if you could help
me out with the technicals.
The tour has to be designed in which sequential drop down boxes will
appear. After selecting the city, the person will choose area
Hey, not dumb. Easy mistake to make. I make it all the time. That's probably
why I spotted it.
Regards - Dave.
From: harmeet.hew...@gmail.com
Date: Fri, 3 Dec 2010 19:10:18 +1100
Subject: Re: $$Excel-Macros$$ Own Formule in Pivot Table
To: excel-macros@googlegroups.com
Hi Dave,
Thanks for
Hi Dave,
Thanks for the correction and sorry for being so dumb :D.
Warm Regards,
Harmeet Singh
IT Analyst
McKinsey & Company
http://www.facebook.com/Harmeeet
On Fri, Dec 3, 2010 at 1:16 PM, Dave Bonallack wrote:
> Hi,
> Harmet, your formula is using relative values for the SUM(B2:B8) section
20 matches
Mail list logo
