I want some set of questions on Word-2007 to check competency level of the
user. Please help.
Ananta, please refer to my other 2 postings: just check out the WORD part.
If my comments have helped please hit Yes.
"Ananta Gupta" wrote:
> Hello Everyone,
> I want some set of questions on Word-2007 to check competency level of the
> user. Please help.
> Ananta Gupta
> Ananta, please refer to my other 2 postings: just check out the WOR...I want more!
I need to extend a form that aleady has some 100 lines. For instance, one
column has the date, but only until tomorroq. How do I create more lines
based on the same formula?
I usually select the last row in the range and copy it down a few rows.
If you're using xl2003, you may want to look at Data|List.
And if you're using xl2007, this feature has transformed into Tables.
(Data tab on the ribbon|Data tools Group|What if Analysis|Data table)
> I need to extend a form that aleady has some 100 lines. For instance, one
> column has the da...All new exams added in testking.co.uk now at half prices for limited period only
All new exams added in testking.co.uk now at half prices for limited
...I don't want a page of the same label, I want one of each...
I can't find where to tell Pubisher that I want one of each label and not a
page of each label.
I'm using Publisher 2003 (Office 2003)
I see a post that says to enter "<<Next Record>>" but Publisher doesn't see
this as a field, just as text.
This can't be that hard, but I can't figure it out...
Any help would be appreciated.
I see that it prints correctly, but the print preview displayes it wrong....
I think I have it figured out...
"Kelvin" <email@example.com> wrote in message
news:OSpLwThUIHA.5508@TK2MSFTNGP04.phx....Size of Report Mysteriously Increasing Daily
I have an Excel report that I add to daily. It has 9 tabs with graphs
on 7 of those tabs. I only display 21 days at a time, so each day I
delete the oldest day and add a new day. Therefore, the report should
stay abou the same size. However, it increases by at least 200 bytes a
day. On Jan 4, 2004 it was 2189KB, today it is 5899KB. For two of the
tabs, I copy the entire page from another report and paste it in.
Would this possibly cause it to increase everyday?
Thanks for your help!
Message posted from http://www.ExcelForum.com/
This might help. If you delete entire rows or colu...Text want wrap in text box
I can't get the text to wrap in a text box, word wrap is set to true, I put
some text boxes on a sheet today and the text will not wrap, I did this
yesterday and it worked fine, I can copy the ones from yesterday and paste
them on a new sheet and they work, any ideas? I have rebooted but this did
not help. Using Excel 2000 (9.0.6926 SP3) Thanks Paul B
If you're referring to a Control Toolbat text box make sure that the
MultiLine property is True.
"Paul B" <firstname.lastname@example.org> wrote in message
news:%23ovLUkuLEHA.2456@TK2MSFTNGP12.phx.gbl......Business Portal Order Entry Discount Price Option
This is crucial for Order entry clients that we work with using business portal
Microsoft Dynamics Incident Number: 8638390 Incident Type: Technical Support
Subject: price override
Occurs At: All Workstations
Current Status: Open - Solution Delivered Not Confirmed
Originated: 8/14/2006 4:58:00 PM PDT
Originated by: Rose Business Solutions Inc.
Authorized number: 8587949403
Regarding Customer: Emerald Publications
Team: NA GP Dist_Mfg_Proj
Support Region: North America
Agent: Kelly Dettmann
Current Contact: Jake
Product Line: Microsoft Dynamics GP
Topic: Business Portal Order Management Appl...Look-up Table for "packaged pricing"
1) Have looked in archives - either don't know how to describe this well, or
can't find similiar challenge
2) Have looked in my Excel 2003 Help files - either don't know how to
describe well, or can't find similiar challenge
3) Look forward to hearing how y'all would do this...<grin>
CHALLENGE: Build a "look-up" table to calculate/look-up price based on
position of [0s or 1s] or [Blank] in a particular column/position:
- My client's Web-hosting company sends us orders (in excel...Want to Add more Sub description Field
How I can add more sub description field like 1,2,3,4,5
You have only limit up to 3 fields in RMS 1,2,3 sub-description also you can
use the extended description and there is main description for the item. so
Altogether you have upto 5 description limit and I think that is enough. Let
me know if this won't fulfill your requirements else use the Item Notes for
Rate if like
"Saleem Suri" wrote:
> How I can add more sub description field like 1,2,3,4,5
> Saleem Suri
...I want to add a sound event when the cursor bumps left margin
I want to know (via an event sound) that my cursor movement has bumped the
left edge of the spreadsheet. I am entering thousand of rows of data, and it
would help if there was a event sound when I returned the cursor to the left
edge. I have this feature in 123, and find it helpfull.
Put this in the sheet module:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Static ColOld As Integer
If Target.Column = 1 And ColOld > 1 Then Beep
ColOld = Target.Column
mvpearl omitthisword at verizon period net
"m...Excel wants to create a page break in every cell!
After saving revisions in an Excel worksheet, I get a popup message that
states "Margins do not fit page size". After clicking "ok" (because this is
my only choice) a page break is automatically created in ever cell. At
times(depending on the sizeof the work sheet) it can be over 100 pages with a
page size 14% or smaller.
Why does this happen, and how can I avoid it?
I saw this suggestion in a different forum.
Try closing excel.
Clean up your windows temp folder
Windows start button|Run
and hit enter
Clean all those files that you ca...WANTED
WTB: I BUY SOFTWARE - CHECK AROUND - YOU PROBABLY HAVE SOME OF THE
BELOW TO SELL TO ME.
SEE A LIST OF SOME OF THE SOFTWARE THAT I AM BUYING!
I AM BUYING ALL OF THE BELOW. THE MORE QUANTITY THE BETTER!
I am looking to buy large quantities of Windows 7 Professional Upgrade
Dell DVDs with unactivated COAs included in a SEALED package
I am looking to buy quantities of SYMANTEC NORTON ANTI VIRUS, NORTON
INTERNET SECURITY AND 360 OEM AND RETAIL BOXES
I will buy 2010, 2009, 2008, 2007 and 2006.
If you have good quantities setting around and no longer need send me
detai...Stock Price not updating...
Money 2007 Deluxe, portfolio of 16 stocks. all are updating with the
exception of 1 (MHP) McGraw Hill Companies. I've tried to update prices
several times, no luck. Any thoughts?
On Tue, 10 Jul 2007 16:04:24 -0500, "Shhhh" <email@example.com> wrote:
>Money 2007 Deluxe, portfolio of 16 stocks. all are updating with the
>exception of 1 (MHP) McGraw Hill Companies. I've tried to update prices
>several times, no luck. Any thoughts?
I'll report that MHP is in my portfolio an...Check boxes
Hi---I am setting up a form with various check boxes. I want to set up a
range of check boxes so if any of these boxes are checked, then one
corresponding check box if also checked. On the flip side, if none in the
range of boxes are checked, then the one corresponding box is also not
I hope this can be done with a formula or conditional formatting, instead of
a macro....if it takes a macro, whoever resonds to this question, please
explain in easy terms---I don't have a lot o fmacro experience.
A boolean checkbox reflects the TRUE / FALSE value of the cell it ...I want to know something about Visual Studio 2005
I want to know something about Visual Studio 2005
the size of it , and the System Requirements, who knows , please tell me.
Thanks a lot.
Ajay Kalra [MVP - VC++]
"fcvcnet" <firstname.lastname@example.org> wrote in message
> I want to know something about Visual Studio 2005
> the size of it , and the System Requirements, who knows , please tell me.
> Thanks a lot.
Thank you so much!
But I can not find the Visual Studi...When repeating city want zipcode to populate
Making a data base of mailing addresses. Is there a formula to use to get a
zipcode to populate in a cell when a city and state is entered in two other
See help on VLOOKUP function.
Or go here for excellent help and an example workbook.
Gord Dibben MS Excel MVP
On Wed, 21 Feb 2007 08:05:32 -0800, jrw - esq. <jrw -
>Making a data base of mailing addresses. Is there a formula to use to get a
>zipcode to populate in a cell when a city and state is entered in two other
>...Want Windows Mail to open my live.com mail
What are the server settings to have my live.com mail open in my Windows
To access Hotmail accounts with Windows Mail, you have to use POP3.
Use port 587 for SMTP (outgoing)
With the newer Windows Live Mail, it's much easier.
Windows 7 Ultimate 64
"Sue Ann" wrote in message news:e$a0jezMLHA.1868@TK2MSFTNGP05.phx.gbl...
What are the server settings to have my live.com mail open in my Windows
...Visio Programmers Wanted
I am looking for a programmer with experience programming for Visio to
develop a documentation tool. It can be a remotely developed project
anywhere on the globe.
...My dataset contains units; I want to chart percentages
I am preparing a presentation in Powerpoint. My slides contain line charts.
I want the dataset to be shown and reflect actual units and the graph to
reflect percentages. For example, in period 1, customer purchased 80 units of
Brand A and 20 units of Brand B; therefore, in period 1 Brand A represents
80% of customer's purchases and brand B represents 20%. In period 2,
customer purchased 150 units of Brand A and 50 Units of Brand B. Therefore,
although the number of Brand A units sold increased by 70 units from period 1
to period 2, Brand A's market share declined from 80% to...Want to Flag multiple messages
Is there any way to select several messages and Flag them
all at once in Outlook 2002?
...List Price in IV tables?
Does anyone know where I can find the list price in one of the IV tables?
I've looked around but can't seem to find it.
Any help would be greatly appreciated.
It's in IV00105 (Item Currency Master)
"Benjamin Pierce" <email@example.com> wrote in message
> Does anyone know where I can find the list price in one of the IV tables?
> I've looked around but can't seem to find it.
> Any help would be greatly appreciated.
> Best Regar...Wants to Save As instead of just Save
Thanks for any help you are able to provide. I've been using FrontPage for
years but have a minor issue that is annoying me because I don't why it is
happening or how to fix it.
Long existing pages that I modify in any way at all, will not save in the
conventional manner. The Ctrl/S function, and the tollbar button, do not
just save the page as it should, but takes me to the "Save As" window
instead. I basically have to overwrite the page using the existing file name
and then OK the resaving of all the images on the page. There is no
duplication of pages...Exchange 2003 wants to talk through a 5.5 site connector
I have a problem where an Exchange 2003 server added to a 5.5 site (in
mixed mode, of course) wants to try to talk to a server in another 5.5
site accross a site connector that exists in the 5.5 side.
The 5.5 site connector designates a bridgehead server on both ends, so
it confuses me why the 2003 server thinks it has the right to queue up
mail directly to the target server.
Here is the scenario.
We have a 5.5 site in an NT domain - lets call it Site A, Domain A.
This site has only 5.5 servers and is the connection point for site B.
Site B is in Domain B, so it has a separate service a...Wanting to grab group of files and PkZip them.
I have an excel file that has two columns, Code and Filename.
I would like to be able to select all files with a specific Code and have
them zipped into a file that is named the same as the Code. i.e. Abc.zip
would contain 123456.txt & 123457.txt AND Def.zip would contain 123458.txt &
The file names are actually quite random but they are associated with
specific codes according to this Excel file.
I am creating an Access form that will allow users to browse to the Excel...It is here where you want!!!
Do you intend to be a successful cash entrepreneur?? Have an analysis
for a new day to world economy becoming a millionaire.