making global changes
I recently imported my checking account data, over 2000 transactions, from
an Excel worksheet. The data was accurately imported, but it didn't import
the expense category associated with each transaction. Is there a way to
have Money2002 globally change all checks written to Payee A assigned to
I can re-import the data if I knew what to name the column and what order to
place it in Excel. Maybe someone know the answer to that.
Thanks in advance
In microsoft.public.money, Michael Israel wrote:
>I recently imported my checking account data, over 2000 transactions, from
I've trouble with RUS on E2k3. The initial autocreating of e-mail works w/o
problems, that's good. However, if I change any attribute that some RU Policy
using to compute address (i.e. given name or surname), the RUS do not change
the user email. The policy is set to "%firstname.lastname@example.org", but if I change the
user's name or surname, his e-mail is not changed and the old one remain...
Is this "by design"? Did I omitted something?
Thanx for help!
To my knowledge, RUS isn't designed to "keep user accounts up to date". It
stam...Formula Changes when data entered in referenced range
I have 5 formulas in a worksheet that refer to a range. When data is entered
in the range, the formulas adjust to exclude the cells with data. Range
B5:B211 When data is entered in B5, range in the formulas becomes B6:B212.
The workbook has nearly 200 worksheets with the same formulas. I'm working
in Excel 2003. Does anybody have any idea what's going on?????
Might help if you include the formulae that you are using.
"mac849" <email@example.com> wrote in message
>...Filling cells in between pairs of numbers
I am trying to find an easy way to fill in cells in between pairs of
numbers each of which is exactly the average of the pair's difference
averaged by the number of these cells greater than the previous.
So I have
I know I can do a Fill, Series, but then even with a macro that does a
"control shift up fill series enter",...Case filled out from SharePoint
I need to have a simple form my users fill out to submit a case. This would
include the Business Required fields on the CRM Case form. Is there an easy
way to do this using SharePoint?
In other words, the user would go to the SharePoint site, click a link to
"Submit a Support Request". This would open a form (Infopath perhaps?)
where they fill in a few simple items, click submit, and a new CRM Case is
created. This then would fire any pertinent workflows as if the case had
been created from within CRM itself.
I'm aware there are 3rd party solutions out there but would...MDI Application
I have an MDI application. The tabs are enabled. When a
new child window is created the main application window
title is updated - it displays the same string as the
child window tab. This only works when a new child window
is opened/created. When I just switch between the tabs the
application window title is not updated, it still displays
the name of teh last child window that was created.
Could anyone help please?
Thanks in advance,
It's been a while since I have developed MFC actively but there is
definately a way to change the title bar text with a member fun...Matching cells by content then cell fill with color
Thanks to JEM, I am using this routine to color three consecutive cell
a specific color, in this case red:
Public Sub ThreeCellsRed()
ActiveCell.Resize(1,3).Interior.ColorIndex = 3
What I need now is a way for the routine to continue to find all th
similar cells, let's say for sake of disc they are people's names, s
when I execute the above on my name, mrh, I want it to continue in th
worksheet and find all exact matches and color those same cells red.
Another thought, say my name (MRH) is in "A1" and it is also in "D1".
But in "D1" I use "...Spontaneous format changes in Excel
I have a user who says that he experiences spontaneous format changes in MS
Excel when he is working in his Monthly Receivables Analysis 2009 workbook.
Every month beginning with the start of the fiscal year, he adds more data
into the workbook so the size of the workbook grows continually until the end
of the fiscal year, when he starts a brand new workbook. Currently, the file
is 82,087KB in size (a very large spreadsheet). The user says that when
working in this Monthly Receivables Analysis workbook, if he changes the
decimal places of a cell range on the summary sheet from tw...Modify a format style
When I try to modify the "Normal" format style it won't let me because (I think) under 'Protection' it's 'Locked'. How can I unlock it when the modify option is unavailable? I'm trying to create a spreadsheet using the 'Format Cells' option for Currency, but my spreadsheet refuses to apply that option even if under 'Edit" I clear 'All' or even just clear 'Format'. My spreadsheet still shows .25 as 0.25 - I want to get rid of the zero to the left of the decimal. And yes, I have checked even my Control Panel 'Regional ...Change Store ID HELP!!!!!
I have an old PC, and replaced it with a new one, I put the wrong store
number on the new PC and it ran a sync, now I cant change the store number,
any IOdea how to change the store number back?? Please help thanks
On the new PC run the following SQL query
SET StoreID = ''
Note: after the equals it is 2 single quotes.
Now you can set the store id to the correct number.
Always test any queries that modify data on a test database prior to running
on your live data to ensure the desired results.
Always back-up prior to running any SQL delete queri...From field filled in
Hi and thanks in advance for this help. I am using Office 2003 with
Exchange 2003. I have a second mailbox setup in my profile. When I
reply to an e-mail sent to the other inbox, the From field is
automatically filled in with that name. So for example, if the other
inbox is "HelpDesk" and I reply to an e-mail in that inbox, the from
field is automatically filled in as "HelpDesk".
Hope that makes sense.
<firstname.lastname@example.org> wrote in message
> Hi and thanks in advance for this help. I am...email address change
...Change negative amount to positive.
I have in cell K2 "30" (without quotes)
I have in cell L2 "45" (without quotes)
In cell M2 the formula "=K2-L2" (without quotes)
The result in M2 is of course -15.
The values in K2, and L2, change once a week.
Is there a way to show the result of the formula to
always show a positive amount,
and to react as a positive amount during a 'sort'?
I hope this is clear!
Microsoft MVP - Excel
"George" <email@example.com> wrote in message
news:%23KsAEvFlFHA.576@tk...change autocomplete choice in to: cc: or bcc: fields
is there a way to change or remove a name that
gets "autocompleted" in the to:, cc:, or bcc: fields?
right now i have 2 entries that begin with "jennifer" and
i'm always prompted with the one i don't want. is there
a way to change this?
You can just delete the one you don't want when it pops up.
i realize that, but i'd like to change it to prompt me
for the correct one.
>You can just delete the one you don't want when it pops
>i realize that, but i'd like to change it to pr...format cells option not working
when i highlight some cells and try to format them nothing happends,
workbook and sheets are not protected, cells in question dot not have any
data in them at all, totaly blank!
if they are locked how can i findout? and how to unlock them?
OFF: Changes to Fill Color and Fill Pattern Are Not Displayed
Regards Ron de Bruin
"Steven" <firstname.lastname@example.org> wrote in message news:K3Yfc.2505$UG1.email@example.com...
> when i highlight some cells and...Operating fill handle and moving entire cells with keyboard
Is there any way of operating the fill handle or moving
entire cells/range of cells with the keyboard rather than
using the mouse (drag and drop).
Copy or Cut
Select range Select top left corner of range.
Hold Shift & press End, Arrow down or right.
Copy:= Ctrl + C
Cut:= Ctl + X
Paste Ctl + V
To Fill Down or Right
Ctrl + D or ctrl + r
Use Excel Help and search for keyboard shortcuts for a
>Is there any way of operating the fill handle or moving
>entire cells/range of cells with the keyboard rathe...Draft emails not retaining changes
I am finding that after making changes to an address in a
draft email and saving it again, the changes do not hold.
Does anyone have any idea why? This is Outlook 2000.
...Colours changing in the fill palette and the spreadsheet?
I have a user with Office 2003, and her pc and build is standard as with her
In Excel the colours would change (cells filled) also if the user goes to
her pallette the colours have also changed.
Desktop and all other applications colour are fine.
The following resolutions have been tried - office detect and repair,
updates, asked the user to got to the tools options and reset the pallette
and this does not work.
She has to log off and back in again in order to set it back to the proper
Again this is only affecting Excel?
I wish to thank you in advanc...Changes to working code
I have some code that gets data from an Excel 2003 spreadsheet to populate a
listbox in a userform:
Dim db As DAO.Database
Dim rs As DAO.Recordset
Set db = OpenDatabase("E:\My Documents\Excel Files\DemoSpreadsheet.xls",
False, False, "Excel 8.0")
Set rs = db.OpenRecordset("SELECT * FROM `mySSRange`")
While Not rs.EOF
Set rs = Nothing
Set db = Nothing
What do I need to do to modify this code to extract data from a Excel 2007
format file (xlsx or xlsm) and an E...Have one fill to auto fill aother
My question is simple. I would like to have field 27 = field 25.
So when someone enters the data for field 25, the same data auto populated
in field 27. Any help is appreciated!
In the CotrolSource for Field 27 type...
....assuming of that you are talking about a form in Microsoft Access or did
you mean to post this question in the Excel newsgroup?
"I feel I have been denied critical, need to know, information!" - Tremors
"Kaylen" <Kaylen@discussions....Include credit memos on checks without applying to an invoice
Currently, you cannot include a credit memo on a check without applying it to
an invoice. If that invoice is already paid, you have to apply it to a
different invoice -- one that has nothing to do with it! You lose accurate
transaction history for both invoices -- the one already paid and the one
being applied against.
We are in the retail industry and receive tons of credit memos that adjust
costs on previously entered invoices at each month-end because we met
quantity orders. It is impossible to apply them to original invoices and,
therefore, have to apply them to invoices that th...Formatting Axis
I am building a Line Chart on Excel 2003 with data from multiple sales
divisions trying to show their growth in month to month sales. At the same
time, I want to include a line for the total company but when I do, the lines
for the divisions are all clumped together. How do I show, for instance, a
set of four numbers running with dollars ranging from $500,000 to $3,000,000
for each month and then show the main company summed at $10,000,000 per month
without having the first 4 lines all bunched together? Is there a way to
omit the values from $4,000,000 to $9,000,000?
Hope I explaine...Filling in blank PO
I have some question to you, when you create blank PO, then go to content
and click Add Item you can see tw boxes. In top one there are all items from
your database and in bottom one there are Items you are adding. If you reach
number of rows visible in bottom window there is scroll bar comming on right
hand side, and as you add more items every new ona is going to the very bottm
of the list which is in invisible area. To get there and type in Qty you have
to scroll down whole list every time when you add next item.
I'm using most recent updates for RMS and I checked i...Changing e-mail address
dI´m trying to change mail-address in AD-Users and computer.
From "firstname.lastname@example.org" to "email@example.com", but it won't work.
On the tab "e-mail Addresses" i try to set "firstname.lastname@example.org" as Primary, but it
don't stay that way. If I open directly and check it seems right, but close
and do one more client, the first has change back to "email@example.com".
What am I doing wrong ????????
You will need to uncheck the checkbox "Automatically update e-mail addresses based on recipient policy" for the change to stay.
Also make sure that you ...how do i make a date change automatically if i change one before .
I have a production schedule within an excel document. I have a start date
and a release date. Between these dates I have different dates that
represent deliverys, approvals and review dates. These dates are sometimes
changed due to weather, client issues, etc. Everytime I have to change a
date, I have to look at a calendar and make the changes in each cell after
the first change.
Is there a way to format all the cells after the first start date, so if I
change one date, all dates after that will change the same amount of days,
leaving out weekends and national holidays.