Where is the data menu for sorting lists?
Am trying to sort an address list into alphabetical order. Help says click on
and select from data menu. When i click no data menu appears.
can anyone help please?
Do you want to tell us what Office program you're referring to, and what
version of that program?
"Shakoh" <Shakoh@discussions.microsoft.com> wrote in message
> Am trying to sort an address list into alphabetical order. Help says click
> list and
> and select from data menu. When i click no...Horizontal Lines/Graphics
Operating System: Mac OS X 10.5 (Leopard)
I'm trying to replicate the lines/dividers used in this sample r�sum�: <a href="http://www.resumesandcoverletters.com/Classic_Functional_Resume.pdf">http://www.resumesandcoverletters.com/Classic_Functional_Resume.pdf</a> <br><br>I can't figure out how to position the horizontal lines just right (i.e., I can move them, but they won't drag into exactly the right position I want) and I can't figure out how to make those sideways, stretched-out bracket-looking things. &...How can stop excel from autochanging my cut and paste data?
Recently I need to copy and paste some data in to my excel for references.
However, whichever part I copied containing text like 1-0, 1-2 the text will
automatically change to 1/1/2000, Jan 2 etc.... Why is it so? How can I stop
that? But when I try to reformat cell to text it becomes code numbers like
Help me please. Thank you.
p/s I paste the text in HMTL form if I paste special as unicode text.
Try pre-formatting the column as Text. Format>Cells>Text
"Excel doubter" <Excel email@example.com> wrote in
messag...CSV formatted text file to Excel
I am writing a small VC++ application of how to import the CSV
..txt file to excel. I am facing problem while parsing the text file.
12534 , 763534 , 23
12345 , 624333, 24
The problem is in MFC there is a SetValue2(CoeVariant:column data)
method in which if i will pass an array(12534) then it will be
imported to excel.For example IfI will search for the "employee
number" field in text file then the values passed to SetValue2()should
be 12543 and 12345.But Using C++ I cannot do so as I...Separate data string into numeric and text
Can anyone help me with a script, to read in a string of mixed
numerical and text data, and separate them to a specific format of
This is the raw data:
11-11-11,44444444,JOE R BLOGGS,2757.42,
I need to convert the data into
11111144444444JOE R BLOGGS 2757.42
Firstly i need to remove the "-" and ",", so that it all joins up.
There needs to be 6 chars at the start for 111111.
At the 7th char i need to leave space for 8 digits (44444444 -
although sometimes the no. being read in will be less than this).
Then 15 chars must be left for name, and the amount will...refer to data on multiple worksheets using hlookup/look up data on many worksheets?
I have data on many worksheets in the same workbook.
Is it possible to look up data on multiple worksheets using Hlookup,
which means can the second argument in the formula refer to multiple
If it is not possible, is there any other way I can do so?
I would like to select and display data according to a fixed order,
whereby the data is located in one of many worksheets in the same
For eg, I have stock returns of many firms in many worksheets. Say I
would like to display in a single worksheet the returns of Firm D, Firm
Z, Firm R; whereby the data of these 3 fir...Making sure data is saved on closing application
I have built myself the following application from 'Teach Yourself
Visual C++ in 21 Days' chapter 'Day 14 - Retrieving Data from an ODBC
The application lets you edit and add records to a database (as well
as just retreive them). The application uses recordset flags in code
to make sure that data is saved if you edit one record and move to
another. However, there is no code to make sure new or edited data is
saved when the application is exited.
After having poked about, I have...Problems XSLT Transformation of XML Data to EXCEL 2000
Does Office Excel 2000 support XSLT transformation of data from XML cause am
having problem when the attachment is opened in the client side if the Excels
version is in Office 2000
and also its works fine if the Office Excel Version 2002 and up
when attachment file is open via browser the data is in a single line of
string in the first row of the excel worksheet
Glenn Gomez wrote:
> Does Office Excel 2000 support XSLT transformation of data from XML cause am
> having problem when the attachment is opened in the client side if the Excels
> version is in Office 2000
>...How to access data buffers in a completion routine for a KMDF driv
I'm porting a WDM upper filter driver to KMDF version. I have two questions
about data accessing in a completion routine.
1. In the completion routine of my WDM upper filter driver, it was able to
retrieve data from Irp->AssociatedIrp.SystemBuffer( The IRP is using Method
Neither I/O, and the data was set by function driver). How to do this for my
2. In the completion routine of my WDM upper filter driver, it was able to
retrieve data by calling MmGetSystemAddressForMdlSafe(Irp->MdlAddress,
NormalPagePriority)( The IRP is using Method Neither I/O, and t...Two Onenote windows on startup (command line switch)
Hi, I have a dual monitor setup, one being a tablet PC, and wanted to get two Onenote windows ready upon startup:
- A normal window, opening my last used file and without full screen - let's consider this one the standard launched window, so it's already there by adding onenote.exe to the startup group, so no issues here.
- The second window I would like to be on the tablet, and I believe I could get that extra screen by adding a second shortcut with the /sidenote switch (or can I not? Haven't tried as it's not my ideal scenario), but I would ideally want it to open a new On...Expense data base
does anyone have a database to track household expenses (utilities,
SQL Server dude
You want fries with that?
I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.
"cg" <firstname.lastname@example.org> wrote in message
> does anyone h...Automatically moving data #4
Thanx for all the help.
I'm going to make the file smaller first. Where do I email it to
multiplan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1591
View this thread: http://www.excelforum.com/showthread.php?threadid=27391
Thought I gave you this reply earlier ??
GMT+8, 1� 22' N 103� 45' E
xdemechanik <at>yahoo<dot>...Automating transfer of data in cells
I have a time management spreadsheet with data stored
against work type and date. I need to transfer this data
into a similar but more comprehensive spreadsheet and
wonder whether it is possible to automate this task by
using the work types and dates in a macro (I have almost
10 months of data to transfer), along the lines of check
date, check worktype, where argument is true enter data
from cell. I think I need to use visual basic, but I
can't find out how in the help screens.
Any advice is much appreciated.
This is not difficult providing you keep your data in simple tables...CRM 4.0
How does one configure a WF Local Service / Data Exchange Service in
CRM 4.0? In a custom WF host I can accomplish this by specifying the
service in the host application's configuration file. Is this
approach possible with CRM 4.0?
I understand that the workflow runtime is hosted by the CRM
Asynchronous Service, and I have been able to register custom WF
Activity as detailed in the CRM SDK documentation. However I can find
no references to registering / configuring a local service.
Any help much appreciated!
On Oct 23, 1:38=A0pm, rgdav...@gmail.com wrote:
> H...Saving data #2
I need to save data (results) from a base spread sheet program that i use on
a weekly basis. i am in the middle of building this program, and have just
discovered macros, but this, along with links is about my current knowledge
how can i automate to accumulate data from the base spread sheet (program)
when i clear all data from the program to produce fresh results the following
week, and to keep past data up to date and available for further use.
Any help would be appreciated.
With a combination of formulas and dynamic named ranges, it is possible to
just add the ...Importing data via macro
I want to create a macro, which let me automate the process of importing the
data from various files (*.xls) from a particular directory to the main table
in MS Access.
My Main table in access is called Wire Transfer Main table. And every
Monday few specialist go in a share drive and post their completed forms in
..xls format. My macro should go into that shared directory every week and
pull out the files from that directory and copy the data from those files to
my Wire Transfer Main Table in access database.
Liz - you're probably better off if you writ...Adding data from another sheet.
I hope I can find some help on this one. I have a spreadsheet that
consists of two sheets. The first is a form. The second is a list of
questions. I have added a checkbox next to each question on sheet 2 to
select the question and add it to the form on sheet 1. The problem:
when you select a question on sheet 2 it will only add it to a specific
cell on sheet 1. So if I select question 15 it will go in a position
like it is the 15th question when actually I would like it to be the
first question. The question: Is there a way to make the questions
start adding to the top cell on sheet 1...Parse multiple text lines into 1 line in excel
help. I am an excel beginner and can't find out how to turn multipl
lines of text into 1 row in excel. It's probably really easy but m
manual is USELESS. Can anyone help
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
You're a little short on details. If nothing below fits the bill post back.
"Multiple lines" is how many and is each line in a separate cell down one
Do you want all lines to go into one cell?
You can use this form...Vertical Page Break
Is it possible to force a vertical page break on a report? For
example, I have a report that is 20 inches across, and I would it to
"break"/start the new page at 10 inches. Now, fiddling with the page
setup and page layout is fine when I am working with only one printer,
but the formatting gets slightly messed up when I am printing across
different printers, to PDF, etc.
Any ideas on how this vertical page break can be done?
that sure would be nice to have
I'd reccomend just putting the page 2 below page 1.. and use more
subreports if you run out of room
On ...Get Access Data into Excel
I am using excel macro to get data from access database.
My sql query gives me 5 records or more than that.
I am able to pull it different cells.
But I want all the 5 results in single cell.
im not exactly sure what your trying to do, but maybe something like this
will do the trick
dim accval as string
accval=accval & " " & rs!:xxx
loop it till rs.eof=true
> Hi All,
> I am using excel macro to get data from access database.
I have a CSV data file wot looks something like this -
This data i...Help Fixing Data on Item Stock Status display
GP 8.0, SQL
Had an employee "sell" 9,000,000,000 units of an item at $0 price. Instead
of deleting the line, he $0 the price. The invoice was posted. I discovered
when our income statement showed a loss of $42b!
My first mistake was to try and reverse by creating a return for the same #
of units at $0 price. But somehow this created problems with the inventory.
Basically, I messed around with it with a number of invoices/inventory
I discovered how to void the RTN and INV using utility > sales > remove
sales history. This had the desired effect with one exc...Drill down pivot table data via VBA macro
I am trying to create a macro that will drill down subtotals from a
pivot table. Since the number of rows, and colums, changes frequently I
need to reference the total for the row or column. Can this be done via
jmon76's Profile: http://www.thecodecage.com/forumz/member.php?u=1909
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=204538
Excel 2007 PivotTable
Show subtotal details via macro.
Define subtotal with PivotField...Data from Form to Subform to Table
I have a main form for material inspection, and another form for the
inpsection results, and tables for each that store the data. For example, you
have to enter the PO# and P/N on the main form, as well as some other info,
then you click to open up the inspection results form in datasheet view. The
inpsection results form shows the PO# and P/N that you entered on the main
form, but it wont store the info in the table for the inspection results. Can
someone please help me figure out how to get the info to store in the
inspection results table as well as the material inspection tab...Fuzzy matching data
I have two spreadsheets of similar property data, and Im trying to create a
formula in spreadsheet A that will look in spreadsheet B, find the matching
property data then return corresponding data to spreadsheet A.
Im using the Index formula for this and name ranges, and everything works
fine if the property data in spreadsheet A exactly matches spreadsheet B. If
there is a slight difference it falls down e.g. spreadsheet A property named
'28 St Marks House', spreadsheet B property named 'Flat 28 St Marks House'.
Does anyone know of a matching/lookup/index method that...