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...data from a modeless dialog box to its parent
I need to post a text data from a modeless dialog box to its parent which is
itself a dialog based application. Since it should be a large text data a
simple Windows message won't be good.
What is the right way to do that?
If you are sure the data will stay current you can post the address of the
data (as a pointer) in a windows message to the parent. If you want to be
really sure use SendMessage() which will wait until the parent gets the
message before returning. You could call a function or copy the data to a
variable in the parent dialog, but that could be dang...Calendar from Excel Data
I currently keep a fairly complex calendar as an Excel spreadsheet. I would
like to find a way to automatically generate a normal-looking month-by-
month calendar from this. I really don't need the month-by-month calendar
to show much of the complexity, just the events and times and possibly
locations in the correct dates on the calendar.
I did a little looking on the web and saw many calendar systems, but it
wasn't clear to me which might be able to import my data from Excel.
...2008 SBS questions... 07-04-10
I am trying to get a 2008 sbs running as efficiently as I can & was
wondering about a couple of things.
1) I know it wants to be the DHCP server on a network, but what about
for wireless clients? I have a wireless sonicwall TZ-170 for wireless
laptops to connect to. They really don't need network access, just
internet, so can I leave this running, as long as the addresses it
hands out aren't in my same network?
2) Although the bought an SBS, the customer is not & probably won't be
running exchange for a while. Can I remove exchange all together? I
really see no rea...Showing Specific Data from Master Sheet to Another Sheet
I am making a bill of materials at work and have a master list I want to
access from other sheets.
The master list has all parts named and categorized, and I want to be able
to access sections (Hydraulics, Chassis, Electrical, etc.) of the master from
I have tried pivottables but I am having issues showing the data in it
Part Name Quantity Material Expense Category etc.
(accross the row)
I wish to be able to make calculations only off the selected data on each
sheet but I am having immense problems getting there.
If you can help.
Parker Jo...Exporting Data
I am looking for a way to export my contacts and the associated notes out of
CRM in a format I can import into Goldmine as I need to archive old contacts.
Any ideas would be appreciated.
Simple way: Create a contacts view that has all the columns that you want to
archive, then do an advanced find on the contacts you want exported, click
the Export to Excel button at the top of the view and save them all into
Excel. Then save your Excel spreadsheet as a CSV in order to import it into
Not so simple way: Use a product like Scribe (www.scribesoft.com).
http://...highlight range, apply calculation to data in cells and paste special to same range
I know how to select a range of cells and copy:
1. applying the calculation, which should be value of cell * 1000
2. special past values only to same selected sells
You enter 1000 in a separate blank cell and copy it then highlight the range
to be multiplied and past special-> multiply. that will multiply all the
cells by 1000 in the pasted range.
"S Himmelrich" wrote:
> I know how to select a range of cells and copy:
&g...pulling data 04-27-10
I'm not sure I am explaining this right
I want the data from C21 on sheet 1 in a cell on sheet 2 if the A & B column
SHEET 1 row 21
A B C D E
4/21/2010 34287 74 3 4
SHEET 2 row 20
A B C D E
4/21/2010 34287 74
Microsoft MVP Excel
"Norm" <Norm@discussions.microsoft.com> wrote in message
news:A40C8E08-721F-47BB-A73C-458AC...Help: message "Requesting data from Exchange Server"
Has anyone figure out why we receive the pop-up
message "Requesting data from Exchange Server" when we
try to open an email in outlook? We are using Exchange
Is there a parameter we can change to fix this issue?
"Kenny" <firstname.lastname@example.org> wrote:
>Has anyone figure out why we receive the pop-up
>message "Requesting data from Exchange Server" when we
>try to open an email in outlook? We are using Exchange
>Is there a parameter we can change to fix this issue?
Depends to a greater or lesser extent ...Data source for PivotTable-Form in ACCESS 2000
Hi, this drives me crazy,
4 years ago I defined in an ACCESS 2000 application a "PivotTable-Form". The
resulting EXCEL table inclusive the "Data refresh" works perfect. I now want
to update/change the query for the "Data Source" but cannot find which query
is behind the "PivotTable-Form" or behind the resulting EXCEL spreadsheet.
When editing the properties for the "PivotTable-Form" or the EXCEL
spreadsheet the "Data Source" is always blank.
Question: Where does Access 2000 or EXCEL 2000 hide the respective data
source (Query)...What is the formula for series: Jan-04, Feb-04, Mar-04, etc.?
Microsoft MVP - Excel
"kitty" <email@example.com> wrote in message
One way of doing it is with the formula below:
If you have a date is cell A1 (01/01/04) and you want cell B1 to sho
you the following month insert in B1 the formula below.
You may have to install the "add in" the ToolPak in order for th
formula to work other wise you will get a #NAME?, error. Hope thi
Fa...80070490 Error: Windows update encountered an unknown error 03-04-10
3 security updates will not complete (now 4). Error Code 80070490
I am unable to do these three security updates: KB970238(release date
6/9/09), KB97451(release date 10/13/09), KB954155(release date 10/13/09), &
KB975517(release date 10/13/09).
The last succesful update was KB9937286 on 2/27/2010
I have a Compaq Presario PC: SR5214X.
OS Name Microsoft® Windows Vista™ Home Basic
Version 6.0.6002 Service Pack 2 Build 6002
OS Manufacturer Microsoft Corporation
System Manufacturer Compaq-Presario
System Model GV441AA-ABA SR5214X
System Type X86-based PC
...publisher 97 #10
I have a file that was oriniated in Publisher 97. I inadevertently opened
and saved it in Publisher 2002 on a different computer(using server). Now I
can't access it through 97. Is there a way to do this? Can't save as, as
the files of type don't say 97.
Maybe they were the same as Publisher 98 files. Worth a try.
"Terry" <Terry@discussions.microsoft.com> wrote in message
> I have a file that was oriniated in Publisher 97. I inadevertently opened
> and saved it in P...Running Office 2001 on Mac OS 10.2, help
This might be a dumb question, but I don't want to screw things up. I
was running Mac OS 9.0.4 and I downloaded OS 9.1, 9.1.2, 9.2.2 and
then the new 10.2. However, all my software is still in the 9.1
classic. I want to use it all in the new OS 10.2. Will Office 2001
Academic Edition work in OS 10.2? Do I need to uninstall it in OS 9.1
first, then install it is OS 10.2? Or, can I just drag and drop it on
the 10.2 desktop or in the applications folder?
I have a lot of other expensive softwares in OS 9.1 that I don't want
to have to upgrade, but need to be able to use in OS 10.2. Wi...fitting a polynomial to data
I have three (equal sized) sets of data, T, x and y, and I am trying find
the f(T)=x and f(T)=y polynomial approximations, but I can't seem to find
the option in Excel that will let me do this. I've been assured by some
people that Excel has this option hidden away in it somewhere, but if it's
somewhere then the help function is not finding it when seaching on
"polynomial fit" or even just "polynomial"...
Does anyone know how to do this?
- Mike Kamermans
I use polynomials to achieve a curve fit on an x,y scatter chart with t...Pull Data From Multiple Tables ????
I will have 4 tables name "TblCostomers","TblVendors","TblAccounts",
Now i have a for name "FrmDrVouchers" that has a table "TblDrVouchers" in
This form has two TxtBox Control name "TxtAccountNo" and "TxtAccountName"
If User enters a Account No., It pulls the Account Name from Any One of these
I can do this if I have only one table.
But tell me how can i do it while I have 4 tables for One Field of a table
Message posted via AccessMonster.com
http://...Quote for Customer can't find data source #3
I need assistance finding the data source for the quote mail merge in
CRM 4.0. I get a error "mail_merge_64494.doc is a mail merge
document. Word cannot open the data source, ."
Here is the process I go through before I get the error:
- I open a quote
- click on menu bar button "Print Quote for Customer"
- select organization mail merge, Quote for customer, and OK
- when asked if I want to open or save, I select open
- I pick yes, when it asks if it can put data on my document
I then get message above. How do I find the datasource?
Also is there a way to configure...MS CRM 4.0 Rollup 2 error Data ProductInfo.ExistingLanguage is not available
Recently upgraded to CRM 4.0. Details are as follows
- CRM is on premise
- 60 Outlook clients
- 32 bit server w/ SRS and Exchange router on CRM server
- 64 bit DB
CRM 4.0 upgrade goes well. Server application of Rollup 2 works fine.
Most of my 60 Outlook clients are getting a popup upon running the
rollup 2 .EXE:
"Data ProductInfo.ExistingLanguage is not available"
These are all US English installs (language id 1033). This is not a
multi-language install. All users were made "local admins" for the
purpose of the client upgrade to 4.0 as well as the rollup install.
About...Excel Look up and Return Data
I have a "data table" in one Excel file (call it DATA, the table is
sorted on a field called 'CODE') and a second Excel file (call it
FORMULA). I need to lookup information from the DATA table and return
it to the FORMULA file, this will be done by matching a Raw Material
Code number from the FORMULA file to the DATA table. When the code is
matched, I would like to return 5 consecutive cells (in 5 consecutive
columns) of data to the FORMULA file. Currently, I am using 5 vLookup
functions to do this in the 5 consecutive cells. I am doing this to try
to ...Dummy series and data table
I have a chart that presents 2005, 2006, 2007 summary data as a column
chart and then 2007 by month as a line. To show the yearly data I have
a yearly category, after which I have individual months where the
yearly data is zero - sort of like a dummy series - because I only
have one value for them. The 2007 detailed data has zero in the yearly
column but all the individual values in the monthly columns. It worked
fine until I was asked to add a data table to the chart. Now, since it
has 2007 twice - once as the summarized for the year and the other as
all these individual months - some us...No Sound 03-26-10
Sorry for not crossposting - I have more problems than I can handle!!!
While trying to uninstall Comodo, I had an error and the computer froze.
I shut it off and it wouldn't boot - not even in Safe Mode. So I used
ERUNT to fix the Registry from a command prompt. Unfortunately, the
latest ERUNT file was corrupted - so I had to go back about a week. The
computer then booted, but I found many changes in some of my data and
settings. Also, I cannot get the sound to work. I again used ERUNT from
Windows with the same backup I used from the command prompt. All
indications on the ...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...Check box question 04-23-07
I have a form with a check box used to indicate if a receipt is voided or
not. What I'm trying to do is go to a new record after the checkbox is
marked. I have the following code in place and it works. Kinda. The
problem is that if I then go back and UNCHECK the check box, it sends me to a
new record again.
Here's the code:
Private Sub Check43_AfterUpdate()
If Ckeck43 = Yes Then DoCmd.GoToRecord , , acNewRec
Thanks for any help!
The following works fine for me.
If Me.Check3 = True Then DoCmd.GoToRecord , , acNewRec
If Ckeck43 = True Then DoCmd.GoToRecor...Data Import/ Data Map Questions
I am developing a solution that will allow various new and updated
entities to be loaded from several source systems into a Microsoft
Dynamics 4.0 installation on an ongoing basis. There are some up-
front components to the solution that detect new/changed source system
data that are custom but I wanted to be able to use the built-in Data
Import facilities within 4.0 to take the data from Excel files and
load it into the CRM. I've looked at the sample code in the SDK and
have been able to write code that will do this, including use of
Picklist and Lookup (ie parent account) type ...Custom Controls 10-16-04
Hi, I would like to create a custom control .ascx and I'd
like to konow how can I put it on a standard CRM form
(for example Accounts)
Thanks in advance
There is not a supported way to do this on the standard forms themselves. The
closest supported method wuld be to add a new Tab on the left of the page via
teh ISV.Confi and have that display your control.
MVP - Microsoft CRM
On Sat, 16 Oct 2004 01:19:06 -0700, Zsolt Z�mbik
Hi, I would ...