how to paste data from top to bottom to bottom to top
some of the historical data (monthly data, 1980-jan, Feb, march...1981-Jan,
feb.march....) are on this format. But i need them to be pasted as the
otherway around (1981-Dec, Nov.....feb,jan,1980-dec,Nov...feb,jan).
If I had to do this, I'd try to convert each of those non-dates into real dates.
One way is to use a formula:
with 1980-Jan in A1, I could put this in B1
=DATEVALUE(RIGHT(A1,3)&" 1, "&LEFT(A1,4))
Format that cell as a date and see:
Jan 1, 1980
Then you could do pretty much anything you want with that column of real dates.
But the formula you need really...Toolbar at top of IE
I have Windows XP, IE version 8. This question is about the toolbars
showing at the top of IE. The upper one that (normally) shows the words:
File - Edit - View - Favorites - Tools - Help, and the lower one that
(again, normally) shows (among others) the important word: Home.
Recently, periodically, the background for those two toolbars turns totally
black, so the words cannot be read. Fortunately Home has an icon, which
DOES show up. As for the upper one, if I click on where I think the word
is (i.e. Favorites, which I use very frequently) the drop-down menu appears,
s...Highlighting the active row with special colour
Is there a macro that highlights the whole active row (not only the active
cell) that the cursor is in, in an Excel worksheet?
Highlight it in a particular colour, I meant... that would move along when I
would move the cursor onto another row....
"Raj Mazumdar" wrote:
> Hi there
> Is there a macro that highlights the whole active row (not only the active
> cell) that the cursor is in, in an Excel worksheet?
Private Sub Workshe...Removing hyperlinks in Excel by multiplying by 1 is very obtuse
I just followed the Excel help directions for "Remove a hyperlink" ->
"Deactivate several hyperlinks at once". And while the directions work
(multiplying each field by 1), they strike me an obscure work around to a
rather obvious missing feature. It should be easy to remove hyperlinks from
text in Excel, especially because Excel is very agressive about auto-creating
hyperlinks when any text that resembles a web address is entered. Hopefully
this missing feature will be addressed in the next verison of Excel.
post your suggestion to:
Reg...Best book for learning MFC/VC 7.1 for developing rich GUI apps ?
I am a C/C++ developer of quite a few yesrs, although I am relatively
new to Windows (Unix background). I am about to begin work on a project
that would require me to develop several GUI rich frontend applications.
I would like to hear from developers ou there if there is a book they
would recommend, to help me hit the ground running - i.e. a book that is
NOT an introductory text on programming/C++ but rather one that dives
straight in and shows how to create front ends (possibly widgets etc) -
using the VC IDE, one that covers all I need to know about MFC to start
working on a re...Media players opens and keeps trying to refresh about 5 times a mi
I have done numerous spyware chaecks all showing nothing detected
I have eliminated any options in the media player that would have it trying
to check for updates or web items.
Completely at a loss and extremely unhappy the microsoft site does not have
Acer Exyenza Laptop with Win XP , Office 07 and player 11
any help guys?
in the time in took to type this meassage the player popped up three times
Try disabling (unchecking) all active WMP plug-ins in WMP's Options.
If you download and run Process Explorer -
http://technet.microsoft.com/en-us/sysinternals/bb8...Strange Error (CRM 1.2)
I have a Virtual PC configuration set up for CRM demos. I have one image
that has CRM 1.2 under Windows 2003 server. It is all configured and setup
and running fine. I have another image with Windows XP configured. The
two images see each other and communicate.
From my Windows XP image I can access CRM both via browser and Outlook
Client. However, occassionally I can't access the system via Outlook and
when I try it via the browser I get a screen coming up with "Sonic Wall" on
it asking for a login and password. If I enter in "Administrator" for the
I am confused where the reference range SCROLL_DATA and SCROLL_LABELS
slamm's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15018
View this thread: http://www.excelforum.com/showthread.php?threadid=382363
In Insert, Name, Define, (the normal place to find a named-range), an
also read the Offset Worksheet function in Help for furthe
Hope this help
---------------------------------------------...trying to split a stock 1:4
When I were trying to split a stock using Money2000,
Money2000 ended up telling me: "The stock split can not
be completed due to a lack of disk space." But I still
have 18G left on my hard disk.
In microsoft.public.money, Wei wrote:
>When I were trying to split a stock using Money2000,
>Money2000 ended up telling me: "The stock split can not
>be completed due to a lack of disk space." But I still
>have 18G left on my hard disk.
I would try booting into Safe Mode and see if you can do the split.
I don't expect it to solve the problem, but it is ea...more than 65,536 rows
Is it possible to have more than 65,653 rows on a worksheet? The data I have does not fit on a normal sheet
Unfortunately, the maximum number of rows on a worksheet is 65,536 rows and
cannot be increased.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Harald Bock" <email@example.com> wrote in message
> Is it possible to have more than 65,653 rows on a worksheet? The data I
have does not...Rows and Columns Settings Problem
How do you set rows and columns in a way that when you scrol
down/column you can always see a certain row(s)/column(s)
Message posted from http://www.ExcelForum.com
Check out XL Help for "Freeze Panes"
In article <JMorgan.firstname.lastname@example.org>,
JMorgan <<JMorgan.email@example.com>> wrote:
> How do you set rows and columns in a way that when you scroll
> down/column you can always see a certain row(s)/column(s).
Message posted from http://www.ExcelForum.com
...Minimizing Rows of with similar data
I am using Excel 2007.
I have 3 columns A, B, and C such as below:
TU10-10 TU10 Tungsten Satin Wedding Band
TU10-10.5 TU10 Tungsten Satin Wedding Band
TU10-11 TU10 Tungsten Satin Wedding Band
TU10-11.5 TU10 Tungsten Satin Wedding Band
TU10-12 TU10 Tungsten Satin Wedding Band
TU10-12.5 TU10 Tungsten Satin Wedding Band
TU10-13 TU10 Tungsten Satin Wedding Band
TU10-6 TU10 Tungsten Satin Wedding Band
TU10-6.5 TU10 Tungsten Satin Wedding Band
TU10-7 TU10 Tungsten Satin Wedding Band
TU10-7.5 TU10 Tungsten Satin Wedding Band
TU10-8 TU10 Tungsten Satin Wedding Band
TU10-8.5 TU10 Tung...=?iso-8859-1?Q?You_don't_have_appropriate_permission_to_perform_this_oper?= =?iso-8859-1?Q?ation.?=
(Office XP Pro with 3rd Update and WINXP Pro)
After clicking "Send and Receive," I get a red "X" error
message "You don't have appropriate permission to perform
The account tests OK under the Tools-Email Accounts tab
This account used to work perfectly. This error occurred
some time ago now and I have never found a fix. I cannot
associate it with any particular change with my system.
WIN USER 1 - administrator account (Outlook works fine)
WIN USER 2 - limited account (Outlook gives the above
error but the email acct tests O....NET Framework 1.1 compatibility
Does anyone know when the CRM will support .NET Framework 1.1?
I have VS.NET 2003 installed on my development machine. There doesn't seem
to be a straightforward way of building a solution in 1.0 from the IDE. I
guess I can use the command lines...
Microsoft CRM v1.2
http://www.workopia.com/Links.htm >> Other Microsoft CRM
Online Forum Resources
>Does anyone know when the CRM will support .NET Framework
>I have VS.NET 2003 installed on my development machine.
There doesn't seem
>to be a straig...How do I filter rows based upon a column value
I have a spreadsheet that contains multiple agency id's in a column. When
generating reports, I would like to filter per agency and display only the
rows associated with that agency.
Is there a tutorial or sample on how to do this?
It sounds like you are looking for Data / Filter / AutoFilter. Have a look
here for some basics:
"Jack" <firstname.lastname@example.org> wrote in message
> I have a spreadsheet that contains multiple agency id's in a column. When
> generati...Exchange SVC Pack 1
DO NOT INSTALL. It crashed my server and caused the stores to unload and
crash frequently. Now Microsoft want to sell me a hotfix.
It was working b4 the svc pack upgrade so everyone beware!!
Er, no, that's not the case at all.
Exchange 2003 SP1 works perfectly fine for a large number of customers.
If you, as a Microsoft customer have had an issue with the SP that requires
a service pack, identified by Microsoft, then you will not be required to pay
If you have a KB that says you are to call MS for the fix then you may be
required to give details but you won't be char...List all row source for all forms, reports etc.
I'm doing some work cleaning out old unused forms, reports and
queries. I have been going through each report in a database (There
are A LOT), determining its row source query, then marking it for
deletion. I will eventually end up going through and deleting all the
unused queries. As you can imagine this is time consuming, and I was
thinkg 'there must be a FASTER way"
Does anyone have a suggestion, or link to a pre-built function or
model that could assist me?
On Thu, 17 Jan 2008 22:14:18 -0800 (PST), Darragh <email@example.com>
>Hi...Returning Data from a third cell in same row that meets two other
I'm looking for a formula that will return a result from a cell on a same row
as two other cells that meet certain criteria. I'm sure there is a way to do
this but i am a novice at this kind of stuff and can't seem to figure it out.
For example i want a cell to = what is in column E when column A="36751" and
when column B="Total Returns" The spreadsheet has 55000 rows. there will
only be one instance where both these criteria are met. i want to use this
to create a seperate spreadsheet with just info i need and can update on a
thanks in ...how to have my titles move down as i scroll down the page
hi what i want to do is have the top line of the exel sheet move down the
page and stay in veiw so i can easily see which field i am currently woorking
on. can anyone tell me how to do this?
Click on the last row of heading (or row 1 if there is just one row)
Use Windows Freeze
Bernard V Liengme
remove caps from email
"DAVIDPEOVER" <DAVIDPEOVER@discussions.microsoft.com> wrote in message
> hi what i want to do is have the top line of the exel sheet move...MS CRM 1.2 or 3.0 for Help Desk Ticketing solution
Does anyone use this for a Ticketing program? I know we have the customer
service module but have never used it. Is there any documentation on how to
set it up as a help desk solution.
Yes , U can surely do this by making a case and the case number can be
considered a s Ticket number.
You will have to dive deep into the whole process to map it to CRM
> Does anyone use this for a Ticketing program? I know we have the customer
> service module but have never used it. Is there any documentation on how to
> set it up as a help desk ...comparing 2 similar columns on seperate work sheets in 1 workbook
How can I compare a column from worksheet 1 to a column in worksheet 2 of the
same work book?
BTW, the cell my have a number or text in it but not formulas
> How can I compare a column from worksheet 1 to a column in worksheet 2 of the
> same work book?
What are you looking for?
If you want to find out if each cell in Column A of sheet1 appears in column A
of sheet2, you could use a helper column of formulas:
and drag down
And you could use the same kind of formula that will tell you if values in
sheet2 appear in sheet1.
...How to get Row # in formula?
I have several rows with the same formula but they are seperated, in some
cases, by rows with other information to prevent me from just dragging a
formula down to other rows.
Ex. While in row 13: B13*C13+B13*D13+B13*E13
While in row 20: B20*C20+....
how can I write a formula to populate the "13" or "20" automatically for
whatever row I am in?
You may not be able to drag it, but if you copy row13 formula and go to row
20 it updates does it not?
"DaveR" <DaveR@discussions.microsoft.com> wrote ....NET Framework 1.1
I have Vista Home Basic. In the Control Panel\Programs and Features I find:
Microsoft .NET Framework 1.1
Microsoft .NET Framework 3.5 SPI Microsoft Corporation
Under Publisher there is nothing in the fist. Is it OK? Should I
redownload it? Also, do I need both of them?
Also, in Control Panel\Windows Update\View Update History, I see that
Microsoft .NET Framework 1.1 Service Pack 1
has failed, and was not tried again.
Should I download it manually?
It ain't THAT, babe! - A radical reinterpretation
https://files.nyu.edu/emf202/public/bd/itaintm...keep my signature the same
when i originate an email, the signature with the hyperlink
sends and is functional. when i reply or forward, the font
changes, the spacing changes, and the hypertext link
becomes non-functioning. what am in doing wrong? i am using
the same auto-signature for both...
You're probably replying to a message that was sent to you in plain text.
Outlook assumes that worst case scenario - that the sender can't read HTML -
so you reply is in plain text.
If you change it to HTML, it won't help because it'll look to the recipient
just like it looks to you when it's wrong. In fact,...pivot table, How to add 1 column
I just need to add one column only but pivot table create another one?
I thinkc because I have a column with 2 parameters. I can turn on / off with
the field drop down menu
How can I get around with this problem?