show columns on other worksheet without using formulas
I have 1 worksheet containing lot's records.
Just like in access, each line is 1 record, and each column contains data.
name title address city
1 dfjw kjhk kjhkj kjhk
2 lmkj lkjlk lkjkuf guyg
3 drdtg xcx yjutuy hgyy
Now I want to have a selection of columns on worksheet 2:
ex, only name and title:
1 dfjw kjhk
2 lmkj lkjlk
3 drdtg xcx
I will only add/modify rows in worksheet 1.
And I want that this is filled automaticaly in worksheet...No content in message field anymore
For the last two days when I open my email client I see no content in the
message field. Each email is blank with an attachment paperclip in the upper
right hand corner. When I click the paperclip I have the choice of a txt file
(which will not open up) or an htm file which will open. This is driving me
crazy and I don't want to get rid of windows mail...any suggestions on how to
Which antivirus are you running? Some of them cause problems with
Windows Mail over time.
Try running the various repair functions in the WMUtil program:
http://www.oehelp.com/...Powerpoint Viewer Not Playing Portrait Content Properly
When I rotate the video output 90 degrees in Display Properties on my PC and
play a PPT file created in portrait mode (e.g. 8.5" x 11" instead of 11" x
8.5") using the PPT viewer 2007 it plays it back sideways. Anybody know how
to fix this? I would kind of hate having to create the PPT with my head
sideways instead if you know what I mean :)
...One Input, Two Input Data Tables.
Thank you very much for being close to us through this
tool, even thousand of miles are separating us. I have
contacted you before and you were too kind for resolution
Please advise us with visual basic macro in case that the
user would like to use "Data - Table" to include one
equation. The equation contain more than one variable in
the Row Input Cell, and more than one variable in Column
A short response only for the Article Number for easy
reference to find the article will be greatly appreciated.
YOU MAY HAVE ANOTHER TOOL TO...One to One relationship
I have an Events entity that is an offshoot from the Contacts entity.
Basically, it tracks what events each contact has been invited to, and
is used mainly by the Events Coordinator. I've set it up as a One
(Contact) to Many (Events) relationship. However, I really only want
one event form for each contact form. The reason I've set up a
different entity rather than just adding a tab is that access to this
entity needs to be tightly controlled.
Obviously, if many events forms are created for the one contact, it
would be very difficult to tell which one is accurate etc. Is it
When you set reverse categories for the horizontal axis, I noticed that the
legend (which I normally placed at the bottom of the chart), did not
Is this WAD (working as designed) ? If not, how can i overcome this as the
reader would have to mentally "remap" the legend to the bar chart.
Thanks very much.
Reversing the Axis categories will not effect the legend order.
To do that you need to change the Series Order. In 2007 this is none via the
Select Data Source dialog.
Chart Tools > Design > Data > Select Data. Use the Up/Down arrows in the...how do i split a column
i have a worksheet with three columns but want to split column C in to two
from row 37 down while keeping only three columns from rows 1-36. How can i
You can't. You could merge C1 & D1, C2 & d2 etc. but it seems a bit of
What is the reason for this, there may be another solution?
"craig.d" <firstname.lastname@example.org> wrote in message
> i have a worksheet with three columns but want to split column C in to two
> from row 37 down while keeping only three col...Excluding Duplicates in One Field
I'm stuck. I have two fields, fName and fEmail. Many of the fEmail
fields have duplicates because often people in the same house use the
same e-mail address. I need to query the data so the result does not
contain the duplicate e-mail addresses. For some reason, "unique values"
still pulls up the duplicates.
I know if I exclude one of the duplicate e-mail addresses, then I also
end up exluding the name in the same record, but so long as the output
has at least one of the names, along with every record for which there is
a unique e-mail address...Multi-field primary key, no dupes
I can select multiple fields and make a primary key indexed with no
duplicates. But I just realized my criteria for "no dupes" holds only
if another field is empty (no value).
For example, if my primary key is:
then I can't enter another order for the same product on the same
That's good - unless the order's been shipped and another one is
needed. So no duplicates, but only as long as the ShipDate field for
that record is empty.
Can this be done easily? Or should I look into a different way to
...Secure code in Excel & Power Point ADD-INS
Is there any way to secure code in Excel & Power Point ADD-INS, except
the password defined in VBA ?
No. Use VB to create COM addins.
VBA Project Manager
<CLarkou@gmail.com> wrote in message
> Is there any way to secure code in Excel & Power Point ADD-INS, except
> the password defined in VBA ?
Thanks a lot, these add-ins can be called in Access also, isn't?
The COM add-ins can be created by Visual Basic code or it needs C++ ?
You can use VB.
-- ...Do Option Groups Offer an OTHER Option that Users Can Add Themselves?
Hello, I'm using Access 2003 on a novice level.
I have a question about option groups.
I'd like to know if it's possible to create a set of radio buttons,
check boxes, and/or drop-down lists, with an OTHER option that lets
the user enter a new value.
I know that's possible with Filemaker Pro. If you enable the OTHER
option, a popup window appears that lets you add a new item to the
list. I'm not sure if that applies only to drop-down lists, but it
has come in handy at times.
Can it be done with Access?
If so, what are the rudimentary steps to accomplishing this?
Tha...Copying from one workbook to another, without taking the name of the 1st workbook with it.
I am trying to copy from one workbook to another and when I paste the
copied sheet into the new workbook, the cells refer to the name of the
first workbook and I want to take that out before I paste into the new
workbook. Anyone know how to get around this?
If you are copying a whole sheet from one workbook to another, use th
copy sheet dialogue box. (Edit>Move or copy sheet..)
Remember to check Create a copy and select the workbook to copy to fro
the upper dropdown box.
Message posted from http://www.ExcelForum.com
You can do this
Select all cells
Use replace ...Recent update 6/8
I recently updated Windows (6/8) and now one of my user accounts is locked.
I had to use restore after today's updates
> I recently updated Windows (6/8) and now one of my user accounts is locked.
> Running XP.
...How to add multiple message senders to the blocked list automatica
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 message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
I created a line column chart on 2 axis. I have four data
sets. The first 3 should go on the primary Y axis as
columns and the 4th should go on the secondary Y axis as a
line. However, Excel wants to automatically put both the
3rd and 4th data sets on the secondary axis as lines. I
cannot find any command to change the 3rd data set to go
onto the primary axis as a column.
Any suggestions would be most appreciated!
On Tue, 11 Nov 2003 13:27:33 -0800, Patty =
> I created a line column chart on 2 ...Two Outlook 2000 boxes merge to one
User A: Left the Company Several weeks Ago.
User B: Used User "A" email box until she got hired on a
Issue: User B now has her own inbox but would like to
have all of the 1500 hundred emails and folders in
USER "A" in box transferred to her new in box. OBvioulsy
she could simply forward these emails to her own box BUT I
wanna know if there is another way to get the present info
from USEr "A" inbox to transferred USer "B" in box? Can
the two in boxes some how merge? Once this "merge" has
taken place USER A in box ...Gantt Chart Missing One Task Line When Printed
I am completely stumped here with Project 2007. When printing the gantt
chart line 30 of my plan is blank. The line number is there, but the task
info and bar is blank. It shows up in print preview. All other lines show up
fine and the rest of the project prints fine as per my print settings - just
missing one line!
Printer drivers are updated, software has current update - anyone ever heard
of this? I really appreciate your help!
Do you see a different answer if you turn off 3D bars? Tools > Options,
View tab. There were some early problems with 3D ...Column names are 1,2,3,....
I just noticed today that the column names in my excel
spreadsheets are no longer alphabetical, but are
numerical. The column marked "1" is defined by excel as
column "1C", and row "1" is defined as row "1R".
How can I get the column names to change back to the
Tools > Options > General
Remove check from "R1C1 reference style"
Norman Harker MVP (Excel)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good...Help with Outlook Add in Manager
I just changed move to a new computer and used Windows Easy Transfer to
migrate settings from my old compute to my new computer. Some old junk
Outlook 2003 add-ins were migrated to outlook 2007. In 2003 the Add-in
manager used to be in the tools-options-other dialog, I can't find it in
2007. Can someone help? Thanks.
Tools | Trust Center | Add-ins.
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
and Microsoft Outlook Programming - Jumpstart for=20
Administrators, Power Users, and Developer...Activate email column to hyperlinks
I have a colume of email addresses in an excel 2002 document. I need to make
them active hyperlinks - How ? Microsoft instuctinos are useless here.
can't they be converted in one batch to active hyperlinks so when the email
address is clicked on, the email program opens in a fresh email ?
Many thanks for any help
"DixieWins" <DixieWins@discussions.microsoft.com> wrote in message
> I have a colume of email addr...How to Find Record if Exists, Add if not?
How to Find Record if Exists, Add if not?
I have a form where user will enter the vendor ID, which is a unique ID.
They enter it off a long list of information listing many vendors and it's
hard to know if the vendorID already exists in the database, until they tab
through all the fields and get the duplicate record error. Then they press
Esc and do a search on that vendorID to pull up the existing record to
VendorID format is similar to this A123456789ST (Usees a prefix, Vendor
FEIN, State abbrev.)
I want to automate this. when they enter the VendorID, I want it to s...Splitting multiple cell contents from 1st column into 4 columns
n my first column I have 4 cells (1-4) (5-8) etc. with general content.
The content from each of these 4 cells needs to be placed in a separate
column to make a list that I can sort etc.
Example: COLUMN A
2 Heatherridge Road #301
3 Harry Smith
4 H25 Condo Fairfax Place
6 McGrath Street # 56
7 Mary Jones
8 B45 Condo Lemon Circle . . . . . . and so on and so on
every 4 cells.
I have hundreds of 4 cell descriptions. I just can't do this one by one.
Can anyone help, PLEASE, PLEASE. I am really a novice at Excel though I
use it for e...Add a Holiday design to my labels
I already have Avery 5160 return address labels printed with my name,
add,etc... I would like to add a holiday design to them...How?
From the Tool bar select Insert, Picture, Clip Art and select from the
"Lisa in Lakeland" <Lisa in Lakeland@discussions.microsoft.com> wrote in
>I already have Avery 5160 return address labels printed with my name,
> add,etc... I would like to add a holiday design to them...How?
...How do I add phone/office to my outlook properties ?
I want to add my details like phone/office to my outlook properties (the ones
you get on clicking on your name and selecting outlook properties among the
options that appear). Can somebody guide on how to do this. The mail account
I use is on an university exchange server. I tried adding the details to my
University telephone directory but they are still not reflected in outlook.
Do I need to contact my university exchange account administrators to get
this done ?
Yes, you need to contact the administrator.
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
...Add ... to long strings
Is there a standard function to add ... to long strings ?
DrawText has the option. Generally, I consider this a Really Bad Idea Almost All The
Time, although I've come up with a couple useful exceptions now and again. Putting ... in
a path name, however, is ALWAYS a mistake. I wish there was a user option to disable this
completely and forever under all imaginable circumstances.
On Wed, 5 Nov 2008 12:35:34 -0800, "Michael Tissington" <email@example.com>
>Is there a standard function to add ... to long strings ?
Joseph M. Newcomer [MVP]