Locking data #2
Is there any way that once a user has clicked a button or entered data into
a cell it is locked in an equivalent cell? For example
in Cell B1 formula =A1
in Cell A1 = 5
If the 5 becomes 6 then so will B1. But is there anyway, that by using a
formula or short onClick code I can make it so that B1 remains 5 even if A1
...Transmitting Outlook data to a web server
I am looking for a solution on how to publish data in Outlook to a web
server. A custom web app will be written to access the data published
to its server and and display it in some special way. I will either
need to write custom VBA for Outlook that transmits the data to the
web server or use some third-party tool that integrates into Outlook
that will transmit the data for me. The data is sent in only one
direction - from client to server. The data on the server is read-
only. Whenever the user changes data in Outlook, either it gets sent
to the server automatically (the preferred wa...Table-data transformation
I would like to take data from 3 different columns of data and recombine to a
different format in another column.
The original data is a series of numerical and text codes.
first column, second column, third column
I would like the new column to contain the data in this form:
Can this transformation be automated? Can I set up a form to just collect
the individual numbers and make the table transform them to this new form and
unique identifier (key) ??? Or perhaps the form transforms and puts the data
in the table. I need the data in both formats and don't wan...Merging Excel Data into Word
I use Word and Excel XP and when we merge dates from an Excel doc into Word,
it puts the date in an American format for some reason even though the
formatting is Australian. Regional settings are set to Australian.
I have managed to edit the field in Word to change the date but was hoping
that someone would know why it is behaving like this so I can stop it from
We also have problems with some of the forumlas. For example, we might use
the currency formula which has two decimal places (ie. $23.09) but it comes
into Word like 23.0258. Any ideas why this is happening?
...exclude certain data
I have a series of data in rows which are plotted on a simple line chart.
Sometimes I want to exclude a particular data row from appearing on the chart
by typing X in a column (I currently use this to exclude that row of data
from average & mean calculations, which I also plot on the same chart)
Also, I have upto 30 rows of data printed on one chart - is it possible to
scroll the the dataset & highlight the chart line that the data belongs to. I
do not have labels because it makes the charts too crowded I'm sure I've seen
this somewhere but can't find it again
Ma...How to paste data to alternating cells down a column?
I am copying data from a column in one sheet where the entries run concurent
down the column. When I paste to the new sheet I need to paste the
information in every other cell down the column. What is the best way to do
this, I have 3600 entries copied in groups of 25 to 72 different sheets, each
sheet holds 50 entries?
One extraction technique which should serve you well ..
Assume you have source data in Sheet1, running in A2 down
In another sheet,
In any starting cell, say in B2:
=IF(MOD(ROWS($1:1)-1,2)=1,"",OFFSET(Sheet1!$A$2,INT((ROWS($1:1)-1)/2),MOD(ROWS($1:1)-1,...word to excel data transfer help
I have a word document that i need to export to excel. The data is addresses
and a when i paste it into excel it fills up more than one row. Is there any
way of controlling the data such that i can fill up the data in each row.
Eg: Certificate has no expiry date listed. Have to check with SGS at their
Spoke to Frank McDonald on 2004.12.14. They have not migrated QA program
from ISO 1994 to ISO 2000 and their cert has lapsed therefore no longer
registered. They continue to follow ISO 1994 until they update to 2000.
This text in...How do I copying data from a cell on sheet to a diff cell/sheet
It data entry of scores on worksheet one that has to be automatically copied
to worksheet 2. Once I entry the data on wksht 1 want it placed on wksht 2.
I run tournaments, need all of the date on worksheet 1 but only some on
worksheet 2 so I can sort it. When I set up my wksht 2 us the formula
=wksht1!C4 on the first line. the on the second line input =wksht1!C11
then highlight the two and drag it down. It will copied what i inputed but
won't calculte and change the cell referrence by 7 how do I get it to do that
without having to manually change the number?
To get ...Pivot Tables
I have a new computer and previously I was able to use
Pivot tables as a shortcut to highlight a list of say 500
items and display the unique items in a pivot table.
However when I try to do that now it doesn't display the
items, it only show the dropdown with the unique items
checked or unchecked and therefore I cannot highlight the
unique items to create my unique items list. Does anyone
know if there is an option that is preventing me from
doing this or any other way to create a unique items list
from a larger list. Thank you very much.
If you create a pivot table with a fi...Data amalgamation
I have a table of data, including columns for date, a code indicatin
data source, and various analysis under headings.
Date Source A B C
1/1/01 X 2 4 8
15/3/01 X 3 5 7
16/6/02 Y 12 1 9
I want a summary table that is driven by a (variable) date range
amalgamating data by source and A,B,C.
X Y Z
- A 5 0 0
- B 9 0 0
- C 15 0 0
- A ...whole lines are disappearing before I finish entering data
When using the "find" option I can see the text is still there, but I've lost
whole lines while entering data in Excel and now the lines are numbered 1, 2,
3, 6, 7 etcl. There are 3 lines missing. How do I get the back? And why
are they disappearing?
Maybe your worksheet is filtered (hiding some rows, showing others):
Or maybe you just have hidden rows (manually hidden).
Ctrl-a (twice in xl2003)
> When using the "find" option I can see the text is still there, but I've lost
> whole lines wh...move data
How do I rapidly move data from cells A1 - A5 to A1-F1? I did this a couple years ago and thought is was in paste special but no luck this time.
I think you want
copy|paste special|check transpose.
but the "from" range can't overlap the "to" range.
maybe paste somewhere else first and then move it (two steps, now).
> How do I rapidly move data from cells A1 - A5 to A1-F1? I did this a couple years ago and thought is was in paste special but no luck this time.
Thanks Dave, its the can't overlap that was...Named-range source-data for pie charts on copied worksheets
I have to finally concede that I'm stuck and have to ask for advice. I
am using Excel 2000 and have been able to use Andy Pope's help on
"Automatic removal of zero values in pie chart". That works fine. But
if I copy the worksheet, the pie chart on the copied (new) worksheet
references the named range as defined on the original worksheet.
My named ranges, which the pie chart references, are:
So, one solution might be to define the same named range on dif...FROM address with multiple accounts wrong
I have the following email accounts setup in Outlook:
firstname.lastname@example.org (set as default account)
Everything is POP/SMTP. I select different accounts to send. Here is the
If I send an email to anyone it always goes out as coming from
email@example.com , regardless of what email I chose to send from. (yes, I've
checked the email settings in Outlook, all email addresses are correct--I
even tried setting a reply address as well--no joy). So all my replies come
back to firstname.lastname@example.org. Weird thing is--I can only get the FROM address
to sh...copy a workbook without copying any data
I there a way to copy a workbook without copying any data. I would like to
copy all tabs,micros,links and formulas without any data in the cells or
notes for the cells being copied.
Dim sh As Worksheet
Dim strName As String
strName = "ABCD.xls" '<<==== CHANGE
Workbooks.Open Filename:= _
Application.DefaultFilePath & "\" & strName
For Each sh In Workbooks(strName).Worksheets
On Error Resume Next
sh.Cells.SpecialCells(x...multiple Archive Folders in file list
Outlook 2002: I suddenly have an additional archive
folder in the file list. Not Archive1 or some variation,
but two separate Archive folders. And I can't delete the
new one. If I click on it, the cursor automatically
jumps to the original Archive folder (the good one). But
I can click on the subfolders and even delete some of the
What can I do to get rid of it?
Do you see the extra archive.pst listed if you go into File | Data File
Management? Can you remove it from there?
MVP - Outlook
*** Messages sent to my e-mail address will NOT be answere...tricky data entry question
I need to limit a cell's entries to numbers, commas and dashes, so
entries such as 1,2,3,4-10,17 could be entered (these are just
examples, the actual figures can go up to 999999).
The tricky part is that I would also like to only allow an entry in
this cell if another cell on the sheet is not empty.
An example to summarise: I want to be able to say "allow an entry in
this cell if cell A1 is not empty, and only allow the characters to be
numbers, dashes or commas."
Of course it may not be data validation that I need, (maybe a
combination of number formatting and data vlidati...Log data in a shared workbook
Is it possible to have a spreadsheet which logs data from anothe
without over writing each other's data, even though several colleague
are inputting and saving in this shared sheet at different times.
Sheet 1 has various data
Sheet 2 - A1,2,3, etc = first save
Sheet 3 - B1,2,3, etc = second save
...for the day
Message posted from http://www.ExcelForum.com
Would you consider writing to a CSV file? You could use VBA's text file
functions to write directly to the file, but the file would still open in
Excel. One advantage would be that...Code to look at range and extract data.
If the column of data has the text "Back On" I want to copy the adjacent
columns to another sheet for each instance. This will be a loop since this
text occurs more than once.
If I understand you correct ?
Regards Ron de Bruin
"JDJacobs" <JDJacobs@discussions.microsoft.com> wrote in message news:5B3B0D6A-CE19-426B-BBB6-F68B9AD6C2DB@microsoft.com...
> If the column of data has the text "Back On" I want to copy the adjacent
> columns to a...Trouble applying data set to other shapes #2
I posted this earlier, but it may not have been sent. So I am sending
I have put together a data set for one of the objects in my Visio 2007
Professional drawing. For simplicity, let's say that the shape is a circle.
I then want to apply the same data fields to another shape that's
already on my drawing. Let's say that this other shape, that does not
yet have a data set attached to it, is a square.
So here is what I am doing, but apparently I am making a mistake somewhere:
I click on the circle and look in the Shape Data Sets window, and I see
the name...Basic data filtering in Excel 97
Okay, what I need is pretty basic. I have a spreadsheet with 6 columns.
The first column features keywords. Data related to that keyword is
contained within the cells to its right.
I need to know how I can filter the keywords based on criteria I
specify. Basically I would tell it to display keywords and their data
that contain the word -cell phone- (for example) and it would hide all
the other data not containing the world -cell phone-.
Seems like a pretty basic feature but I know almost nothing about
Thanks in advance. :)
~~ Mes...How do I create a rent balance sheet for multiple units
...Special character in Input Message
I'm building a message in the "Input Message" tab of the "Data Validation"
Manually, I can add a special character that is a large black triangle
pointing to the right like a bullet. However, I can't seem to produce this
character using code.
Can someone please post an example where I can insert a special character
...How do i have a check display with any data entry in a cell
I am creating a simple spreadsheet for teachers and want to have only a check
mark displayed regardless of what they type into a cell.
Insert the check mark symbol you want from the Insert-Symbol menus int
a reference cell for your formula. Then your formula in B2 would be.
A2 is where the data is entered by the teachers, $H$2 is where yo
inserted the check mark symbol for your reference. You can then dra
this down for each row of data.
SteveG's Profile: ...Question about data in SMTP header
Does anyone know what the message below means?
X-OriginalArrivalTime: 16 Dec 2005 18:53:28.0827 (UTC)
On Mon, 19 Dec 2005 08:34:03 -0800, Mike C
>Does anyone know what the message below means?
>X-OriginalArrivalTime: 16 Dec 2005 18:53:28.0827 (UTC)
What's to know?
The field is explained here:
and the only other part of that is the UTC thing, by which they really