Replicate column info 01-25-08
Hi- I had a question earlier about replicating columns for a project I'm
doing. There is one column that has the info being pulled from a form.
Another column in the same table needs to pull in the same information. In
excel you would use the equals sign to pull the same info. How would you do
that in access?
Thanks in advance
You would never do this in a relational database. If you want to see the
column twice on a form or report, just bind a second control to the same
In the case of a query, you would never do this unless you were creating a
query that was to be used t...Combined charts
"How do I change the format of a data series in a chart from a line to a column?"
On Fri, 7 Nov 2003 06:26:10 -0800, Kurt Bonner =
> "How do I change the format of a data series in a chart from a line to=
Select the data series by clicking on it. On the menu, click Chart | =
Chart type | select a column chart. If you do this as instructed (i.e. =
with the data series selected), only the selected data series will =
change. The other data series will remain as before.
dvt at psu do...Comparing columns
Can somebody please advise me on how to do the following in Excel:
Compare a set of values (text) in column A with a set of values (text) in
column B (no necessarily in line with each other) and output any differences
to any of the following:
- Column C
- Another worksheet in the same workbook
- a text file
Hi, When you say you want to see the output (wherever it is to go) - what
output are you looking for?
If the data in two columns is to be cross matched, you will possibly end up
with a number of scenarios of matches, non-matches on same row, different
rows and possib...Change Preset Columns
My columns have 1,2,3, etc., how do I change them back to ABC,etc??
Its under Tools, Options, General Tab, uncheck R1C1 reference box.
> My columns have 1,2,3, etc., how do I change them back to ABC,etc??
...Adding A New Column
Operating System: Mac OS X 10.6 (Snow Leopard)
I was emailed a document that is made up of columns and rows. I would like to add one more column and extend the rows into that new column. How do I create that one extra column and extend the rows into it? <br>
It depends on what the "columns & rows" actually are. If it's a Table just
click in the column you want the new one next to then go to Table> Insert>
Column to the Left or Column to the Right. The new column will have the same
number of rows as the other column...Transpose Column With Gaps to Row With No Gaps?
How could I convert, by click and dragging a formula, the following?
It's additionally tricky because the Horizontal format includes an end of
year lable (2004, 2005, etc), but the vertical format does not
Label Cell Reference
Label Cell Reference
Thanks very much in advance.
This will become a forecasting tool for debt, reported interest expense,
accrued interest expense, capitalized interest expense, and cash inter...Labels placed under stacked column chart
I have a stacked column chart where I would like the labels of one of the
series to always be placed under the column. Is there a way to do this
automatically instead of manually moving each label?
A stacked column series has limited options for automatic placement of data
labels. They can be aligned "Center", "Inside End" (just below the top), and
"Inside Base" (just above the bottom). Double click the labels, and on the
Alignment tab, pick the Label Position you want.
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://Pe...Sum to exclude blank row
Hi, I have a problem with trying to implement a summation formula. I have
monthly data in columns (A to L for each month) and rows being the data.
What I'd like to do is sum each month but exclude the value which is in a
row of data that doesn't have a full 12 months of data. So basically I only
want to SUM those sets of data which have a full 12 months.
Is there a way to do this?
Any help greatly appreciated.
Assume your table is in A1:L6,
headers in row1, data in row2 down
Put in M2: =COUNT(A2:L2)
Copy M2 down to M6
Col M will be used as the "crite...CRM 4
Is there a way to prevent a column from being added to advanced find views??
You may change attribute to be non searchable.
Customazation - Customize Entities - e.g. Account - Attributes - e.g.
Account Number - Change value of Searchable to no.
Hope this help you.
> Is there a way to prevent a column from being added to advanced find views??
Thanks for the quick reply Jukka.
However - by changing the 'seachable' attribute to no, doesn't that only
remove it from being available in the filter criteria?? The ...Sorting more than 3 columns of Numeric data.
I have a spreadsheet with six (6) columns of numeric data and would like
to sort if ascending in each row. So the end result would be the lowest
numbers in each row at the top of the spreadsheet. Is this possible?
JMax's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=6305
View this thread: http://www.excelforum.com/showthread.php?threadid=494208
This is an exert from the help on sorting lists with more than 3 columns.
Basically, you need to sort the list twice. If y...How do I number rows automatically?
I want to add an automatic (ie self-changing) numbering column to
worksheet. I would like the left most column to have anumer if th
next column to the right has text, and then add 1 number to that colum
for each subsequent row. An eg:
1. Joe Blow 123 Main st
2. Sara Silver, 221 Green Ave
3. Fred Red, 444 Bloacl Blvd.
where if I add text to the next 1st name column, the next number i
automatically fillled or if I delete the row with Sara Silver, then th
next ro read:
2. Fred Red etc
I have tried using the formulas and the help, but to no avail.
Thanks for your assistance.
Message poste...Column charts with multiple data in each column
I have five months worth of data that contains a product and their quantity
used. I need a column chart that has the months on the x axis and the
proportion of the product in each column for each month. When I try to make
the chart it throws all the data for all the months into one fat column. Can
How are your data laid out? A cross-table with products (or months) as
column headings and months (or products) as row headings? If so, a
100% stacked column chart should do the job.
If you have data in a single table form, i.e., column headings are
month, product, and qu...copy column to another file
I have many file with six worksheet titeled: typeone-bob to typesix-bob.
I need to a macro, when run it on any worksheet, copy column "I" of any
worksheet to another file (box.xls) and set to column "I" to .....
any help will be greatly appreciated.
...reading from one table to populate a column in another table
Table A has customer code and customer name fields
Table B has customer name and phone number fields
I want to read through table B, look up the customer name in table A,
if it is there, copy customer code to a customer code column in Table
B that I will create. I could use a select statement to do this but
sometimes the entire name may not match but the first 15 or 20
by the way, I have bought lots of Access books and have yet to see
code similar to this request where you read through one table and
possibly populate another. I have programmed in Visual Foxpro and
this was...Have Lost "To" column in Sent folder
I am running Outlook 2003 on XP. I have accidentally deleted the "To" column
in the Sent folder and cannot find a way to get it back. Could anyone please
help me with this?
View-> Arrange By-> Custom...-> button Reset Current View
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, HowTo, Downloads, Add-Ins and more
Real World Questions, Real World Answers
"Derek Chilvers" <DerekChilvers@discussions.microsoft.com&g...Help identify column differences
I have a spreadshheet with 2 of the columns
being "Interest Paid" & "Interest Due". I need to add a
formula that will show me where the two columns have
different values or the same values. For instance, if
Interest due is 400 & interest paid is 400, I would like
the cell next to it to say, "DELETE". If however the
Interest Due is 400 and Interest Paid is any other amount
other than 400, I would like the cell next to it to
say "KEEP" and, if possible, formatted to be RED.
See this webpage Malcolm
ht...How do I get 18 numbers to display in a column and not round out
I need a column to display 18 numbers and currently it is rounding the last
three with zeros. I am using Microsoft 2003
How many digits in the numbers
More than 15? Then you will need to type then as text and will not be able
to do math on them
a) when typing, precede the entry with a single quote (will not show in cell
b) before typing, format cells as Text
Microsoft Excel MVP
email address: remove uppercase characters
"whamm24" <firstname.lastname@example.org> wrote in message
...Rounding formula won't copy to other cells in column
I have a formula in cell G2 that reads: =round(F2,0). I'm using this to
round the value in cell F2 and remove decimal places. The entire "F" column
has values I want to round, and I am unable to "fill" the formula so that I
can get the rounded values of each record in the range. What should I be
So what *does* happen when you copy the formula in G2 to other cells in
the column? Check to make sure Calculation is set to Automatic
In article <1933354D-C4AE-4051-87BD-29AF728A57DA@microsoft.com>,
LindaO <Linda...data validation of range, email specific row
Hi I'm trying to validate the data in cells C5:D5
if boths cells are yes, I would like it to send the row with both yes
values and then set E5 to yes
c d e
tested? success? emailed?
I don't know how to validate a range, I only figured out how to do one
If Range("C5").Value = "Yes" Then
How do I tell it to send the email after
How do get it to send just the heading row and the row with c5:d5
value = yes as a html table?
How do I set...How can I crop the unwanted rows of a worksheet please.
Ineed to crop the bottom of a worksheet or how do I only print the area with
Thanks in advance
You can set the print area to display only what you want. Select the cells
you want in your print area and use the commands
FILE -> SET PRINT AREA
"RORY" <RORY@discussions.microsoft.com> wrote in message
> Ineed to crop the bottom of a worksheet or how do I only print the area
> information on.
> Thanks in advance
If you hit ctrl-end, does that take you way pa...odd or even rows......and importing from Access
Can't get Excel to accept data in odd or even rows........from outside
Access has one line (row of data) and that can be copied into Excel, however
I would like to "split" some of that data between odd and even rows.
I can create queries to separate the data on right or left from Access -
Person has one name but has two arms legs and ears.
I want the first colums in every row to contain the same name, but future
colums in those two rows to contain either right(odd) or left(even side
row 1 Jones right ear good bad undetermined
row 2 Jone...hiding rows / columns when printing
is it possible to hide items when printing?
Hidden rows/columns will not print. You may do it manually or with a macro
Microsoft MVP Excel
"sam" <email@example.com> wrote in message
> is it possible to hide items when printing?
...MSChart Row Labels help!
I have a graph "ChtLive" that updates constantly based on values coming in
from PLC. The graph updates fine and displays my values on the screen
perfectly. However, I am having trouble with the row labels (rows 1-20)
updating as current time in VB6.
Ex: This function SHOULD do the following:
First time around, row label 20 holds current time.
frmMain.chtLive.Row = 20
frmMain.chtLive.RowLabel = Format(Now(), "ss") 'seconds on the minute
Second time the function in question is called, row 19 label takes value
from row 20 label, and row 20...How do I make column headings vertical in Excel
I am doing a report and need to make column headings vertical and cannot
figure out how to do it.
Select the headings you want vertical, goto>formate cells>look at
"orientation and select the vertical (Text) box.
The only dumb question is the one you did not ask.
> I am doing a report and need to make column headings vertical and cannot
> figure out how to do it.
Or if you meant you want them to become row headings instead of column
headings then copy all, paste special, check transpose, click ok...
"Mike Rogers" wrote...Using object model to coult the number of used rows
Does any one know how to count the number of used columns and rows in a
sheet via the object model
int m_columncount = m_CurrentWorkSheet.Columns.Count;
gives the total columns, but what I need is a count of the used colums.
Or do I need to write a manual count i.e. manually count how many are used
by by checking each element?
The following will get the number of rows in your used range
as you would observer using Ctrl+End
dim rowCnt as long
rowCnt = activesheet.Cells.SpecialCells(xlLastCell).row
Take a look at