Parsing data from one spreadsheet into another format
The data that we dump out of one machine comes in like below.
%AT_1300 Bottoms|Conductivity| (Water Out) InputRange VDC1to5
%AT_1300 Bottoms|Conductivity| (Water Out) Custom_Range_Low 0.0
%AT_1300 Bottoms|Conductivity| (Water Out) Custom_Range_Hi 0.0
%AT_1300 Bottoms|Conductivity| (Water Out) MinScale 0.0
%AT_1300 Bottoms|Conductivity| (Water Out) MaxScale 20.0
%AT_1300 Bottoms|Conductivity| (Water Out) EngUnits mhos
%AT_1300 Bottoms|Conductivity| (Water Out) StepResponseTime 1.0
%AT_1300 Bottoms|Conductivity| (Water Out) DigFiltTimeCnst 0.016
And I need to convert this data to this f...data input in text box
We have a form which the operator enters data in a text box. Currently we
have a 'done' button on the form that the operator clicks to send the text
box info to a vba program. How can we send the text box info to the vba
program when the operator hits the enter key @ the end of the data entry for
the text box? TIA
In Christ's matchless name
ted & colleen
Use the control's AfterUpdate event.
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"ted" <n6trf@arr...Transferring over outlook data to new XP machine
How do I transfer over my old emails, address book to my
new XP machine? I have looked over the internet and found
nothing the tells me EXACTLY how to do this, any help
would be greatly appreciated.
If your using MS Outlook copy your .PST file across and import it into the new install.
>If your using MS Outlook copy your .PST file across and import it into the
No, don't import it. Simply use "File">"Open"
3290 Patterson Ave. SE, MS 1B3
Grand Rapids, MI 49512-1991
Brian.Tillman is the nam...Copy entire row where CellValue=0
I need to loop through the collumn and search for value that is more then 0.
When I find it I need to copy whole row and paste it 2-3 rows below the
table. I tried to select the collumn and search the selection but for some
reason I copy and paste only one row.
Thank you for any help.
as a starting point:
"OxanaB" <OxanaB@discussions.microsoft.com> schrieb im Newsbeitrag
> I need to loop through the collumn and search for value tha...Can I send a recurring e-mail automatically each week
I want to send a e-mail with the same verbiage to the same person once a week
and make it a recurrence with no end date. Can I set this up once in Outlook
so it is scheduled automatically?
Microsoft Office 2003 Version
Students and Teachers Edition
Windows Vista Home Premium
Happy new Year!!
...Lookup based on criteria in 2 columns
I am trying to use a vlookup or other function to return the value in the
amount column based on the location and date. Here is a sample of my data:
Location Date Amount
101 9/15/8 10
101 9/16/8 20
101 9/17/8 15
102 9/15/8 50
102 9/16/8 75
102 9/17/8 67
For example if I wanted to return the amount for location 102 on 9/15/8,
what formula would I use? I tried using variations of vlookups but had no
Peo Sjo...Counting number of X's in a column
I need to sum up the number of "Xs" in a column. I would be extremely
grateful if someone could help me with the formula. I cannot seem to get one
to work. We are using Excel 2003.
Environmental Education Association of Washington
(remove nothere from the email address if mailing direct)
"Susie Harris" <SusieHarris@discussions.microsoft.com> wrote in message
> I need to sum up the number of "Xs" in a col...MS Money 95 data files
I hope that some one can answer this for me.
I have used MS Money 95 for years, and it works just fine for me on Windows
XP, however, I now have to reformat my hard drive, and have discovered that
I can nolonger find my original install disk. Will the latest versions of
Money still read the MS Money 95 data files. All that I have ever used the
program for is to track my investments, and am unlikely to do any different
in the future.
In microsoft.public.money, Stan Banner wrote:
>I hope that some one can answer this for me.
>I have used MS Money 95 for years, and...Exchange 2003 new install can not receive external email.
I have just setup a new Windows Server 2003 standard edition with
Exchange 2003 standard edition on it. I have been working for a while
trying to get it to receive external email. I can send out and send/
receive internal messages, but when someone trys to send me a message
from outside our network they get the following returned mail message
This Message was undeliverable due to the following reason:
Each of the following recipients was rejected by a remote mail
The reasons given by the server are included to help you determine
each recipient was rejected.
Recipient: <**...HELP! Need to export hourly sales data on POS (NOT RMS)
How can I export hourly sales data across a date range? For instance, I
want to show hourly sales for the month of October so I can graph it and
post it in our break room.
If I can't export hourly data, can I export daily sales?
The built-in reports don't address this data format.
This is a multi-part message in MIME format.
Mark, This should work for you. Keep in mind it takes up to 5-10 minutes to
load...can't customize toolbar
Operating System: Mac OS X 10.5 (Leopard)
all i see is document elements, quick tables, charts and smartart graphics. i do not see the main menu or the toolbar button. when i attempt to customize the toolbar, the to menu bar and format bar do not appear where they should. on a website i visited, they advised that i drag and drop the temporary toolbar into the real toolbar. but i can't drag and drop the toolbar. i can only move the temporary toolbar. how do i add the menu bar and format bar for go?
You may have hidden the toolbar by accident. Click on the ti...How can I change 'Normal' Style for Word e-mails to 'Normal (Web)'?
Hi, I'm using Word as my e-mail editor in Outlook 2003 and want to change
the default Style for e-mails from 'Normal' to 'Normal (Web)'.
The problem is that new e-mails and replies in HTML format use the 'Normal'
Microsoft Word 'Style', and this has no gap after paragraphs. The upshot of
this is that when sending an e-mail, I have to press return twice to create
a gap, but when the recipient views this, their software shows it as four
gaps (the extra carriage return I typed + their correctly viewed HTML
carriage return after each line).
E.g. I type this:
...Sorting Data #5
Is there formula or anyway to be able sort the below data into a format that
I could create a pivot table on? I spend to many hours doing this every month.
Invoice #: 12345 Invoice Date: 1/16/1950 A/P Code: ABC
Due Date: 1/16/1950 Total Payable: $100.00 Reference: Freight:
Account #: 1234 Description: Name Reference 1 Amount: $100.00
Account #: 4321 Description: Name Reference 2 Amount: $100.00
Account #: 9876 Description: Name Reference 3 Amount: $100.00
Any help would be much appreciated!!
You need to show a Before and After version.
You still might not get any help, but your ...HELP! remote data not accessible msg
I have a use who is currently using a Bloomberg DDE add-
in. Whenever he attempts to activate the add-in to
retreive remote data, the system hangs. If I go to task
manager, I then see a message stating "Remote data not
accessible. To access this data Excel needs to open
another program.... I have searched the knowledge base
and didn't find much help. Does anyone have any ideas? I
am desperate!!!! We are currently using Excel 2003 in XP
...Can you only merge up to a certain number of cells
I am working on microsoft excel 2003, I have a sheet that I merged cells
starting with line 8 through 43...when I type my information in the merged
area I can see all that I am typing...say it goes up to line 30 once I hit
the enter key I can only see up to line 20. Even when I print it out it only
prints up to line 20...I have checked to make sure there are not locked cells
etc. I cannot figure out at all why this is happening...is there only up to
a certain number of cells you can merge?
From "Excel Specifications and Limits"
Length of cell contents (text) ...Can I make messages unable to be forwarded by the receiver?
We are interested in setting up a private email group at work that receives
Is there a way to make the emails that these users will receive unable to be
forwarded to people outside of the group? Make private, or somehow else
prevent the information from getting outside of the approved recipient list?
no. and you can't keep people from printing it, copying and pasting the
contents of it, taking a screen shot of it, etc, etc...
"Jonna Kosalko" wrote:
> We are interested in setting up a private email group at work that receives
...Can anyone help ?
I have created a holiday planner for staff with in are company
and i need a formula that gives us only 10% of the total number of staff are
off on holiday.
would be greatful if anyone could help.
Hello - If you have a total somewhere (I would suggest inserting a column on
your spreadsheet titled Total and then entering a "1" if the person is going
to be out, then total the column of "1"s by entering "=SUM(x:y)" where
x=first cell in the range, and y=last cell in the range), in a different
cell, enter "=.1*z" where z equals the total of people out...How do I merge cells with multiple data values?
I've tried highlighting the two cells which are in the same row. It
suggested that I format and align. Both of which I've tried. I keep getting
the same error message, "The selection contains multiple data values. Merging
into one cell will keep the upper-most data only." I need to make the cells
one with all my information. Is this possible?
Not knowing what you want to do, let me make a suggestion. Put all your
data into the first cell and leave the second cell empty. Select both
cells. Click on Format - Cells - Alignment tab. In the "Horizontal" b...[b]Can I download Excel data to a MS Access database?[/b]
I've built an Excel 2002 form that I want our internal customers to
access from our intranet, and use. Once completed, they will send it
to us as an e-mail attachment. I'd like to be able to open it, and
somehow download the data from the form into an MS Access 2002
database I've built (so that we don't have to rekey it into the
Is this possible or even feasible? Any and all help is appreciated.
Message sent via www.excelforums.com
in Access check 'File - Import External data'
"...How do I copy data in single cell format to a merged cell format
I need to copy a list of data in single cell format into a spreadsheet where
those same columns are merged cells (with four cells merged into one).
I have several hundred lines of data so some way of copy & paste (other than
each cell individually) would be appreciated.
What I would do is copy format of sheet with merge cells to blank sheet then
copy single cell data to sheet with merge cells select single cell to paste
you lose formatting so after just copy format from blank sheet created earlier
I find this easiest way
Hope this helps
"Paul" w...Why can't I edit the Schema for a Knowledge Base Article in CRM 3.
Why can't I edit the Schema for a Knowledge Base Article? It seems to me
that you could do this in 1.2. I just want to add some custom fields.
...How can I set an alarm Excel?
I would like to set an audible alarm in Excel based on a cell value.
Try this in the worksheet VBA editor. If the value of A5 is greater than 50
you get a beep.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim frequency As Long
Dim duration As Long
If Target <> Range("A5") Then Exit Sub
If Target.Value > 50 Then
frequency = 4160
duration = 1500
Call Beep(frequency, duration)
"Annell" <Annell@discussions.microsoft.com> wrote in message
news:EFE8AA18-3F14-4A92-941D-053922417AB2@mic...Can't view messages with Autopreview
My current view is set to preview all items, however, my
mail is not displayed in autopreview
...can't add groups to public folders
I'm having a problem with my public folders - I can't add groups to them. I
used to be able to, and now the members in a given group are unable to
access that particular public folder.
I can add individual users fine, but not groups.
Anyone know how to fix this?
Do you have sufficient rights in AD? What I am getting at, is that you need
rights to change a group type to security.
MVP for Exchange Server
"Glenn" <firstname.lastname@example.org> wrote in message
> I&...Sum column values that contains text &/or dates
Column D3 thru D43 contain a mixture of values & dates. For example:
D3 = 16,026.76
D4 = 11-18-05
D5 = blank
D6 = 6,855.34
D8 = blank
D9 = 5,270.00
D10 = 11-02-05
Need sum to equal 28,152.10 (total only values from entry or formulas)
Thanks so much. mikeburg
mikeburg's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24581
View this thread: http://www.excelforum.com/showthread.php?threadid=489114
If your dates are text strings which say "11-18-05"...