EXCEL Mask for data entry
I don't have MS Access but I want to create an Access
type Entry Mask for the entry of data into appropriate
cells within a background work sheet.
I want to create this as a simple entry form for non
The form would have 6 column and there would be a need
for a look up table so when I entered an equipment asset
number, its appropriate serial number would auto insert?
Am I being too hopeful that such a facility exists within
Excel? If by chance it does, where would I look for
This is very possible in Excel but there are a few things
to unde...Problems opening Workbook
My Problem is that when I try to open my Accounts workbook I have this
notice appear:- "! Too Many Different Cell Formats". Then the workbook will
If I could open the workbook then I can rectify the problen of too many cell
So does anyone know how to force the workbook to open?
Check your other post.
> Hi All,
> My Problem is that when I try to open my Accounts workbook I have this
> notice appear:- "! Too Many Different Cell Formats". Then the workbook will
> not open.
> If ...Outlook 2002 crashes when exporting data
When I use the "Import and Export" option from the File menu and choose
"Export to a file" , Outlook 2002 crashes in module RM.DLL.
I'm running all of the latest service packs for both Windows XP and MS
Office Pro 2002.
Any clues that will help me identify the cause of this problem will be
...Use Combo Box to Select Month to Display Data on Chart
I have a bar graph that shows the following information
X Axis = Date
Y Axis = Copper Produced
Question: How can I enable the user to select a month from a drop-down list
and the chart show the data only for the selected month?
Here are a couple ways:
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
"Carlee" <Carlee@discussions.microsoft.com> wrote in message
news:7779E1...Extracting certain rows from data
I have a 4 column/4000 row spreadsheet. I need to extract the data on
only every 10th row. So I need 10, 20, 30, 40, 50, etc. I don't care
if the data is on the same spreadsheet, or on another one. I just
can't figure out how to do it. Anyone up for the challenge? All help
This example will copy the rows to a sheet with the name Sheet2
Dim R As Long
Dim rng As Range
For R = 10 To 100 Step 10
Set rng = Sheets("sheet2").Range("A" & Rows.Count). _
...Getting data from Access to Excel
i don't know if any body can helps me on this issue i wrote a code as below
but no data goes to recordset i think this is because of date format or
something like this because i can copy the fieds name the vaiables FrstDate
shows "12/31/2009" and LstDate shows "1/28/2010" please help.
Dim rst As New ADODB.Recordset
Dim conn As New ADODB.Connection
Dim str1 As String
Dim sID As String
Dim iCost As Integer
str1 = ""
sID = ""
Dim sPN As String
sPN = ""
Dim i As Integer
...Send MSA 03 data in body of e-mail
I used to send data in the body of an e-mail from MSA 2000 I now have been
working with 03 and it only allows me to send it as an attachment. How can I
get a record to be sent as the body of an e-mail
...I'm no longer able to enter data at the top of the screen
The data entry line just below the tool bars is now grayed out. For instance,
if I select a cell, the data in that cell no longer appears in the data entry
One guess ...
Try click View > Formula bar
It may be hidden ..
> The data entry line just below the tool bars is now grayed out. For instance,
> if I select a cell, the data in that cell no longer appears in the data entry
...Realtime validation feedback
Not wanting to reopen the can of worms on this, but by some coincidence my
boss was throwing around some ideas the other day that are not unrelated,
and I was wondering how certain scenarios could be dealt with. I'll give
some contrived examples here just to get the ball rolling*.
As a simple case, imagine a dialog with one field which must be an interger
between 1 and 100. We all know how to trap the input, validate it and
present some UI indicator of inside/outside range. Maybe paint the
background pink. So as the user types the number they see their error at the
very keystroke, ...XML Validation: required attributes
I was trying to validate an XML document against a XSD which works
fine. Then I tried to put in a version attribute on the root element and
set it to a fixed value of '1.0' in the schema. Guess what? The
validator completely ignores the attribute inspite of the fact that I
have set the attribute to be required and to have a fixed value of '1.0'.
Any ideas why that could be happening. Any help is appreciated.
Either you didn't do what you thought you did or the validator has a
problem. Which validator did you use and what are your schema/instance?
...data base corrupted again
This is a multi-part message in MIME format.
once again data base is corrupted and will not compact.
due to oversize data base.
did a sync on a news group with over 50K messages.
from that point on data base was shot.
trying to compact got the message that file was in use.
ended up deleting message store and creating it AGAIN .
this needs to be fixed.
you cannot create an account with lots of groups each with thousands of =
...Can I permanently delete/hide data within Pivot Tables?
Microsoft Excel 2002
I have 155 clients which I need to run Pivot Tables for! All with the same
pivot table layout.
Is it possible to run the Pivot table with the 155 clients as a Template
basically, then somehow delete or permanently hide the data leaving only one
client, so that I can save multiple copies for each of the individual clients?
Or can I set up a pivot table where I can automatically feed in parameters?
Client details are stored on an Oracle database!
Right-click on a Page Field and select Field Settings from the context menu,
then click the Advanced button. Yo...Migrating Tasks with Data Migration Framework
I've been working on a migration project from Goldmine to MS CRM. So
far, I've migrated all accounts (6000+) and contacts (10000+) through
DMF and subsequently used DMF to migrate all phonecalls (18000) &
emails (300) successfully. However, when i try to migrate tasks
(19000) the DMF simply doesnt migrate anything. The log says - "Failed
to migrate object: Server was unable to process request". This message
isnt of much help to nail down the issue.
I ran a stored procedure to create 2 activityparty records for each
participant in cdf_activityparty (one each for the user ...PivotTable "show data value as" question
I have a problem about using Pivot Table in Excel 2003:
In a pivot table I have a date field, grouped by year and month, as the row
field. The data field of the table is anything that can be summed.
Now when I tried to display the data field value as "Difference from
previous month", I found that January of each year is always blank, ideally
the data value in January should be display as the difference between the
actual January value minus December value of the last year. Any tricks to
show them? Thanks a lot.
If you group the dates by ...Insert formula even cells with data below it
Using this code
Sub Insertformula ()
For Check = 4 To 40000 Step 2
If Cells(Check, "b") <> "" Then Cells(Check, "b") =
My objective is to put this formula
Into every even cell in Column B with data below it. However if you tried
the macro you would see it does not work. If I could get any help thank you.
Please tell ...Need to read PAR PORT data bits URGENT
I have never read a parallel port in MFC yet. I need to read the input data
on the port tonight for a dog and pony tomorrow. I tried the CParallelPort
class but it didn't build and seems more than I really needed.. I am just
reading the state of the bits as there is a rotary switch connected to
ANy links or methods.. AM I missing the obvious?
Thanks again all.
First, using the parallel port for anything is intrinsically dangerous. The standard
parallel port driver does not support reading from it. (Besides, modern machines don't
have parallel ports). You wil...Synchronizing shared docs on companyweb
Is it possible to synchronize a folder (and subfolders) with the
shared docs folder in CompanyWeb? I can't immediately see how to do
it. I see you can create a briefcase in CompanyWeb but that looks as
though it requires manual intervention to "update all". I'm not sure
how SecondCopy would react to a path of http://companyweb/Shared
(using SBS 2008)
...Disappearing Shared Calendars
Hi all, I was hoping that someone out there could help me out with a little
dilemma that some of my users are going through. I recently put out a Shared
Staff Calendar via a site-wide email, the calendar was received by all and it
was added into the navigation pane in Calendars, like it should do. However,
I now have reports coming in that users have 'lost' that calendar.
I know that we restarted our Exchange Server a couple of weeks ago and had
this issue and had to have people re-open the calendar from that message.
But, this most recent time around there was no serve...Pivot Table: How can I organize data items in a row?
I am trying to build a pivot table which has categories only in row
fields but not in column fields. Instead, the data items should be
organized in columns instead of rows.
For example, this is what I have now with two data items (habitants and
But I want this:
Country inhabitants location
USA 240 America
Britain 60 Europe
Japan 120...Count matching data
I have a spreadsheet with 14 columns and 20 rows - and what I would like
is a formula that will look in a particlular row i.e B1:B14 and return
and X in cell B15 if consequtive cells of 4 or more initials are found
e.g. if B1:B2:B3:B4 = TT in each cell then the result in B15 would be X
and if c3:c4:c5:c6 = MM the result in B16 would be X. If however
B1:B2:B3 = TT and B4 = NN then no X is returned (cells will either
contain initials or be blank)
is this possible?
On Mon, 26 Apr 2010 15:58:59 +0100, Barny
I have a problem with an excel spreadsheet that i need help with...
I am studying a road network and it is represented by points (nodes) and the
space inbetween these is the road.
My problem is that obviously a road goes from say point A to point B but
also back the way from point B to point A. The data i have contains both data
from point A to point B but also from point B to point A. This data is
identical and to i'd like to delete the repeated data from B to A. The
problem is that point A may go to up to 5 other locations, ie to B,C,D,E or -
as roads do at a junction. Therefore ...CRM 3.0
I am building a CRM 3.0 Virtual PC development environment, and I want
to populate the CRM with test data. I have seen the Adventure Works
Cycle CRM Virtual PC, but it uses SQL Server 2005. We are using SQL
How can I get the Adventure Works data into my Virtual PC?
Are there any scripts anybody has developed to add a heap of data into
...Workbook Protectionand stiil use Comment function
I have a shared workbook that requires some fields to be used for data entry
and some fields for comments ( using the Xl comment function), however, when
I protect the workbook the overall comment function is also looked (still
allows viewing a previous comment). Is it possible to overcome this scenarion
so that one doesn't have to Unprotect the book or sheet everytime a comment
needs to be inserted or edited.
In Excel 2003 you can edit comments in protected sheet, if you check the
option for Edit Objects in the Protect Sheet dialog.
"olympiad&qu...ISNA VLOOKUP any data prefixed with a "C7" cannot be found?
Currently working on a quotation workbook, whereby monthly data dumps
result in users being able to create a quote by cutting in product
Major problem is that any time a product code that is prefixed with
"C7" is entered the product description is NOT pulled through onto the
Any suggestions on how to fix this would be much appreciated!:confused:
Mike Jenkins's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29588
View this thread: http://ww...Data Source Displayed in Web Part?
Currently I have a Team Site which has a subsite containing 1 document
library and what I'm trying to do is diplay this subsite doc library on the
parent site. Considering this library is not an option to add from the
browsers "add webpart" functionality, I assume this needs to be done through
Do I need to add the data source first? And if so, how do I then display
this as a web part?
Again, the goal is simply to display the sub-site's doc library as a webpart
on the parent site. Please advise on the best way to accomplish this.