Only two columns allowed to enter data?
Hi, is it possible to have only two columns, say, Column B & E in a
worksheet to allow user entering data?
How can I do that?
format those cells as unlocked (make sure the rest are locked), and the
turn on worksheet protection (tools, protection
duane's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1162
View this thread: http://www.excelforum.com/showthread.php?threadid=27595
By default all cells are "locked" when sheet is protected.
Select columns ...Find the last, 2nd last and 3rd last data in a column
I have data listed in several colums and need to create a formula to
detail the last (most recent) 2nd last and 3rd last piece of data in
I have used the following formula to display the last but cant edit
this or create another formula to get the 2nd and 3rd last pieces of
Thanks in advance
If there are no empty cells in the range:
last cell: =INDEX(A:A,COUNTA(A:A))
Bernard V Liengme
Microsoft Excel MVP
r...Formating text columns layout with page breaks in Excel 97
I was wondering if there is a way to link columns, so once the page break is
reached that Excel will automatically continue a list in a designated column
to the right?
I am trying to create a multi-paged checklist of DVD titles. The sheet is
mostly text based, created in Excel 97. The eventual goal is to use this
checklist as a template to catalog all other types of media too (CDs, video
The spreadsheet is 4 Columns across (A to D) and each page in the
spreadsheet is 30 rows in length. Columns 'A' and 'C' will have check-boxes;
Columns 'B' and ...Merger Two Data Sheet
I need to merge two variables but I could not find any instructions on this
I have a data sheet 1 like this:
I have data sheet 2 like:
Data sheet 1 and data sheet 2 have the same variable Course. Course contains
much more records in data sheet 2 and all records of Course in data sheet 1
are incl...How can I display worksheet summary page ie title/size/last updat.
I'm running MSExcel 2003.
I am often working with large workbooks with mutiple worksheets. It would be
v helpful if I could see/sort and print off a summary that shows worksheet
properties similar to Explorer eg:
worksheet last update size
names 1/2/04 64k
companies: 5/2/03 893k
I wrote this sometime ago and it works as a workbook_open event (Needs to be
placed in the ThisWorkbook code module). It could be adapted to work
otherwise though. It adds a sheet and lists all the built-in and c...Adding data (autoincrement) into a xml file with the help of a dataset
I have a strange problem with my xml file. In the schema of this xml
file I have set one column to autoincrement. When I enter the data in
my xml file directly, the autoincrement-column gets its correct
Now I want to add new data with the help of a dataset. I use the
following lines of code:
Dim ds_functions As New DataSet
Dim drCurrent As DataRow
drCurrent = ds_functions.Tables(0).NewRow
drCurrent(1) = Me.txt_bla.Text
Dim sw As System.IO.StreamWriter = New
System.IO.StreamWriter("Test.x...How long will my capital last
If I had a capital sum of say �100,000 and I was taking an annua
income of 5% and I was getting 3.5% interest annually - Can you help m
demonstrate how long my capital last?
Message posted from http://www.ExcelForum.com
If, by 5%, you mean 5% of the original investment (=A35.000 each year), =
your money will last for approximately 35 years at 3.5% interest.
See Excel Help for more info on NPER().
"Durhamr" <Durhamr.email@example.com> skrev i meddelandet =
news:Durhamr.yajun@excelf...Select all chart data points
I have made a graph in Excel 97, but I cannot select all data points on
the graph. When I click on a data point only every other point (or so)
I have deleted the graph and re-entered the data, still no good!
If I make a quick temorary graph by opening excel from scratch in a new
window this seems to work (click on a point and they all highlight).
Is there a default setting somewhere!?
What is it you want to do with the series once you select it?
"CL" <firstname.lastname@example.org> wrote in message
news:email@example.com...how do I make a graph with one very large piece of data
I am trying to make a graph in Excel with mostly small numbers for data, but
with one large number. The graph does not display well. Is there a way to
break up that large number so that the small numbers show up too.
There is no really "good" way
Some suggestions are
1) Put football on a secondary axis
2) Use a log scale
3) Set the maximum y scale value to a small number (5, say) and add a text
box to state that football is 59
I favour #3
Bernard V Liengme
remove caps from email
"...Multi-select listbox question
I have a multi-select listbox and wish to obtain data from the last clicked
record in the listbox (you'll notice that if you make multiple selections
then only the last-clicked record has a dotted line around it). What, if
any, listbox property identifies this record as last-clicked?
Posted via a free Usenet account from http://www.teranews.com
...Graphic Visualization of an ORACLE data on EXCEL
I am a new on EXCEL.
I am using an Excel to display the data from an Oracle database.
I am using several excel sheets in order to display various data from
an Oracle database.
For example: sheet one for displaying the oracle users information,
sheet two for displaying oracle files information etc.
I am using the following query for displaying the data in one of an
select username, ''''||sid||','||serial#||''''
sid_serial,status,module, OSUSER "Workstations",MACHINE
Is there a way to map column number to alphabet such column 6 equates to "F"
and column equates to AA.
Not really sure what you want here but perhaps the following will help. The
first 2 return the column number from the alpha id and the second 2 return
the column alpha id from the column number. Returning the Address (alpha id)
the parameters indicate whether to return absolute or relative. ,0 is
relative and 1 (or no parameter) returns absolute.
MsgBox ...Importing Selected Source Book Data
I have a large source worksheet containing data in various columns. When a
value is indicated in the "qty" column of the source book, I need the entire
row of information to display and list in a second worksheet. How do I
display only the selected information in the second worksheet?
Personally, I'd keep the data in one location.
You could apply Data|Filter|Autofilter, then filter on greater than 0 to show
the values that you want.
If you really want this stuff on another worksheet, you could copy those visible
rows and paste into a new worksheet.
...why is my last digit converted to zero?
I'm using Excel 2003 and when I enter a 16-digit number or cut and paste a
16-digit number, the last digit is converted to zero. This does not happen
with 15 digits or fewer.
Excel's numeric precision is 15 decimal digits.
If you need to calculate with the number, you probably won't miss anything.
If the number is a key, such as a creditcard number, add an apostroph
(single quote, " `") before it; it will not show, but it will cause the
number to be treated as text.
Another way is to format the cell as text before entering the number
...Userform to enter data on worksheet
I am new to VBA and userforms so I would greatly appreciate any help.
First row in my sheet contains names of months: Jan 2008 forecast, Jan
2008 actual, Feb 2008 forecast, Feb 2008 actuals and so on...
Second row contains inflows, third outflows. There are some figures in
the forecasted months. I need to create userform to enter actual
values of inflows and outflows. Userform would have one combo box to
choose appropriate month (on the base of first row) and two textboxes
for inflows and outflows, a submit button and cancel button.
Again any help would be appreciated.
Is ther...'no data found' in 28MB pst file?
I used a utility to repair a suspected bad pst file and that was the
results, 'no data found'. Is this possible?
Yes, this is possible since "white spaces" exist in a pst-file. Can you
still open the original file? If so; create a new pst-file and copy the
available data into the newly created pst-file.
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-Backup and Restore
-Create an Office XP CD slipstreamed with Service Pack 3
"Frank" <firstname.lastname@example.org> wrote in message
>I ...Plotting data across columns
I'm pretty sure there is a way to custom define this but I'm very confused.
I need to plot based on the following criteria and so far it looks like this:
s/n | control s/n | metering taper 1 | metering taper 2 | metering edge
break 1 | meb2 | [drain edge taper and break 1 and 2 also]
But eventually I'm going to have to take averages and then attempt to plot
out. I'm going to need to make 4 graphs as seen here, metering taper and
metering edgebreaks as well as the drain edges. Eventually I may need to add
more to metering tapers (like a 3rd or 4th catagory) If t...How do I convert some data in the row to columns?
I have an issue that I need to resolve.
I'm currently getting data in a row format, but I need to convert some
of the data into columns, for importing into Access.
Item Description Jan 05 Feb 05 Mar 05 Apr 05
ABC123 Widget A 100 250 175 210
XYZ123 Widget B 50 75 100 76
To convert to........
Column1 Column2 Column3 Column4
Item Description Date Qty
ABC123 Widget A Jan 05 100
ABC123 Widget A ...Can one correlate data betw/sheets ?
I'm new to this group as well. I'm on Excel 2003, Win XP Pro and I'm
fairly familiar with the excel interface, but probably still a newbie.
I'm doing a running balance, like a checkbook, with deposits and
withdrawals etc. I've set that up fine, but I'd like to be able to correlate
and continue data between sheets because I've set the worksheet up to have 8
sheets within it (if I'm using the wrong terminology, this is one (1) excel
worksheet file with 8 sheets within it - that's 8 sheet tabs at the bottom).
In specifics, I'd like to ha...Trying to find the fourth blank cell in a column
I'm trying to find th fourth blank cell in a column and select a range based
on it. Should be simple but for some reason I can't makeit work. Anyone tell
me what I'm doing wrong? I'd be most grateful.
For background, I have some data followed by two blank cells, followed by
more data, folowed by a blank cell, followed by more data followed by
another blank cell, followed by more data followed by blank cells to the
end. It's the start of these final blanks I'm trying to find
Problem is that after firstqun,the rest of the variables show as ...Last logged on by
Using exchange 2003.
When I look under Adminstrative groups -> Server -> "name" -> First storage
group -> mailbox store -> mailboxes you can se all the mailboxes that
you have and last logged on by. Under last logged on by I can se that one
person (me) have logged on on to diffrent acconts, even if I havent don it.
WHAT is this?
Did you use your account as the service account for anti-virus or spam?
Also, IIRC, even if you view someone's Outlook Calendar, it would mark the
mailbox as being logged on by you.
Regards...Pivor Table Data Field
This is a multi-part message in MIME format.
I have tried to "show" a data field after using "hide" in field =
settings. How can I make this reappear? Not using Field drop down =
option. The fields orgin is from the excel list and not a calculated =
<!DOCTYPE HTML PUBLIC ...Combining data
I'm sure there is a formula out there to do this, but I'm not finding any
help in the help function in excel.
I have one worksheet for each day of the month with data. I'm looking to
take the data from each of those sheets and dump it all into one "summary
sheet" instead of having to copy and paste each day (I'm not looking to
summarize any of it). If a new sheet is added, I would like to have the data
added to the bottom of the "summary sheet"
Any suggestions as to how to do this?
Ron has a macro to do that look into
http://www.r...Display index of column headers in column A
A worksheet has data organized in columns that will be used to create
drop-down lists. How can I display in column A the contents in the column
headers - i.e. row A contents (which are the titles of each list) so that I
can see the names of all the column headers without having to scroll across
Note that there are empty columns which will be filled with new lists that
will be added at later times, so the formula should ignore columns that have
not header (blank A column) and return column headers that contain text, but
without creating blank cells in column A that ...Data Labels on Clustered Column w/ 3D Visual effect #2
Clustered Columns can have Alignment as "Inside End"
This doesn't seem possible with 3D Visual effect
Is there a way to resolve this?
Yes, use 2D charts. They provide a better representation of the values
being plotted without the implied false third dimension.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
> Clustered Columns can have Alignment as "Inside End"
> This doesn't seem possible with 3D Visual effect
> Is there a way to ...