Reply:

DATA VALIDATION #64
i have enter all my information in my cells for a drop down list ,but every time i close off the program and restart it the cells have no information in the cells , i then goto the toolbar and the information is still there when i push ok it is available again. should this happen? i thought once you saved it would all stay the same. thanks michael dap ...

Changing data depending on time?
Hi, everyone: Does anyone know if it is possible to change data in a table according to a date? Let's say I would like to change the contents of all fields that are two days old and I would like to Access to do the work. Can Access actually do the check/change automatically? Thanks a lot, Tom On 5 May 2007 10:30:54 -0700, tomasz.cichon@gmail.com wrote: >Hi, everyone: > >Does anyone know if it is possible to change data in a table according >to a date? >Let's say I would like to change the contents of all fields that are >two days old and I would like to Access ...

Chart Legend #3
I have Line charts on various sheets. The charts are identical in size. There are 12 items graphed on each chart. However, the legend on each of the charts seems to be displaying different numbers of charted items. I'm not sure how to explain this clearly. On one chart's legend, it might show 12 items (three columns with four items each), which is correct. Another chart's legend may only show 2 columns totally only eight items (it should be 12). I even have one chart's legend showing only 4 items (as if it is only one column displaying). I can't figure out what...

Changing vertical axis in chart in Excel
I have created a chart in exel that is supposed to represent monthly sales throughout the year in various categories. The vertical axis, which i need to reflect dollar amounts only reflect percentages. The months and the categories are correct. How can I change that vertical axis to match the financial data in my worksheet. I have the months in row A, and I have the categories in column 1. The financial data is in the corresponding cells. I'm running Office 2OO7. ...

How do I put captions on Excel charts?
I need to put identifying captions/labels below Excel charts. I've used something that I think was called captions in the past, but can't remember how to do it. These captions were outside the borders of the chart, but were linked to the chart so when I moved the chart, the caption stayed with it. If your drawing toolbar is open you can click on the text box icon and create comments that way. Hope this helps. Best of Luck, J pgrizzell wrote: > I need to put identifying captions/labels below Excel charts. I've used > something that I think was called captions in the p...

How can I change the chart so date is up and down and data is acro
I have a chart that has the date across the bottom (category axis) and the data up the side (value axis). I want to change these. Is this possible? Hi, It depends on what chart type you are using. Have a look at Jon Peltier's example for a line chart. http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html Cheers Andy speet wrote: > I have a chart that has the date across the bottom (category axis) and the > data up the side (value axis). I want to change these. Is this possible? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info =?Utf-8?B?c3BlZXQ=?= Wrote: &...

Data entry work using msoffice
Is anybody have an idea to get some data entry work in Ms office using word or excel, Ms access etc which can work from home. Please it would be very helpful if you can give a good and reliable website for this With thanks Polachan ...

Data Validation Question #5
The "Input Message" that can be added to Data Validation, has someho become dissassociated with the cells containing the Data Validation. In normal operation when you select a cell containing DV, the "Inpu Message" appears next to and slighty below the selected cell and the moved as you selected different cells, however on my sheet thos messages appear in a spot well away from the selected cell and don' move when you select a different cell. Is there some way to "re-attach" them to the cells short of removin the DV and putting it back. Thank -- Case -----...

column chart #2
i have the following columns - dates - no. of boxes packed - no. of boxes to be packed. how do i do a column chart which compares the no. of boxes packed vs to be packed ? On Aug 18, 6:08 am, Lynn <moley_c...@yahoo.com.au> wrote: > i have the following columns > - dates > - no. of boxes packed > - no. of boxes to be packed. > > how do i do a column chart which compares the no. of boxes packed vs > to be packed ? Hi Lynn, maybe the site of Jon Peltier will give you some insights: http://peltiertech.com/Excel/Charts/index.html Have fun, cheers Michael Hi Lynn th...

How do I make the x axis data the y axis data? #2
My graph automatically makes certain data the y axis and other data the x axis. I need to just reverse it for the graph I am looking for. Any suggestions? Hi Sarah, you can change the Source data of the chart by right- clicking it. There you can define the columns / rows for the x- and the y-axis. Best Markus >-----Original Message----- >My graph automatically makes certain data the y axis and other data the x >axis. I need to just reverse it for the graph I am looking for. Any >suggestions? >. > ...

insert text data using function
Hi Guys, I need help on the following matter. Suppose i have two column A and B. Now when i insert some text in the A1 cell i want the data automatically set up in the B1 Cell. Fox example if i type Linux in the A1 cell "Open Source" will be automatically inserted in the B1 cell but if i insert windows "close source" will be inserted autoamtically. I tried with if function but no success. How can i achieve that? Mosaddeq Aziz You need to set up all of your possible data entry values for column A on Sheet2. Then in column B on sheet2, put the values you want aut...

Data Migration 07-07-05
We're planning to replace our current CRM (SalesForce) with MS CRM 1.2 in 3 to 4 months. Any good tools out there for migrating data from SF to MS CRM? Hi, You can use the Migration Tool which is found on the installation CD's. But I believe there are third party tools available from Scribe to do this too. -Mark "HEC" wrote: > We're planning to replace our current CRM (SalesForce) with MS CRM 1.2 in 3 > to 4 months. Any good tools out there for migrating data from SF to MS CRM? I did alot data migration . I can develop component for you for this migrat...

How to send form data to tables programatically
Is there a way to programatically have a form update to the underlying tables? What I mean is... As a user types into a form, Access doesn't seem to actually send that data to the table (and thereby create autonumbers) until user moves on to another record. Is there a way to force that data to the tables (ie make the new records) while the user is still on the form? On Sun, 30 Dec 2007 11:33:02 -0800, markmarko <markmarko@discussions.microsoft.com> wrote: >Is there a way to programatically have a form update to the underlying tables? > >What I mean is... As a user ...

Entering data
Please help me enter data into cells that seem to be locked. In article <15a201c43e09$dbea4e10$3501280a@phx.gbl>, "Alicia Contreras" <anonymous@discussions.microsoft.com> wrote: > Please help me enter data into cells that seem to be > locked. Hi Alicia, try: Tools > Protect > Unprotect Hope this helps! ...

Sorting Data in a column
I am trying to extract data that is in a single column to split it into 3 columns. The data is cyclic and has 3 variables, a time, a data point and a random number. These simply run abcabcabcabc down the column and i would like to get all of the a's into a column, all of the b's into another column and all of the c's into a third column. any ideas? VBA? Sub Test() Dim iLastRow As Long Dim i As Long iLastRow = Cells(Rows.Count, "A").End(xlUp).Row If iLastRow Mod 3 <> 1 Then iLastRow = iLastRow - 1 If iLastRow Mod 3 <> 1 Then iLastRow = iLa...

Parse(?) data from text file
I have a large text file that has hundresds (or thousands) of compiled questionairres that I want to convert to a more usable format (excel?). Here is what it looks like: ======================== Name: Joe Jones Address: 123 main comment: varies from blank to 20+ lines may have muliple paragraphs others: 8 or 10 other fields =============================== next questionnaire ====================== A couple of details: the separator line of ====s vary in length, the individual questionnaires are not always identical. Some have a couple of extra 'fields'. I envision a separat...

2 Column Data lookup
Hi, I have data in column A, B and C starting from row number 2. Also, I have some data in column P and Q starting from row number 2. The data in A and B TOGETHER constitute a Unique ID. Similarly data in P and Q together constitute a Unique ID. Now based on the data in P and Q I want to look up A and B and return value from C in column R. As of now, I use an inefficient way of building up a helper column in D (D2 = A2 & B2) and S (S2 = P2 and Q2). Then in R2 I write the formula, = =INDEX($C$2:$D$1000,MATCH(S2,$D$2:$D$1000,0),1) Is there a better way of accomplishing the above (an ar...

Pb with Data validation based on named list
Hello, I create a Name as Test = {"A" , "B"} (not a range but a list of datas) by the menu 'Insert" / "Name" / "define" Then i cant'use that name "Test" in the Data validation Combo box by the menu "Datas" / "Validation" / "Option" / "Autorize" (List) The error message is that system does'nt accept in "Source" = Test Where is the Probleme thanks for your help Gilles PROVOST Hi Gilles You don't need the named range. In Data Validation>List>Source>A,B No need ...

Vertical Gridlines & Data Marker
Firstly, I noticed that a vertical gridlines of the chart are not align with the gridlines of the data tables. I am wondering how it can be aligned. Secondly, I also noticed that a marker is located on the leftside virtical gridlines of X scales. I am also wondering how to place it on the center. Hi Gary, In my version of Excel they are. Try it with a line chart. In Excel 2007 you might have to make an adjustment. We need more info. With a data table the markers are placed between the vertical gridlines, if you don't like that you can remove the data table and then format th...

Using string data to create charts?
For my class project, our group ended up doing surveys. We collecte hundreds of them and then I manually entered the data into an acces database. I exported the database table as an excel worksheet so that I coul make charts. The problem is that all the data is in string format, and excel doesn' seem to want to make charts using that. For example, we have question that is multiple choice and there are 5 answers, each of whic is a different word. What I am trying to get Excel to do is where I select the column tha the different answers are in and have it count up all the same answer ...

Data Validation in Shared Workbook
I set up a shared workbook that included some data validation. Now I need to add an additional valid value but when I go to Tools, Share Workbook, Editing I cannot turn off "Allow changes....) so that I can change the validation. It is OK if I lose the change history up to this point. Any ideas why this option is disabled? Thanks! -- susieqhersh ------------------------------------------------------------------------ susieqhersh's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26887 View this thread: http://www.excelforum.com/showthread.php?threadid=4...

Getting Excel Data from One Sheet to Another....
Hey Guys, I have the following Excel problem at work and I am not sure how to solve it. Here is the low down: Excel Sheet #1 Data (First line is the header - [Person and Job]) Person Job --------------------------------------- Fred ? Fred ? Sam ? Kevin ? Kevin ? Julie ? Excel Sheet #2 Data (First line is the Header - [Person and Job]) Person Job --------------------------------------- Fred Mop Boy Julie Hostess Sam Burger Man Kevin Manager Now here is the situation that I have. Based on the how the "Person" Column corresponds to the "Job" Column in Exce...

Data from DialogBox to MainFrame
Hi, I have a CDialogBox class, which collects some information (Cstrings and ints), and stores them in internal variales. I would like to pass that information to the MainFrame class. how can i do that? I'm using Visual Stuido 6.0. SDI. thanks in advance Martin wrote: > Hi, I have a CDialogBox class, which collects some information > (Cstrings and ints), and stores them in internal variales. I would like > to pass that information to the MainFrame class. how can i do that? > I'm using Visual Stuido 6.0. SDI. > thanks in advance > Martin: Is this a modal or mod...

Data validation does not seem to work with copy/paste
I have set up some data validation for each cell within a range. When manually enter invalid data in one of those cells, the data validatio works and an error message pops up. When I copy from one cell wit data to another cell, where the data validation results in false, i allows me to paste the value with no error message. Is there any wa to fix this -- LA ----------------------------------------------------------------------- LAF's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=965 View this thread: http://www.excelforum.com/showthread.php?threadid=46802 ...

vba code for excel to extract data from txt file
USING Excel 2000. I have a text file that when viewed in excel lists the entire row of data in one cell. I cannot parse data because each line does not have the same break. I want to extract the fields into individual cells. I will need to define "what" I am looking for. Is there sample vba code for excel I can reference to learn how this may be done? sample report REF #:A1B CUSIP:12345678 TD:1/1/00 SYMBOL:ABC QTY: 1 SD:01/03/00 ACME COMPANY PRICE: 9.101 MKT:OTC want to extract REF# TD ...