Column Headings #11
Can you add seperate column headings (A, B, C, ...) into one spreadsheet?
I'm attempting to alter the column sizes half-way through the spreadsheet
w/out affecting the upper column sizes...
Coolumn width belongs to the entire column and cannot be altered in separate
sections of that column.
Gord Dibben Excel MVP
On Tue, 8 Mar 2005 15:51:01 -0800, spencer4hire
>Can you add seperate column headings (A, B, C, ...) into one spreadsheet?
>I'm attempting to alter the column sizes half-way through the spreadsheet
>w/ou...Text to columns
Once I use the Text to columns feature in Excel, it seems there is no way to
turn it off.
Anyone know if there is a way to reset this so that newly pasted text will
not continue to get broken up (for example by the space delimiter)
Presently the only way is to exit Excel and restart Excel - then pasted text
all goes into one cell regardless of spaces.
Hope I explained that well enough
I may have been to hasty in making this assumption, it appears that the
problem I described below is only happening on one workstation - this may
indicate that the Excel Registry keys are in need of...Update one table from another
I am trying to update one table that has one record for each employee(table
1) with available vacation time. The other table records every time off
request(table 2) and how much time they want off. I have the update query
and it works fine. The problem is that everytime it is ran every requested
time off amount(from table2) is subtracted from the available time(table1)
again and again. I want the records for requested time(table2) to update the
employee available time off(table1) only once, but keep the records on the
table as that is the basis for a report.
----=...Creating a table
There's probably an easier way to do it but...
I have a series of numbers in column A (150 in all) and a series of letters
in column B (22 in all). In total there are 4800 rows.
What I am trying to do is create a table with the number down the left hand
side and the letters across the top. In each cell within the table I need
to count how many times the combination of number/letter appears. Eg:
A B C
201 0 2 2
202 3 0 1
203 3 6 4
I tried combining the number/letter into a single text field using the
CONCATENATE function then filtering ...appending to CEdit
I have a CEdit control and I want to append text to it as follows:
void CSerialPortDlg::debugf(char* format, ...)
char buf; // should be big enough
va_start( arglist, format );
vsprintf( buf, format, arglist );
va_end( arglist );
if( GetSafeHwnd() && m_edit.GetSafeHwnd() )
m_edit.LineScroll( m_edit.GetLineCount() );
m_edit.SetSel( -1, 0, TRUE );
m_edit.ReplaceSel( buf );
This works fine until there is a lot of text in the CEdit control. After, oh
I don't know, maybe 64k of data or so, it no longer adds any...How can I clear the last Data->Text to columns to formatting
I've noticed in Excel 2000 that if I paste text into various worksheets
within a workbook each paste will assume the Text->Column formatting that I
applied in the previous. How can I prevent it from happening ?
Just run another data|Text to columns against a dummy cell.
Specify delimited, but remove all the check marks from all the possible
(alternatively, you can close excel and reopen it.)
> I've noticed in Excel 2000 that if I paste text into various worksheets
> within a workbook each paste will assume the Text->Col...Column Reference to External Source As a Variable
Can anyone help me convert the column referenced in the formula below into a variable that the user can define?
More specifically, I have several columns that I need to read from an external workbook (Short_Billy.xls). Each column to the right of column C represents an additional day out in a 14 day projection from today (whose data is held in column C).
In cell I5 of my active workbook (Inventory.xls), I would like the user to be able to enter a value representing the number of days out they would like to see the projection for (0=today=Column C, 1=Tomorrow=Column D, etc.). In cell I6, I...Finding all queries which use a table
Does anyone know of a tool that can scan all queries in a database and find
if a certain table is used? I have a table called tblCustomerRollup which is
old and outdated. I want to see which of the 500 queries in my database use
this table without opeing every single one of them?
Sounds like a variation on Search/Replace. Try searching online for
"Database Documenter" as a starting point.
A couple of the commercial tools I've used include FMS, Inc.'s Total Access
Analyzer and Black Moshannon's Speed Ferret. There are a lot of fr...what is the function and name is of the symbol in each table cell.
Under Paragraph I clicked the Show/Hide Symbol icon so I can now see a
symbol at the end of each text within a table cell.
I wondered what that is so I tried to use Help to find out.
I did find help that mapped a word (like paragraph) into a symbol.
But I can't find anywhere where if I know the symbol it will tell me the
Can you tell me how to find such info?
Or maybe you can tell me what the function and name is of the symbol in each
I'm sorry, I meant to sent this to the Word group.
Of course, I wouldn't mind getting the info...How to write a new entry in a combo box to its underlying table
Dear Access 2007 VBA Gurus,
I have a assets database (rather uncreatively named "Assets"). I use a form
(named "Asset Acquisition Input Form New") to enter new assets. The
"Manufacturer" field (combo box name "Manufacturers_ID) on this form is a
lookup to a Manufacturers table. What I want to happen is when I enter an
item that is not in the lookup list, I want a message box to prompt me to add
the new entry to the underlying table, or to cancel and select an item from
the list. I have no trouble with the MsgBox command itself. What I don&...Keeping a table in a form editable and checking that fields are filled in before allowing a save
Firstly apologies if this is the incorrect forum but I was looking for
a general word forum and could not find one. Please point me to one if
I am trying to create a form where I want to specify what items need
to be filled in. (Review minutes from design reviews). I want to make
certain fields mandatory like the date, attendees and check list used
and want to block saving of the document with a warning until they are
filled in. Is there a way of doing this?
Also as a part of the review actions are filled in to a table.
depending on how many actions there are the table...Excel 2003 Copy/Paste filtered column
I have a filtered column on my spreadsheet. I have copied the column,
changed the figures and then tried to paste it back on to the filtered
column. It is not copying over the original filtered column but rather over
cells that have been filtered out. The worksheet/cells are not protected.
What could the problem be?
That's the way pasting works. It'll hit the visible and hidden cells.
> I have a filtered column on my spreadsheet. I have copied the column,
> changed the figures and then tried to paste it back on to the filter...Right click in Pivot Table or on Entire Column
I have added items to the right-click menu that popups up when you have a
cell or cells selected. But when you are in a Pivot Table or have an entire
column selected the right-click popup is different.
Is there a way to add an item to the right-click popup menu when you are in
a Pivot Table or have an entire column selected?
Thank you for your help.
Never mind. This one was right in the help section. I should have looked
> I have added items to the right-click menu that popups up when you have a
...how to automatically suppress space before after column break?
Having Spacing Before and After on some of the styles, I seem to be unable to
have the space before at the beginning of a column automatically dismissed
when applying a column break. I have tried a couple of options under
compatibility, but to no avail. This in on Word 2003. The No HTML function +
No Space Before after column break do not solve the problem. Can you help
Tools | Options | Compatibility: Suppress Space Before after a hard page or
column break. If this isn't working, then check to make sure you don't have
an empty paragraph before the first text pa...matching columns of numbers
In EXCEL 2000 for Windows, I have two columns of numbers. Column A has
500 numbers, Column B has 1000 numbers. I need to know which cells in
Column A have a match in Column B, and if so, what is the Cell (or row
number) in B that matches to that particular cell in A. How can I do
Thank you for your help.
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
try the following:
- insert a new column between A and B (so make B the new C column)
enter the following in B1
=IF(ISNA(MATCH...FP: Couldnt close table
We have been receiving this error on two separate PCs
after a recent upgrade to 7.5. Our version is 7.50g43
(service pack 5). At first we thought it was isolated to
one PC now a second PC is having the same error. On the
first PC, I ran new network cable, installed a different
network card with no help. This PC is Win98, 64MB RAM,
600Mhz. The second PC has 128MB RAM also Win98. I don't
believe switching to XP is an option right now. This
message has appeared in the payables module on both
machines. But it has also appeared in receivables as
well. Not in GL or Payroll. I...Same Table cannot be the child table in two nexted relations...
I've been setting up a schema with the XML Designer in VS .NET 2003.
The designer lets me set up a lot of things including a complex type that
contains an unnamed complex type called modified.
When I try to preview the dataset, I get an error described as "The same
table (modified) cannot be the child table in two nested relations.
I've run into this before with a different complex type, and I've changed
the name of the instance of the type in the various elements it's used, and
the problem goes away.
In this case, problem is an unnamed complex type, so it only a...Pivot tables and Macros
I was looking to be able to manipulate (ie change selections from the
drop downs, not change the fields in the table or anything)and print
from a pivot table using a macro.
So how do I go about doing that?
When I set up a macro by recording the actions that I want to do, I
always get an error message when I try to run it as a macro.
What specific steps are you recording, and what error message do you get?
Can you click the Debug button, and see the line of code that is causing
Dust For Eyes wrote:
> I was looking to be able to manipulate (ie change selections from the
>...How to copy aQuery to a new Table?
I have a database in a Table, a report based on that same Table and a Query
based on that Report.
After two months or so I like, after some new data input, to save the Table
into a new Object Table. What is the best way for the Report and Query to
follow the new Table whitout recreating the original Report & Query?
Thankyou for your comments. I use MS Office Access 2007.
>>I have a database in a Table, a report based on that same Table and a Query
based on that Report.
Your phrasing is wrong when it comes to the elements of an Access database.
A dat...obtaining data in text form from a table
I like to be able to obtain the dates in a text format from the table
Test6 4-Feb,5-Feb, 9-Feb
Do I need to do this by macros and if so, any help would be appreciated.
Care Recipient Surname 4-Feb 5-Feb 8-Feb 9-Feb
Test5 4-Feb 8-Feb
Test6 4-Feb 5-Feb 9-Feb
Vlookup should do what you want, as in:
Adjust the ranges t...Count the text in a column
I would like to count the text in a column then for it to add a figure in
another cell if it meets the text criteria
Do you mean count the characters?
as an array formula (committed with Ctrl-Shift-Enter)
(remove nothere from the email address if mailing direct)
"Peter Curtis" <PeterCurtis@discussions.microsoft.com> wrote in message
> I would like to count the text in a column then for it to add a figure in
> another cell if it meets the t...Pivot Table in Excel
I have a problem using the pivot Table in excel 2000.
Earlier the location of the pivot table in excel was
pointing to say c:\sales.mdb. Now the location has changed
to D:\Sales.mdb. someone please tell me the place to
change in the excel to reflect the same. So that upon
refreshing the document i can see the latest data.
Currently i am getting a error message when i try to
refresh, but its not prompting to change to alternative
location. If i edit the excel file in a notepad...i can
see the location pointing to c:\sales.mdb.
Thanks in advance for any help regarding this..expect...forms and column lengths
Is there a way to have excel do an auto "carriage return" to the next row
when you have reached the specified maximum number of characters in the row
there's n o bulit-in feature for this
"Blair" <Blair@discussions.microsoft.com> schrieb im Newsbeitrag
> Is there a way to have excel do an auto "carriage return" to the next row
> when you have reached the specified maximum number of characters in the
...pvt table field settings!
i am receiving data every day from 10 different places as under.!
TOTAL NUMBER OF RECEIPTS 10
TOTAL OF RECEIPTS AMOUNT 1000
TOTAL NUMBER OF RECEIPTS 50
TOTAL OF RECEIPTS AMOUNT 1500
TOTAL NUMBER OF RECEIPTS 15
TOTAL OF RECEIPTS AMOUNT 1000
TOTAL NUMBER OF RECEIPTS 10
TOTAL OF RECEIPTS AMOUNT 1000
-likewise i'm receiving daily data from all the 10 places..!
what i want is a pivot table report on a...Selecting a column with an integer
' Selecting a column with an integer
' Please show me how to eliminate the use of Cells(1, 1)
Dim r As Integer
Dim c As String
Dim numericcolumn As Integer
Dim alphabetcolumn As String
numericcolumn = 4 ' in practice 4 is the
resultant of an equation
alphabetcolumn = "=CHAR(" & numericcolumn + 64 & ")"
Cells(1, 1) = alphabetcolumn ' I like to eliminate the use of
c = Cells(1, 1).Value ' I like to eliminate the
use of Cells(1, 1)