Help with formula #18
I am WAY over my head here, and you all have always been great help,
so hopefully someone can help with this. I had someone write this for
me to use as an index at the top of a spread sheet. It works
beautifully . The problem is I would like to move this index to sheet
2 of the same spreadsheet and when I copy and paste it, it does'nt
work. Is there anyone who can modify this to work as an index in
sheet 2 and will search sheet 1 for the results?
=IF(#REF!="","",IF(ISNA(MATCH(#REF!,$H$31:$H$65536,0)),"",HYPERLINK("#"&C...Help needed with Money 2003 files
Hi there, I've been using money 2003 for years even when upgrading to new PC's as I had the original disk.
I've just had to rebuild my hard drive and now cannot find the disk anywhere so cannot install Money. As you cannot now buy Money, I've tried downloading the trial version of Money so that I can access all the account details/balances but it says that they're not compatible with earlier versions of money.
Is there anything that I can do to get these files open or have I lost all my records for the last 6 years?
I'd really appreciate your assistance. Jayne
EggHead...Using Blackberry to update CRM
I'm almost positive that this will work, but I'd like someone out there to
If a user has a Blackberry that connects to Exchange using BlackBerry's
server integration software, and that user edits a record that syncs to
Exchange, will that change be reflected in CRM 3, assuming that the record
is tagged for tracking in CRM?
I can't see why it wouldn't work, but I want to make sure.
Thanks for any feedback! -Eric.
Sorry this will not work. YOu might want to check out tendigits.com for a
full blackberry integration to CRM
==============================...Using Journal to track Project Correspondence ??
I've been trying to read up on the Journal feature, but I'm not sure how I
can get it to "compartmentalize" activities related to a project.
How would I do this?
You can try using Categories on the journal entries
"Bill Allen" <T.W.Allen@cox.net> wrote in message
> I've been trying to read up on the Journal feature, but I'm not sure how I
> can get it to "compartmentalize" activities related to a project.
> How would I do this?
Thanks for your respo...keyboard command used to select a range of nonadjacent cells?
does anyone know the keyboard command used to select a range of nonadjacent
1)Use the arrow keys to select the first cell of the range
2)Hold down the [Shift] key while you extend the selection using the up,
down, left, right arrow keys.
3)After the range is selected, and while still holding down the [Shift] key,
press the [F8] key (they release all keys). You will see the word 'ADD' in
the lower right of the status bar.
Repeat above steps until done selecting non-contiguous ranges.
Does that help?
> does an...Installing and using Office: MAC 2008 Home and Student Addition
Operating System: Mac OS X 10.5 (Leopard)
My husband recently purchased a new MacBook Pro. He gave me his MacBook Air. Office Home and Student addition was installed on his old computer (MacBook Air), and was loaded on the new computer. I purchased my own copy of Office: MAC 2008 Home and Student and installed it on the MacBook Air but can't use when my husband is using his version. The product keys are obviously different, but when he's writing in Word, I cannot. The message is that two people can not use the program at once who are on the same network. What do I do so ...Push single contact field data into prepared excel workbook
I am new to macros but ameager to get some formulated to help run my small
I have been trying to find some code which suits my requirement of pushing
signgular fields from a contact into a pre-prepared excel book which is
loaded with the next stage of macro-powered automation.
I recieve enquiries both via email and by phone. I use my blackberry to
save phone enquiries to address book and Anagram for Blackberry to capture
the required contact data from our email enquiry form. Both are then
synchronised with my Outlook contacts.
Either from the point of creation, or through ...the last one to three characters of Y-axis label cannot be display
I am using Sony VAIO laptop (Model PCG-K23). The y-axis labe cannot be
display fully in Excel 2003, Excel XP, and even Excel Work that came with
this laptop. The Sony customer care guys attribute this problem to MS
software problem. Does any one know how I can solve this problem? I have
updated my Office2003, Window XP, and even graphic driver (ATI Radeon IGP).
...Excel 2003 with SP3: border around active cell not moving when using keyboard?
When I use the arrow keys on the keyboard, the border around the
active cell does not move to the next cell. Only the horizontal/
vertical scroll bars move. This started happening 2 days ago.
Any ideas what options I may have accidentally toggle?
Your SCROLL LOCK key is on. Press it again to turn it off. The key is
typically labeled "ScrLk" and is above the Insert/Home/PageUp buttons.
Most keyboards have an LED indicator lamp that is illuminated when
Scroll Lock is on. Also, Excel will display "SCRL" in the lower right
corner of the main Excel window when Scroll Lock ...Clear rows where field contains a negative sign
I have a procedure called that looks for a negative sign (*-*) in the D column
for all records. If it exists, the entire row is deleted. The procedure below
works well for this situation, BUT when there are no records with the negative
sign in the D column it deletes the first record in row 1. The Range somehow is
set for the value in the D column for row 1.
I have been unable to stop this so far.
Does anyone have a way to not delete row one if the filter is not met?
Here is the procedure:
Dim r As Range
ActiveSheet.Columns(&...Mapping Geographic Data
I want to create a data map and I need to have Microsoft Map installed.
Apparently Microsoft Map was not installed when our IT Department installed
Excel (I am running Excel 2003).
I believe I ahve to rerun Setup to install Microsoft Map however my IT
Department says they can't find Microsoft Map in the Setup file.
Can any one help me tell them how to locate Microsoft Map in the Setup file?
Map was dropped as a free add on to excel after xl2000, I think that's
Anyhow to get Maps in xl2003 you will need to buy the standard alone
Mike wro...Need help with using a bar graph in a report
I have a report that separates information about representatives by manager.
I need the graphs to give a quick summary on a few stats from each rep but
only show for that manager's team and not all information.
Manager A has RepA, RepB, and RepC under him. Each rep has Aux1, Aux2, Aux3
information which needs to be displayed. My goal is to show Manager A with
his Reps A,B, and C of their Aux1, 2, and 3. Then, under the next manager
Header I want Manager B to show Rep D, E, and F with their Aux1, 2, and 3
information. Etc thru Manager G.
Th...Formula problem #9
I have entered a small formula in a cell =A1+B1 the result is also fine but
if i have edit the formula i have to again type the entire thing.
Is there a shortcut to this where i can easily do the editing of the
formula, i guess i am missing something out here.
I guess you are not able to see the formula in the formula bar if it is so
then go to Tools|Options|View|check the formula bar check box|ok
Click "Yes" if it helps
> I have entered a small formula in a cell ...Linked cells, make the data go hard manually
I'd like to convert a cell linked to a previous day to hard numbers once a
day. Is that possible?
By 'hard number' you mean one that is no longer linked, you could copy, then
paste as, paste value.
> I'd like to convert a cell linked to a previous day to hard numbers once a
> day. Is that possible?
...how to find used region with macro
sorry if this obvious or has been asked recently.
I have a macro that goes through all rows and all columns in a
selection. If a row or a column is hidden, the font of that row or
column is changed.
A friend wants to use the macro in a Workbook with many sheets. He
asked if I could change it so that he does not need to do a selection
on every sheet before he runs it.
I imagine that a nested loop through all rows and all columns will
take a long time?
I�ve tried to figure out how to get the range defined by the last row
and the last column filled with data.
First I tried with Current...Subform Data Entry Problems
I have a subform based on a query linked to the Form by "ContactID". The
query works fine when run independent of the subform. I am able to enter all
data fields and where necessary the autonumber function assigns properly.
But when I try to use the subform all records related by my table
"tblADDRESS" do not allow data entry (the fields are not locked). I imagine
the ContactID Master/Child link in some way is interfering with the query in
Form view, but I've tried every variation of join properties within the Query
for the Subform and in the Query for the main...Avoid pasting over hidden rows
I have a quick question in regards to pasting data over a
range with hidden rows. Is it possible to paste data
over a range of cells and avoid pasting data in hidden
rows? Let's say sheet2 has data in range A1:B5 and row 2
is hidden. Let's say I copy range A1:B4 from Sheet1 and
paste on Sheet2 starting in cell A1. I would like the
data to paste over rows 1,3,4 and 5. (skip hidden row 2)
I'm pretty sure the answer is no but I thought I'd ask
anyways since there are some clever folks out there who
might find a way. (Without using VBA)
Thanks in advance.
W...Printing Autofilter Data
How do I print Autofilter data onto one sheet instead of a few lines on say
In page Setup, select fit to print and select 1 page wide and 1 page high.
"Confused" <Confused@discussions.microsoft.com> wrote in message
> How do I print Autofilter data onto one sheet instead of a few lines on
> 20 pages?
"Tom Ogilvy" wrote:
> In page Setup, select fit to print and select 1 page wide and 1 page high.
> Tom Ogilvy
>...Prevent functions from changing when new rows are added
I have a worksheet configured as a timesheet, where each row represents a
task performed. For any given day, I track the task(s) performed and the
hours spent on each task, and there are many functions in the worksheet.
The worksheet contains the following columns:
Column A: blank column (not used for anything).
Column B: series of dates (with a blank row in between each date).
Column C: tasks performed, manually entered.
Column D: hours worked on the task.
Column E: hours worked for the week. There's a function in each cell where,
if it's Sunday, a sum of the week's...Parameter Query using date ranges
I am creating a parameter query where I want to pull data between 2 dates.
In the date criteria of my query, if I write between #01/01/2008# and
#01/31/2008# +1, I will get all data for January. If I use a form to enter
the dates and have Between [Forms]![autoexec]![start] And
[Forms]![autoexec]![end] +1 in the date criteria, I get an error. Does
anyone know what I should put in the criteria to make the query work?
Are you entering your dates as m/d/y?
What happens if you try:
DateAdd("d", 1, [Forms]![autoexec]![end])
Is the form open?
Microsoft Access...Fill null fields from last record non-null in that field
Access 2000 -- I have a database table which is built from an import from a
I want to fill blank fields in records from the last previous record that
has a value in that, and then when Access encounters a new record with a
value in it, have this pasted into the fields below it.
Now, it looks like this:
I want it to look like this:
9 "0...Can't open database window using shift key...
I have an Access database that I distribute to my client on CDROM. The
start up options of the database are set so that the database window
is not visible to the users. When the database is updgraded the
database manager copies it from the CDROM to the relavant PC and then
uses the shift key on opening in order to display the database window
and link to the tables in the existing back-end. This procedure has
been done many many times without a problem...
BUT last week he found that holding down the shift key whilst opening
the database no longer opened the database window and leave...populating from sheets -- and PLEASE don't tell me I need VB!
Stupid newbie question, Excel 2003:
I have a 2 sheet document. SOME of the info from Sheet 1 needs to appear on
For example, Sheet 1 Column G values need to be populated to Sheet 2 as
Column B, Column H needs to be Column D, etc.
Is there any way to automate this without having to write a VB script? I
know a macro could kind of do it, but I don't think it could take all the
parameters, since Sheet 1 is constanly being altered (i.e., new values,
etc.). Oh, and all rows are relational so that G3 value from Sheet 1 when it
goes to Sheet 2 B17 also has to have H3 from Shee...Suggestion for using CStringArray with Unicode, mulit-byte, ATL &
I couldn't find the "development" group so i chose this one.
I am trying to bring some code that has the CStringArray in it from a
Multi-Byte project into a Unicode project and I keep getting errors I cannot
Project type: DLL
Use MCF: Shared DLL
Use ATL: Not using ATL
Min CRT Use in ATL: No
Char set: Unicode
added afxcoll.h to stdafx.h as suggested elsewhere
I get the following error;
Error 247 error LNK2005: _DllMain@12 already defined in Te...Last value in column before blank
Hi, My data in one column A:A - Where V100 &V101 are product codes, dates run
down the column and Blank is a blank cell befor each new product code.
Question is how do i return the date value for the last entry (eg before the
blank) for each product code I want to find. Note also the last date entry is
always the max value date. Eg V100 = 2-Sep and V101 =10-Oct.
One formulas play ...
Assume your source data running in A2 down
Put these in B2:D2
In B2: =IF(LEFT(A2)="V",A2,IF(A2=&...