Forms & Worksheets
I want to create a form in word that will automatically add entered info into an excel worksheet? Is this possible
Setup you data in ordered columns, with headings in row 1, then menu
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Charlene" <firstname.lastname@example.org> wrote in message
> I want to create a form in word that will automatically add entered info
into an excel worksheet? Is th...The Sum from 1 worksheet cell to another worksheet cell
the sum from one cell on sheet1 from another cell on sheet2,how do you do the formula
To sum the value on Sheet1, cell A10 with the cell
value Sheet2, cell B20, enter =Sheet1!A10 + Sheet2!B20
(or you can enter '=' sign and click on A10, then enter
the plus sign and click on B20)
>the sum from one cell on sheet1 from another cell on
sheet2,how do you do the formula
...first time linking worksheets need some info and help
I'm trying to link 4 cells with dates in them to be inputted into the second
sheet for calculation. BUT the info is in a cycle. So basically I need it to
link and stay. But when I do the next cycle, I need the info to change. I do
have a column that is counting the cycles. So can I make it so it'll link the
info until the cycle number changes? (a Formula???) if so how do i put a link
and formula together.
Also if this is figured out,can you possibly link a cell to two different
worksheets within a workbook?
Can you give an example as to what you are...One Entry to Multiple Rows
I have data that looks like this:
X1 | Y1 Y2 Y3 Y4
X2 | Y4 Y5 Y6 Y7
And I need to get to:
X1 | Y1
X1 | Y2
X1 | Y3
X1 | Y4
X2 | Y4
I can change the 2nd row's entries to more columns, but that doesn't seem to
get me much closer to the needed format (and there are thousands of lines so
I'd rather not do it manually). Any ideas?
should do it. change mc to suit
Dim mc As Long
Dim mr As Long
Dim i As Long
Dim lc As Long
mc = 3 'col c
mr = 1
For i = 1 To Cells(Rows.Count, mc).End(xlUp).Row
lc ...how can i set up my pop and smtp account using proxy server in ou.
"Abhishek" <Abhishek@discussions.microsoft.com> wrote in message
You'll need instructions from your ISP.
Ben M. Schorr, OneNote-MVP
Stockholm Consulting Group/KSG
Microsoft OneNote FAQ:
**I apologize but I am unable to respond to direct requests for assistance.
Please post questions and replies here in the newsgroup. Mahalo!
...Setting Outlook settings to new server
We are in the process of moving mailboxes to a new server. Is there a utility
or ad policy to automatically configure outlook to point to the new exchange
server? Instead of manually configuring the users outlook profile.
On Tue, 21 Nov 2006 11:15:01 -0800, Rich
>We are in the process of moving mailboxes to a new server. Is there a utility
>or ad policy to automatically configure outlook to point to the new exchange
>server? Instead of manually configuring the users outlook profile.
If you are moving the mailboxes in the same org vi...How to write a new entry in a combo box to its underlying table
Dear Access 2007 VBA Gurus,
I have a assets database (rather uncreatively named "Assets"). I use a form
(named "Asset Acquisition Input Form New") to enter new assets. The
"Manufacturer" field (combo box name "Manufacturers_ID) on this form is a
lookup to a Manufacturers table. What I want to happen is when I enter an
item that is not in the lookup list, I want a message box to prompt me to add
the new entry to the underlying table, or to cancel and select an item from
the list. I have no trouble with the MsgBox command itself. What I don&...Somehow I created a Macro in a worksheet.
I created a macro in an Excel worksheet somehow.
I didn't try to, it just happened. Now everytime I open that workbook, it
asks me if I want to run the macro, disable it, etc.
How the hell do I get rid of the macro? It doesn't show up under tools,
macros. And it apparently doesn't do anything either because I can disable
it and nothing different happens.
Who invented this system anyway?
When you record a macro, a module is created to store the macro code.
There are instructions here for removing the module that is causing the
prompt to appear:
http://www.c...email address on Service Call Entry window
Add an email address field to the Service Call Entry window for the customer
contact on the service call. Even if it is not pulled from the email address
of the address id on the service call, at least the dispatcher could enter an
email address on the service call in order to communicate with the customer
regarding the call. It is common to take email address as part of contact
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 m...Excel ask duplicate NAMES when duplicate a worksheets
I have added a NAME called "Above" where point to the cell just above
the current cell. The formula is "=INDIRECT("R[-1]C",)"
In some workbook, when I duplicate a worksheets, this name will remain
silent and work ok. But in some workbooks, when I first duplicate a
worksheets, the same name ABOVE will be duplicate and a new local name
(belongs to that new worksheet) will be created. If I further
duplicate that new worksheets in to a new worksheets, the third
worksheets will be warned that a dupicate NAME is existed and ask
whether refer to another name or use a ne...Paper settings change for specific printer
I just installed access 2007 and my application uses reports to print labels.
Specifically a Dymo turbo 400 and 30252 address labels. when i was using
acess 2003 i specified to use a specific printer and everything was great.
and when i copied updated FrontEnds to my networked computers every thing
transfered and the labels printed fine however with 07 the "Specifc printer"
has a different page size.. i fixed all the reports on my master FE but the
changes didnt stay when i copied FE to other computers and im not sure where
to go. i installed all the printers from the s...outlook in sub-domain to set use root-domain question!!!
Please see below more details,(We are using special railway
line between Head office in Taipei and branch office in Tao-Yuan)
Head office in Taipei:
Dc server * 2(One of it is GC Server),
Front-End Exchange 2003 *1,
Back-End Exchange 2003 * 2(One is named mail1, another is named
Branch office in Tao-Yuan:
Dc Server *1(No GC Server,No Exchange Server)
After using ADMT v3 Tool, when I transfer an account from root named
aaa.com(ou) to bbb.aaa.com.
After I ins...Setting the default font and font size for Excel comments
Do you know how to set the default font and font size in
Excel for the cell 'Comments'?
I have looked in Options as well as in the registry to see
if I can change the default from Tahoma (size 8) to
another (i.e. Arial size 12).
Your help would really be appreciated.
Clint - UK
...How do I import data from lotus123 & maintain formulas/worksheets
I am trying to convert several complex Lotus 123 workbooks with formulas into
Excel 2003. How do I do this and maintain my formulas and the individual
if the lotus file is a wks version or earlier, xl should open it and let you
save it as an xl file.
if the lotus file is a 123 version or higher, you can open the file in lotus
and save it as an xl file.
if you don't have lotus, find someone who does.
> I am trying to convert several complex Lotus 123 workbooks with formulas into
> Excel 2003. How do I do this and maintai...Can I set SQL mirroring across WAN?
We have a 100 Mb dedicated DR link to another data center. Want to set up a
SQL 2008 database to use mirroring from primary to a standby server at the
remote data center. I did a ping test and here is the result.
ping -n 100 -l 5120 <target IP>
Ping statistics for <target IP>
Packets: Sent = 100, Received = 99, Lost = 1 (1% loss),
Approximate round trip times in milli-seconds:
Minimum = 8ms, Maximum = 19ms, Average = 11ms
is the network latency good enough for database mirroring? Does anyone know
the min. requirement? Field experience will be fine too....Code about setting Y Axes scale.
I couldn't understand the lines between 35-42, why he thought the
dbMinScale after the change is the one he want. What the logic of
this code section. Any one who could understand please help me. thanks
Private Sub USP_SetYAxesScal(ByVal i_strWSName As String, ByVal
i_strChartName As String, Optional ByVal i_intDecimal As Integer = 2)
Dim dbMaxScale As Double, dbMinScale As Double, i As Integer, j
Dim xTargetChart As Chart, vTemp() As Variant, blnInit As
Boolean, dbMax As Double, dbMin As Double
1 On Error Resume Next
'get max/m...Can you link 2 worksheets together?
Say i have one worksheet and on my second one I want to reference cells from
the first one? is there a formula for that>?
To create a simple link:
Select a cell in the second worksheet
Type an equal sign
Select the first sheet
Click on the cell that you want to link
Press the Enter key.
> Say i have one worksheet and on my second one I want to reference cells from
> the first one? is there a formula for that>?
Excel FAQ, Tips & Book List
...How do I set up mixed page orientations in Publisher 2003?
I'm trying to create a duplex publication where one side is in portrait and
the reverse is in landscape. I've tried looking in the halp and through all
the menus but it seems that I can only have one or the other. Can anybody
Publisher (any version) does not support this. The workaround most
frequently offered is to design your landscape page, group the all the
objects, then rotate 90 degrees.
Microsoft Publisher MVP
This posting is provided "AS IS" with no warranties, and
confers no rights.
"T. Mitchell"...Setting Text in a ComboBox
Hi, Does anybody know why I cannot set the text in the
edit control of a CBS_DROPDOWN style CombBox control
I was able to change the text in the edit control part of
the ComboBox manually.
I don't know why can't you? Post some code. You should be able to
"Vincent Yu" <email@example.com> wrote in message
> Hi, Does anybody know why I cannot set the text in the
> edit control of a CBS_DROPDOWN style ...set value of a group of activex control points
Have a spreadsheet that has some 20+ activex control points (option buttons).
Is there a way to group all these controls together & set their initial
values the same? Trying to setup a "reset" type of operation that would clear
all control points. I can do them individually via properties, but it's too
...setting up a book cover?
I've been reading about this, the only directions I could find for doing it
is how to set up a book (for pubish on demand, mainly) in WORD. This has a
very brief discription of how to to set up the cover design (if one has no
choice) in Word.
Since I have Publisher (2000) I'm thinking that would be better, of
course. I don't have a specific book and cover in mind, just would like to
learn to do it.
The directions for Word has how to set up the measurments, with extra on
the edges for "bleed" and figuring the space for the spine (going by pages
in the book...pvt table field settings!
i am receiving data every day from 10 different places as under.!
TOTAL NUMBER OF RECEIPTS 10
TOTAL OF RECEIPTS AMOUNT 1000
TOTAL NUMBER OF RECEIPTS 50
TOTAL OF RECEIPTS AMOUNT 1500
TOTAL NUMBER OF RECEIPTS 15
TOTAL OF RECEIPTS AMOUNT 1000
TOTAL NUMBER OF RECEIPTS 10
TOTAL OF RECEIPTS AMOUNT 1000
-likewise i'm receiving daily data from all the 10 places..!
what i want is a pivot table report on a...Posting a Journal Entry directly Into SQL?
Currently, we using Integration Assistant 8.0 for Excel to import about 6
Simple Journal Entries per day. This was fairly easy for the first few
weeks, but now it's just getting boring.
Our process goes something like this: Run a custom SQL Query (that operates
on both Great Plains and other data sources) that produces a result set that
is cut and pasted as a formatted Journal Entry into Excel. Then, from Excel,
we just run our already-built integration package which imports the batch
into Great Plains.
We've already figured out how to get some basic transaction data out of
Gr...PAB DOMAIN CHANGE for hundreds of address entries
Anyone know how to change all email domains in the PAB
file at once? My company name changed with our emil
domain and I have over 1000 entries. I'm looking to make
a universal change, but cannot figure out how to import
changes to PAB file. I can import to CONTACTS but not
PAB, which I keep separate. Thanks.
>Anyone know how to change all email domains in the PAB
>file at once?
Outlook 2000 and up don't use the PAB.
3290 Patterson Ave. SE, MS 1B3
Grand Rapids, MI 49512-1991
Brian.Tillman is the name, smiths-aerospace.com is ...Deletion settings in Mailbox Store Properties
Our company would like to enforce a policy to permanently delete items
30 days or older from each mailboxes Deleted items folder.
The mailboxes all reside on the Exchange 2003 server.
Under Mailbox Store Properties, Deletion settings, the Keep deleted items
for (days) is set to 30, yet the items are not being deleted.
My thoughts are that it is because we do not have the Mailbox Manager
Is that correct?
I am a little hesitant to run it because I am worried about what else it
I only see one recipient policy and that is for email addresses.