Macro help #12
I am working on a macro in Excel 2003 Pro, and everytime I go to sort a
column of data. There are about 10 rows of data in about 200+ columns. I
can only get the macro to sort the column that I edited it with. How can I
create the macro, so each time I click on the first row of each column, click
the macro button I will assign to the toolbar, then that row will be sorted,
and do this for each column?
Any help at all would be greatly appreciated,
Jeff Garrett (firstname.lastname@example.org)
please post your current code and then we can suggest changes to it.
"...How do I prevent "Help" from opening when I open Excel?
Whenever I open Excel 2003 the Help feature opens on the right.
How do I pevent this? I only want Excel to open with a new sheet.
Help or TaskPane.
For Help, you should be able to close it using the "x" and next time open
Excel should not display.
If TaskPane, go to Tools>Options>View and uncheck "Startup Task Pane"
Gord Dibben Excel MVP
On Mon, 12 Dec 2005 13:05:29 -0800, "Lee P" <LeeP@discussions.microsoft.com>
>Whenever I open Excel 2003 the Help feature opens on the right.
>How do I pevent this? I only want Exce...Formulas not updating ?
I have a problem with my spreadsheet under Excel XP. The problem
has to do with cell references not updating when a row is inserted
into the worksheet. The formulas in the cells are relatively simple:
I can copy a row and insert it elsewhere or just insert a blank
row and the cell references in rows below are not updated in all
cases. It seems that rows that are separated from the inserted
rows by a blank row are updated.
Is this a known issue or does anyone have any suggestions on how
to fix this?
The spreadsheet is intended to p...Locking Formulas to Cells
I don't know if I am using the correct terminology but this is what
want to do: I have placed formulas in multiple columns that calculat
my sales numbers for a bid. The problem I am running into is that
change the bids for every person and when I clear a cell is clears th
formula from it as well. Is there a way for me to clear cells withou
deleting the formula I have placed inside it? I know that I can jus
grab the first cell in the column and drag it down to re-load th
formula in that column but I don't want to have to do that. I want th
formulas permenant and the data I enter...how can I drag formulas with other cell references
cell A1 contains formula "=stdev(a2:a7)
cell a2 contains formula "=stdev(a8:a13)
Is it possible to drag the formula down so that cell a3 contains
"=stdev(a14:19) and cell a4 contains "=stdev(a20:a25) and so on for cells a5,
a6, a7 etc. etc.
It was easier to test and verify using SUM instead of stdev, but the formula is same
NOTE the formulas are in a different colu...Changing Titles by a formula
From cell A1:A10 I have standard titles that are linked to
another sheet. I only need to change the office and date
per each title. Is thier a way to do that making the
office and date a formula in another cell?
example of title
ABC Comp, Office 38L Sales as of 6/07/2004
I need to only keep changeing the 38L and date.
Say Office # is in Column 'C'
in cell A1:
="ABC Comp, Office "&C1&" Sales as of "&Today()
----- Heather wrote: -----
From cell A1:A10 I have standard titles that are linked to
...Auto expanding X Axis for Chart
I have a chart setup, currently with reference to 31 cells width.
The chart looks great if the user places a value in each of the 31 cells,
however if there are only say 20 values placed across the cell row, the
chart is displayed over to one side, with nil values displayed where no dat
values were entered.
Is there a way to have the chart automatically vary the width depending on
the amount of values entered across the refernced row of cells?
If there was only 20 values entered, then the chart would show 1-20 charted
and leave out the 21-31.
EXCEL 2007...Date Range Formula Question
Hello, I'm having trouble with a formula and I'm hoping someone can
help. :confused: Sample Data Includes the following:
Pay Period Start Pay Period End Pay Period #
12/16/01 12/29/01 26
12/30/01 01/12/02 25
01/13/01 01/26/02 24
01/27/02 02/09/02 23
02/10/02 02/23/02 22
The pay periods continue until there are 26 pay periods for the entire
year....Formulas don't work in certain cells #2
nope, the cells are formatted as numbers. I simply cannot figure thi
kalik247's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1594
View this thread: http://www.excelforum.com/showthread.php?threadid=27423
Being formatted as numbers doesn't automatically mean they are numbers.
Copy an empty cell formatted to General.
Select your range of numbers and Paste Special>Add>OK>Esc
Gord Dibben Excel MVP
On Mon, 1 Nov 2004 11:59:46 -0600, kalik247
please elp me. my mom is a medical transcriber and she has
a dictionary she uses through windows 98. and her comp has
no memory, so we need to update her operating system
inoder to put more memory on there. she needs her
dictionary and i was wandering how to access it and if
possible how to save it on to a cd. thank you for ur time
Dear jason you have to have a dictornary corect i have one i could email you
if you like just email me back i mean i use this dictornary really well and
it works for 95-Xp so if you want give me a hollar ok
"jason" <jasonr_206@hotm...help with installation isue
Hope this is correct NG
When I try to run `Karens replicator` (for external backup) My PC
automatically runs an installation for publisher 2003 and then gives error
require file SKU019.CAB
then asks for original CD to be inserted.
Publisher still works ok
I can`t see what the relationship between the 2 are, how do I stop this
trying to install?
Rent a villa in Turkey
I would suggest aksing the folks over at karenware.com.
Ive made a spreadsheet which all the cells accept titles contain look
up formula's. I want to be able to do sorts on the columns but it
doesnt seem to work. I think its because excel recognises the content
of the cells as a formula, but i want it just to see the result of the
look up and sort that.
Is there anyway to solve this problem?
Thanks to all who help.
m4tt's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25835
View this thread: http://www.excelforum.com/s...HR Help menu
The Help menu is not available in the Employee file screen. Also there is not
at this time any french version help menu available with HR.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/de...need to make a formula that would add a field value to current dat
I have made a form in which I input different values. On of the values is
(How Many Days). Now I need to a assign a default value, or expression (not
sure which way to go about this) that will take the date value for (Date) and
add the value (How Many Days)
I figured that the formula should read =sum([Date]+[How Many Days])
But that is not giving me any results, thanx for your help in advance
=DateDiff("d", Date(), [How Many Days])
"J Man" wrote:
> I have made a form in which I input different values. On of the values is ...Disabled Auto-numb. Invoice
I will synchronize Order from SAP to import into CRM with
My question is: What will happend if CRM Invoice manage
itself the auto numbering. May I de-activated the auto
I am trying to print a barcode in the 128 code. Though it seems the
public domain/GPL ones of the truetype do not print a scanable barcode.
Is there any suggestions... Or if anyone can point me into the right
direction on how to do this or point me in direction of one that will
work with access or excel 2000 or 2003. Much appreciated.
Or help me figure out WHY it isnt producing a readable one in 128..
Perhaps the problem is with the resolution on your printer.
Try printing the barcode larger. Perhaps even turn off print to fit under
print, page setup.
David McRi...Help please #8
This is a multi-part message in MIME format.
I'm having this error message.
Event Type: Error
Event Source: MSExchangeAL
Event Category: Service Control=20
Event ID: 8231
Time: 4:39:10 PM
Permanent failure reported by policy group provider for 'CN=3DSystem =
,...Re:Help with verifying the signature of enveloped -message using x509 certificates.
Re:Help with verifying the signature of enveloped -message using x509
I have an xml given by our partner trying to integrating with us and i have
their certificate with public key installed in both personal and trusted
when i am using the following code to check the signature of message signed
by my certificate i am able to verify the signature but when i am trying to
check the signature of the message of our partner using the same following
code i am not able to verify the message. the message sent by our partner is
right below the code.I wou...Fill cells with interpolated values
What is the easiest way to fill cells with linear
interpolated values ?
e.g. i have value 5 in cell A1, and value 15 in cell A6.
Cells A2 ... A5 should now be filles with 7, 9, 11, 13.
of course, it's not a big deal to write a formula for
interpolation, but maybe there is more simple way, (just
by some mouse clicks....?)
Select the range A1:A6 with your start and stop value in their respective cells,
and then do Edit / Fill / Series / Trend / Linear
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/...Help needed please
I am running Exchange 2003 with Outlook 2002 as the client
connection. On a couple of machine it has not been
possible to send mails. When mails are sent to this
machine from the Internet, they are received but those
sent from the internal exchange do not get delivered. When
the user connect through Outlook Web Access, the mails are
sitting there. I have tried to reinstall Outlook a number
of times but all I get when I click Send/Receive mail from
the exchange server is this error message:
"The operation failed due to a registry or installation
problem. Restart Outlook and try ag...Services won't stop! HELP!
I do offline backups of all our remote Exchange 2003 servers. A batch file
is run with a series of "net stop" commands the shuts down all the Exchange
services, and then kicks off the backup. I just noticed that the batch file
is no longer able to stop most of the services! When i run it manually, it
just says "The xyz service is stopping........................" The "....."
just keep going and going and the service never stops.
What could cause this??
On Thu, 9 Mar 2006 14:41:29 -0500, "jim" <jim@NOSPAM.com> wrote:
>I do offline ...Advanced Filter help
I'm trying to filter a list using advanced filter. The problem i'm having is
that i'm picking up records i do not want, even if i use the unique record
check box. let me give you an example!
My record i want to pick up is code: 009/04025, however it seems to give me
all codes starting with 009/04025 eg 009/04025C, 009/04025CG, 009/04025SD
etc. The only item i want filtered is 009/04025. Is there maybe a wildcard
or something i should be using??
Set up a criteria range, say X1:X2, where
X1 houses the label heading the codes and
X2 the formula:
="=009/...Show formula result in another sheet
sheet1 A:A contains a formula with some cells returning a value
sheet2 A:A references sheet1 A:A with a simple formula:
above formula filled down in sheet2 A:A
the problem is it is not showing the results from sheet1
anyone know why that should be?
Sorry false alarm, I had calculation set to manual. Results are coming back
as they should. Red faces all round.
> sheet1 A:A contains a formula with some cells returning a value
> sheet2 A:A references sheet1 A:A with a simple formula:
> ...HELP!! Exchange 2003 and rules in outlook
When I define a rule in outlook2003 for a mailbox on a
Exchange 2003 which defines that a mail should be
forwarded to an external email address it doesn't work.
Nothing can be found of it in message tracking. However,
if I define a email address inside the organisation on
that same rule it works without problems and I can see the
full details in message tracking.
I tried creating a contact with the external address (a
hotmail address for example) and defining it in the rule
but that doesn't work either.
Here's an alternate way of achieving t...I need help assigning a value to a character
I need to format a cell so that if I enter an upper case "Y" it display
the "Y" but the cell thinks the value of the "Y" is "1" so that it ca
be added in another function elsewhere. I have tried to use the "IF
functions but have had no success as of yet. HELP
billybob's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2661
View this thread: http://www.excelforum.com/showthread.php?threadid=39881
in cell a11 type in