Update one table from another
I am trying to update one table that has one record for each employee(table
1) with available vacation time. The other table records every time off
request(table 2) and how much time they want off. I have the update query
and it works fine. The problem is that everytime it is ran every requested
time off amount(from table2) is subtracted from the available time(table1)
again and again. I want the records for requested time(table2) to update the
employee available time off(table1) only once, but keep the records on the
table as that is the basis for a report.
----=...Copying data from one chart to another
I have many graphs - all plotting on similar scales but using different
data. Is there any way I can simply copy one set of data from one graph
and paste it into another graph so that I can avoind going through all
the hassle plotting each curve again? I want to have graphs showing
different combinations of the same data and have hundreds of curves to
plot so this could be a huge timesaver...
Alan_Partridge's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29295
V...Text to columns
Once I use the Text to columns feature in Excel, it seems there is no way to
turn it off.
Anyone know if there is a way to reset this so that newly pasted text will
not continue to get broken up (for example by the space delimiter)
Presently the only way is to exit Excel and restart Excel - then pasted text
all goes into one cell regardless of spaces.
Hope I explained that well enough
I may have been to hasty in making this assumption, it appears that the
problem I described below is only happening on one workstation - this may
indicate that the Excel Registry keys are in need of...1 Chart
I presently have an XY line chart showing asset price over time. Pretty
X Axis - Time Scale
Y Axis - Asset Price
I would now like to add an additoinal series showing the volume of
assets traded, ideally this would be as a bar chart sitting
"underneath" the asset price on the chart. They would share the same X
I have added another series, but this simply displays the volume traded
as another line, and even when this is set to a secondary axis the
scaling makes this unworkable. i have adjusted the scales of both,
still this does not make it workable, i want the series...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 ...Simple Question-How to create more than one transaction on the Acc
If there is a question already posted let me know. The question is: I created
a bank account information on the Account list icon and want to have more
than (one)transactions listed and see each payee displayed separately on
each page so i could have all the months posted with due dates and total
listed. Thank you.
In microsoft.public.money, a.j. wrote:
>If there is a question already posted let me know. The question is: I created
>a bank account information on the Account list icon and want to have more
>than (one)transactions listed and see each payee displayed separately ...Can I abbreviate one value in a data series?
I've got a chart where one value (8,300) greatly exceeds all the others. Is
there a way to abbreviate this value so the other data points show better in
One way is to break the Y axis, have a look at these examples of how to
> I've got a chart where one value (8,300) greatly exceeds all the others. Is
> there a way to abbreviate this value so the other da...Percentage difference calc that knows the largest figure
I have a calculation in cell A3 which looks at the content of Cell A1 and
Cell A2 and then works out the difference between both as a percentage
Cell A1 = 100
Cell A2 = 10
Cell A3 returns the difference as being 90%
My simple calculation in Cell A3 is as follows =(A1-A2)/A1
Cell A3 is formatted to give the answer as a percentage to 2 decimal places
The above works fine as long as the number in Cell A1 is greater than the
number in Cell A2
If the number in A2 is greater than the number in A1 then my calculated
answer is incorrect
Cell A1 = 10...Moving from Home & Student to Full version of Office
Operating System: Mac OS X 10.5 (Leopard)
I need Exchange support and therefore I am planning to buy the Full version of MS Office 2008 for Mac. I already purchased and installed (and have been using) MS Office 2008 Home & Student edition.
My questions are:
1. Should I uninstall the Home & Student edition before installing the Full version? (I assume so).
2. How do I make sure that the data I have already created in Office 2008 Home & Student edition will be available to me after installing the Full version? In particular, how do I make sure that ...Too many different cell formats #6
I am running into the error message:
Too many different cell formats
Is there a solution to lowering the number of formats I
am using? Just trying to change them to make some
consistent gives me the same error message.
I tried running the search on the forums on my topic but
they have been disabled for a Microsoft upgrade.
One idea -
Rob Bovey's excellent Utilities add-in will list all the formats in use in
your workbook, allowing you to manually delete what isn't being used.
You can also see the source code for ...Office 207 One Note
My One Note has been working fine for at least 2 years. Then a couple of days
ago two pages of my most important information in my main workbook just
I'm not sure but none of the other pages look the same. Does anyone have any
idea what might have happened? Have had no other computer problems recently.
-------- Original-Nachricht --------
> My One Note has been working fine for at least 2 years. Then a couple of days
> ago two pages of my most important information in my main workbook just
> I'm not sure b...How do add another code to a current one?
I have this following code to make the rows changed based on the critea in
column 16, and I need add A "Red, Yellow, Green" for status to only one
column 30 at the end of the spreadsheet. How do I add another code? I keep
getting an error..
Private Sub Worksheet_Change(ByVal Target As Range)
Dim c As Range, clr As Long
For Each c In Target.Cells
If c.Column = 16 Then
Select Case c.Value
Case "Analyze": clr = RGB(204, 255, 255)
Case "Build ": clr = RGB(204, 255, 255)
Case ...Hide Global.xls (personal.xls) in project explorer
How do I hide VBAProject(Global.xls) in project explorer. I just want
my normal project there.
You can't hide it, but you could give it a password:
Select your project
Give it a memorable password
At least the project won't be too intrusive.
> How do I hide VBAProject(Global.xls) in project explorer. I just want
> my normal project there.
...Bulk sending of emails in Outlook being rejected if one address is wrong.
I am sending bulk emails in BCC and they are all being
returned to me because one or more of the email addresses
is incorrect. Is there a way to setup Outlook so that the
emails go to the correct addresses and the incorrect
addresses are bounced back to me?
I use the Mail Merge feature and send out a newsletter
with over 1000 e-mail addresses (who signed up for the
newsletter so it is not spam). My service provider,
Comcast, just put a limit of 10 at a time. It's real fun
sending these out monthly!!
>I am sending bulk emails in BCC and they a...Users cannot login to OWA after Exchange 2K3 was moved into different OU
I created a new OU named member servers, and moved the
exchange 2k3 server into it. After I moved it, only the
administrator was able to login to OWA successfully. No
users could login to OWA. I created a test account with a
mailbox, and was able to login to OWA with the newly
created test account. I then moved the exchange 2k3
server from the member servers OU into the computers OU,
and the newly created account was unable to login to OWA.
Any help with this would be appreciated.
...Moving certain data to different sheet
I need to move data that meets a certain criteria, to another sheet within a
workbook. For instance, if a column of data is for a certain ZIP code area, I
need it to automatically copy to a sheet for that city. Say, 40202 would go
to the Louisville, KY sheet. Because Louisville has multiple ZIPs, I would
need only the data that begins with 402 to go to that sheet. Lexington KY's
data, which begins with ZIP code 405, would go to its own sheet. Macro?
This can definitely not be created with a formula. I suggest that you make
use of the macros.
Kris...one company doesn't show $ amounts in payables for one user
I have a user who has access to multiple companies. The access for all
companies is the same. In one company when she goes to
Inquiry>purchasing>trx by vendor, the display shows $0 for all transactions.
Other companies, she sees the correct $ amount. There are no modified
windows and again her security is the same for all companies. Can anyone
tell me why this is happening?
I am having this exact problem and would appreciate a fix. I have to change
users to have the payables inquiry amounts show. I only have this problem
in one company and I am the only user in our of...Are there MFC subclasses that give a different "look and feel" to the UI?
I was wondering if there are free implementations of MFC subclasses of
windows and controls that give you a different look and feel? I like
the Windows 2000 look, but it's quite a bit dated now, and the XP look
is hideous for my taste, so I'm looking for something new, more modern
looking, sleek. Thanks in advance for any suggestions.
See if this has something your looking for.
"Franco" <firstname.lastname@example.org> wrote in message
>I was wondering if there are free implementa...how to convert a CString variable to unsigned short array one?
In my unicode VC6 app, how to convert a CString variable to unsigned short
unsigned short strOleChars;
strOleChars = strRst; //???
Is ConvertStringToBSTR() what you are looking for?
"David" <David_Wang_Xian@hotmail.com> wrote in message
> In my unicode VC6 app, how to convert a CString variable to unsigned short
> CString strRst;
> unsigned short strOleChars;
> strOleChars = strRst; //???
> Thank you.
...Prevent copy and paste in one column
I am having trouble trying to prevent copying and pasting in one specific
column. The code refers to the specific range, but yet it prevents copying
and pasting on the whole worksheet.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Columns("H:H")) Is Nothing Then
Application.CellDragAndDrop = False
Application.CutCopyMode = False
Application.CellDragAndDrop = True
Works for me in Excel 2003
Gord Dibben MS Excel MVP
On Fri, 30 Apr 2010 11:42:01...how do I turn off journal for one file #2
I have a number of excel files that run regularly. I how can I turn of
individual files so they don't clutter my jouranl in Outlook?
...VBA project locked
While importing the Calender package (Calendar80.Package) i got the
"Package contains items that cannot be imported becuase their VBA project
Date Dialong , Microsoft Calender control 11.0 and Rm_Analysis Report were
shown as locked
How to resolve this ?
Just need an input /advice...
what are the deliverables for a typical software development project for an
is it a norm to give the database design schema to customer, if yes, then in
I think you need to get a contract project manager in asap. You are
guaranteed to get the wrong thing right (most popular game in project
management unless you have sought complete clarity from your customer on
what will make the project successful and detailed this information in a
The database schema is usually part of th...What is Compatibility Mode format? How its different from others
What are the advantages/disadvantages of Compatibility Mode? Which other
format mode can be used?
Compatibility Mode uses only features that are available in Word 97-2003.
It is suitable for most purposes and will be used for any document that is
saved in .doc format, rather than the Word 2007 docx or docm formats.
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"author2010" <email@example.com&...When is Microsoft coming out with updated version of Publisher?
I've been using Pubisher since 1997 and it's great...but now it's almost FOUR
years old with no no version! More graphics, more WordArt options, that
would be nice. When are we going to see a Publisher 2006-7??????
There is a new version of Office being beta tested now with an approximate
release date of Spring 2007.
(No clue about the amount of clipart or WordArt. Sorry)
MVP Microsoft [Publisher]
"Nancy O'Brien" <Nancy O'Brien@discussions.microsoft.com> wrote in message