Cell linked to a range of cell values in different sheet
I want to setup a workbook that for cell 1 in sheet 1, it would be shown as
an edit combox-like cell, and its value would be associated with an range
values defined (as a defined name) in sheet 2. So when I click on cell 1, a
drop-down list would show all the values in that defined name. I would then
be able to select one of the values. I saw one sample workbook has such an
edit combox-like cell but cannot figure out how it was done. I checked into
Visual Basic Editor and didn't find any macro codes defined anywhere in that
workbook. Any suggestion?
Maybe it was Data|Validation.
D...How to set a icons instead of a menu text?
I'm not quiet sure this can be done , but i would like for some reasons to
set icons to describe my menus.
Can this be done and how?
It is possible to owner-draw menus, youmight want to check here:
Abstrakt Mekanik AB
"Bredal Jensen" <Bredal.Jensen@mimosa.com> a �crit dans le message de
> I'm not quiet sure this can be done , but i would like for so...Full Sheet Viewing to Insert Background Picture: Pub 2003
We have a booklet that is one 8.5X11 sheet composed of 8pages. By default
pages 2 and 3, 4 and 5, 6 and 7 are adjoing, so we can split an image so that
each half shows on a seperate page of the sheet. How do we do this when pages
1 and 8 do not show as adjoining?
I hope the above is not too confusing, but I will clarify if needed.
Thanks in advance for your support.
Are you using Format, Background or are you using an image that is to be spread
over both pages?
If it is the latter, on page two & three insert the image, stretch it or resize
it to fit. When you have it th...copy attachment only into a folder
how do I copy an attachment sent to me thru email, and put the attachment in
a folder to keep under my documents?
clee <email@example.com> typed:
> how do I copy an attachment sent to me thru email, and put the
> attachment in a folder to keep under my documents?
> Thank you
You can manually save an attachment to the location of your choice. If you
want to do this automatically, you might check out
http://www.mapilab.com/outlook/attachments_processor/ or search for
'housekeeping' ...Moving data between Excel sheets
"I have an excel spreadsheet that has 2 sheets, one has a list of open
issues" and one a list of "closed issues". One of the fields on the "open
issues" sheet has a "closed date" field. Whenever a date is typed into this
field, I would like for it to be moved to the "closed issues" sheet, to avoid
duplicate, manual entries being done. Can anyone help me with the best way to
achieve this? Can this be achieved by using Macro's.
Any help with this, would be greatly appreciated.
Suggest you send this to the programming newsgroup...Tree view of wiki pages: is it possible???
I'm building a wiki site and I'd like to have on the left side menu
(the quick launch menu) somehting like a tree view that let me easy
navigate the wiki pages...
maybe a wiki library is not what I need, because none will add or
remove contents... basically I'm using a site as an "instruction
and the tree view should make easy to navigate the differents web
On Mar 19, 5:59=A0pm, Vit <fina...@gmail.com> wrote:
> Hi all,
> I'm building a wiki site and I'd like to have...Same image/every page
I'm wondering if it is possible to have a png image appear
automatically on every page. It needs to sit behind the text, and to
further complicate things, needs to shift with the gutter depending on
whether it is on a left or right page. This is of course a breeze with
a page layout app but the client insists the project be completed in
Alternatively, is there something like a Paste in Place command in
> I'm wondering if it is possible to have a png image appear
> automatically on every page. It needs to sit behind the text, and ...Setting up OWA with Windows Certificate
I need to configure my OWA to make use of a certificate generated by a
Windows 2003 server for an Exchnage 2003 server. I know how to do this using
third party (Verisign) certs but I need to find a free solution.
If you could point me to the correct documentation it would be very much
One of your options would be to use your own Certificate Authority. You can
install this from the Win2k3 Server CD. With that you can generate your own
certificate just like verisign.
This posting is provided "AS IS" with no warranties,
and confers...Page Breaks Problem ( Emergency , Gurus.. PleaseHelp)
Can any body help me immediately.
Please understand the snario.
I am setting the page breaks on my excel sheet. that i had generated b
executing code from Visual Basic. When i first time generate the exce
sheet the code used to set the page breaks executes right. but when
second time execute the code. the code to set the page breaks, Fails.
Below is given the code that i am using to set the page breaks.
Plese help ..
wrkSheet.HPageBreaks.Add Before:=Cells(Row, 1)
wrkSheet.VPageBreaks.Add Before:=Cells(1, CmbMaxColumns+1)
Follwing is the error that s show when i execute the code s...Want to make complex header on 2nd and 3rd page
I need to make a quotation which consists of a first page, thats fully
on its own and then two pages which has a same header.
The header, though, consists of quite a lot of text and also a company
logo and that was byond the header functionality.
How to get the 2nd and 3rd pages with a complex upper part?
...Prinding each row of Excel sheet on a seperate page dispallying one record on each pa
From a spread sheet ,I need to print out a row on each page seperately
that is printout each record on the row on one page seperately.
Can any one please advise how it can be done ?
Row 1 Data 11 Data 12 Data 13
Row 2 Data 21 Data 22 Data 23
Row 3 Data 31 Data 32 Data 33
I would want to print out Data 11 and Data 22 on one page
then Data 21 and Data 22 on the second page and data 31 and Data 33
on the third page
Pleae advise if and hwo this is possible.
Message posted from http://www.ExcelForum.com/
Sorry ...Copying formulas to another worksheet
Can anyone please help me, I am trying to copy a formula =(sump1:p3) from one
worksheet into a new worksheet. When I go to paste the formula the only
thing that comes up is =SUM(#REF!). Can I even copy and paste a formula from
one worksheet into a new worksheet? and if so how? Thanks
When you paste a formula it relatively changes the cell references to suit
where you have pasted it to. EG. If you pasted =sum(P1:P3) from cell P4 to
cell B4 it would change to =sum(B1:B3). However, if you pasted it to cell B2
it could not reasonably change the references. If you are pasting because you...Configuring NDR copies to Public Folder
Using Exchange Server 2003.
I created a 'postmaster' mailbox that receives NDRs and then set it so that
it forwards it to another address which is a mail enabled public folder.
I get this error in the event viewer.
Event Type: Error
Event Source: MSExchangeIS Public Store
Event Category: Transport Delivering
Event ID: 2028
Time: 2:36:56 PM
The delivery of a message sent by public folder NDR
NOTIFICATIONS227406224D7E7D4E26D0C5A3D1DD7EA40A5CCA has failed.
The non-delivery repo...Invalid page fault #4
When I start up Outlook a message displays this program
has performed an Illegal Operation. Further explanation
describes " Outlook caused an invalid page fault in
Just started doing this. When I try to reinstall Outlook,
I get a message Unable to run setup.
Are you sure that the name of the file is correct ? Is it clthood.dll ???
Please verify ..
Hope this helps !!!
"Mark" <firstname.lastname@example.org> wrote in message
> ...Matching and Copying entries
I have two worksheets, on sheet1 there are 4 columns, columnA is the
customers account number. On sheet2 I have 5 columns and again columnA
is the customers account number.
I want to keep all records from sheet1, but I want to add two extra
columns of data that is currently held on sheet2.
So I think I need to compare the customers account numbers between
sheet1 and sheet2 and where they match copy over columns C and E from
sheet2 to two new colmns on sheet1.
What would be the best eay to approach this problem. (I have approx
20,000 rows on sheet1 and nearly 50,000 on sheet2.)
You say tha...keeping footer from resizing when using the fit to page function
How do I keep the footer from shrinking in excel when i
use the "fit to page" option for my worksheets. I'd like
it to stay the same size no matter what the font of the
...Macro to open print window and set to print entire workbook
I need help getitng a macro created to open the print window, then se
it to 'print the entire workbook'. Then the macro would stop. At whic
the user would then specify additional specs for printing. I.E. # o
pages, paper size etc.
I am trying to default the 'print entire work book option' withou
restricting the user from other print specs.
I have a macro that will print once a button is clicked on th
spreadsheet but it goes directly to print and does not let the user se
other specs. I.E. # of pages, etc.
Thanks in advanc
---------------------------------------...print preview does not match page i am working on
In this white space (not the subject line), let us about the problem in more
If print preview is showing only part of the worksheet, then you need to
reset the print area in the File | Print Area dialogs
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
"gillygalloo" <email@example.com> wrote in message
...how can I set a scale drawing in visio?
I need to use visio to set up scaled furniture drawings ...
file => page setup => drawing scale
"Zvensk" <Zvensk@discussions.microsoft.com> wrote in message
>I need to use visio to set up scaled furniture drawings ...
...how can i set the outlook express when receive email, the will be stored as a group (like as the newsgroup)
Try posting this in an Outlook Express news group - this is not one of them.
Outlook is a part of Microsoft Office and is what this group supports.
Outlook Express is a part of Internet Explorer and has its own news groups.
You can also find some good Outlook Express information here:
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, Win asked:
...how to change font on printed copy of outlook calendar week view
When I print out my calendar by the week the font is too small. I can't find
how to increase the size of the font so it PRINTS larger. I could change it
on the view of the calendar but it doesn't change on the print preview.
Randi Steiger;110316 Wrote:
> When I print out my calendar by the week the font is too small. I can't
> how to increase the size of the font so it PRINTS larger. I could
> change it
> on the view of the calendar but it doesn't change on the print preview.
Which version of Outlook? Did you check the page setup options w...System/Organisation Settings and Email tracking Settings
Windows 2003 sp1,SQL 2005 & SQL reporting services,CRM 3.0.
exchange is installed on a seperate domain controller.
two weeks now into deployment and have managed to overcome most of the
installation issues however I have noticed the following BUG:
If i try to disable email tracking,or modify any properties within the email
tracking settings window,the mail router will fail.
3 times now this has happened.
the only way to fix it is to re-install CRM and do not touch the tracking
...how to retrieve data from password protected web pages?
how can I retrieve data from password protected web pages in excel?
...Outlook Web Access
I cannot open e-mails forwarded to me from several AOL
users. OWA shows "The page cannot be displayed" message. I
can open all other e-mails. Looking at the details of the
message I find these content types: multipart/mixed,
text/plain, message/rfc822, multipart/alternative,
text/html, application/msword. text/html is the only one
represented in the registry and is in Level2MIMETypes
registry entry. Any help on what may be blocking these e-
mails is greatly appreciated.
...time sheet template available
I am looking for a bi-weekly time sheet template (or weekly).
Having problems with excel correctly computing total times (works great for
bsydnes, heres one,
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"bsydnes" <firstname.lastname@example.org> wrote in message
> I am looking for a bi-weekly time...