blocking blank cells until other cells are compiled
I'm working on several columns. Each column corresponds to a certai
date. I would like the fields under the date cell to be "available
only if the date cell is filled. How do I do this?
Say in cell "A1" I have today's date and in "B1" tomorrow's (and s
on). In cell "A2" I want to put the number of dollars I have spen
during lunch and in cell "B2" I will want to do the same, but onl
tomorrow of course.
I would like to "compile" the whole month in terms of columns but
would like NOT to be able to write in the...Multi Table Queries
At my job, I use enter data through generated queries. However it appears
that I can only ENTER data in a query when it is based on two tables. If it
is three or more, it doesn't let me enter any info.
Is this normal? Am I doing something wrong?
>At my job, I use enter data through generated queries. However it appears
>that I can only ENTER data in a query when it is based on two tables. If it
>is three or more, it doesn't let me enter any info.
>Is this normal? Am I doing something wrong?
Yes, that's common. You should only edit data ...Unique records in Pivot Tables
I have data that stores Client Invitation to Tender and
Supplier Contract details. Each Client ITT is uniquely
identified. However we send out the same ITT to many
suppliers so each request for service is given the same
Reference Client/Supplier Contract Name Value Status
AC/001 Client blah 4,000 pend
AC/002 Client blah2 5,000 pend
AS/001 Supplier blah3 3,000 pend
AS/001 Supplier blah3 3,000 pend
When I create my table by Client to get the total value
pending ...Cell selection
Can anyone tell me why, when I select a cell near the bottom of a page, 3-4
rows seem to be sected as well?
Thanks in advance
You are probably in Extend mode. Look at the bottom right of the Status
Bar, look for Extend, its location and wording depend on version. If it is
on press Esc or F8.
If this helps, please click the Yes button
> Can anyone tell me why, when I select a cell near the bottom of a page, 3-4
> rows seem to be sected as well?
> Thanks in advance
I am having this p...Employee Master Table error after V10 SP3
i have updated V10 to SP3, from SP1, and all seems to be fine except if I
try to access the employee master table.
Either from cards>payroll>Employee, or payroll transaction entry. Anytime I
need to do a lookup on an employee id.
Here is the message:
A Get Change operation on table UPR_MSTR failed accessing SQL Data
If I go to the more information or details button:
[Microsoft][SQL Native Client][SQLServer] Invalid column name 'EMPLSUFF'
[Microsoft][SQL Native Client][SQLServer] Invalid column name 'Dex_Row_TS'
It looks like an upgrade script failed...Select a certain number of cells in a row
I'd like to have the macro to select row 5 to 10 in the active column. May I
know what is the VB code to write?
dim myRng as range
dim myCol as long
mycol = activecell.Column
set myrng = .range(.cells(5,mycol),.cells(10,mycol))
I'm not quite sure why you want to select that range. But for the most part, if
you act directly on the range (and avoid .selects), you're code will work faster
and be easier to modify.
Dolph...Cannot hide cells
I have a spreadsheet that is setup columns A-IV and need to hide columns but
after a while get the message "cannot shift cells off sheet"
any ideas its driving me nuts
How are you hiding the columns?
It sounds like you might be adding columns or moving cells to the right to
hide them from the view.
If you have items in Column IV you can not do this.
If you are doing it as<format><columns><hide>
about howmany times do you do it before you have the problem.
(I cant make it happen on my computer)
If you are doing it another way, What is it?
&q...text in cell shows up as ####
Operating System: Mac OS X 10.5 (Leopard)
Text in cells in a coumn shows up as ####, apparently because there is a large amount of text. When I mouse over, the text shows. It also shows up in the formula bar. How can I copy and or print the text in these cell? <br><br>When I try to save these cells as text and transfer to Word, they continue to print as ###.
text in cell shows up as #### <br>
I am totally new to this whole environment! A new iMAC and this software. <br>
However, in trying to learn how to use EXCEL, I found that...Printing large cells
I have a spreadsheet in which many of the cells are very large. When the
spreadsheet is printed, not all of the large cell contents print. How do I
get all of the cell contents to print?
...copying text on sheet 1 to corresponding cells on sheets 2 to 5
I want the text entered in A8 on sheet 1(named Productivity) to automatically
transfer to A8 on sheets 2 thru 5. I used the simple formula
=Productivity!a8 in the corresponding cells but when there is no data in
Productivity A8 I get a 0 in the corresponding cells. I would like the
corresponding cells to remain blank if there is not text in Productivity A8.
I am really new to excel, like only used it two weeks! Is there a simple fix
newbie at large!
A formula will always return 0 if it's refering to an empty cell. This
formula will let the cell look empty if no...Excel limited cell formats
I have run into Excel's limit on 4000 cell foremats. I have since split
the excel workbook into two separate workbooks.
My question is, how can I launch these from a template and have the two
workbooks link with each other,
My original workbook has 25 separate sheets within the workbook for a
total of 3.25mb size. I have a whole slew of macros assigned to
different command buttons.
...Adding Hyperlink to multiple values within a cell
My spreadsheet contains a list of people. The cell next to each nam
contains multiple numeric values for identifying a specific piece o
information. I would like to be able to click on one of those number
(value) and a comment window pop up with the information associate
with it, or be hyperlinked to the information further down th
I want to avoid using multiple cells for this.
Is this possible?
t2true's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=387
View this...Pivot table novice
As a teacher we tried a new data analysis tool this year in my school
which worked really well... except for the fact that it meant manually
filling in a table.
I'm sure there must be a more efficient electronic way of doing it, but
I'm not really an expert on these things.
I want to be able to put in a list of data: pupils names with scores
from two consecutive tests. Then I want to produce a table with test 1
and test 2 as the headers, and pupils' initials appearing in the
relevant box. I have managed to create a Pivot Table to show what I
want, except of course, it total...Pivot charts formatting
I want to change the formatting imposed by default in a pivot chart and I
want that changed formatting to be retained permanently.
For example, for my bar chart, for the different series I have selected
colours / patterns but every time I refresh the pivot table / chart; excel
falls back to its own colour coding.
Any way to get around this?
Many thanks in anticipation.
Not directly. The only way to simulate this is to record a macro of the
formatting changes that you make and then set it up to run whenever the
PivotChart calculates. Assuming your pivot chart is on a seperate shee...can i see the date the last time a cell was changed?
I am trying to figure out a formulla to make the date appear in one cell
everytime anouther cell's data is chaged.
Use a worksheet_change event to copy the cell address and put in a date
"JohnNuTek" <JohnNuTek@discussions.microsoft.com> wrote in message
>I am trying to figure out a formulla to make the date appear in one cell
> everytime anouther cell's data is chaged.
There really isn't a worksheet formula to do that. Typicall...Pivot Chart: Stop skipping Dates on X-Axis
I have a pivot chart which pulls 2 pieces of information from one table 1 and
1 from Table 2. All three entries are included for each day. Except somedays
which may have only the one piece of data from Table 2 or none at all. How do
I get the table to automatically fill in all the days whether they have
information or not?
=?Utf-8?B?UHJpbmNl?= <Prince@discussions.microsoft.com> wrote in
> I have a pivot chart which pulls 2 pieces of information from one
> table 1 and 1 from Table 2. All three entries are included for
&...can cells apply conditional formatting using the internal clock?
I am using excell to keep track of my production schedule
and I wanted to know if there was a way to tie the cells
in a worksheet to the internal date and time in the
computer,so that the cells will update automatically.
Example: Row A10 would be my production start date, Row
A1 would be my projected finish date, I would like the
cells in between to go from green to red as I near the
finish date without manually inputting the date in each
cell. Can you help me? Thyanks
Set the normal format as desired (I selected a Pattern of Green).
Select A1:A10, then select Format | Conditional Fo...Splitting excel cells based on content
I have an excel workbook with a worksheet created by a dump from a
database (DOORS in this case). The first column is unique, the second
not. The second column may contain 0 to n identifiers that I want to
look up on a separate sheet. The lookup is easy when the cell in the
2nd column has either 0 or 1 identifiers in it but when there are 2 or
more (separated by a carriage return I think) my lookup fails as lookup
is using the enitre contents of the cell. What i'd like to be able to
do is to automatically (there's some 900+ rows in the worksheet) is to
automatically insert additio...Simple question about text within a cell
I can't seem to find the option that prevents text from
covering the adjacent cell.
For example if I type the folling in cell A1:
All I want for Christmas is my two front teeth.
Obviously that will overflow over the cell B1 (if there
is no data in B1). I don't want to resize my column, I
only want the cell to show as much text in A1 as possible
without covering cell B1.
I believe I've seen the option to do what I'm looking for
but I can't seem to find it and I can't figure out how to
look it up in the HELP file.
Thanks in advance.
My simple solution ha...Grand Substraction instead of Grand Total in pivot table
I created a pivot table in Excel with Visual Report 2007. I'm using an
Outline Code with 2 leaves : Receipts and Expenses.
The pivot table created automatically a Grand Total so that $1000 Receipts
and $800 Expenses => Grand Total = $1800.
My accountant says $200.
Generally, it's possible to create calculated fields in the Excel pivot
tables. But in the pivot table created by the Visual Reprot, all the
Calculated Field options are greyed out.
Thanks for any help
I don't know what visual report is, but suspect that it would be more a
question for them not Excel a...Is Auto Expansion (i.e., wrap text) of a cell possible when the cell's contents are based on another cell?
I am trying to display the results from one tab (Tab 1) in another
So, for example, tab 2 contains the formula "=Tab1!A2".
However, when the results are too large to fit the cell in tab 2
(i.e., the cell that contains a formula that draws from a cell in tab
1), the wrap text feature does not work unless i first double click in
the cell in tab 2.
Is there any way around this? Can the wrap text feature work
automatically somehow? Or will i need to double click in every cell
that contains text that doesn't fit into the cell.
Thanks for any suggestions, or VBA code, th...Filtering data by custom fields in pivot tables from Visual Report
I have recently upgraded to MS Project 2007 and like the visual reporting
feature, except I really need to filter and group the resulting pivot table
in Excel by custom fields. For example, for task usage, I cannot filter my
pivot table to show only the tasks that have costs > $0, thus my table ends
up showing too many lines and a lot of 0's. I would also like to group by
department/ function which I put in a custom text field. How do I do this?
I saw related posts about saving the file as an Access database and then
creating the pivot table by connecting to the datab...Combining Pivot Tables
I have a data set of around 100,000 rows which I have imported into
excel in two sheets (~50,000 rows each).
The data is not in a format that excel can easily parse into a pivot
table directly from the source - it requires some formulae in excel to
be able to use a pivot table.
I have used a pivot table on each of those sheets to summarise the
data, and that works fine.
However, I would like to be able to get a single summary pivot table
from the two sheets (or from the two pivot tables).
Is that possible, and if so, how do I go about it?
"Alan" <...cursor control in cells
Can anyone help please?
For some reason i am no longer able to scroll across a cell by moving
through teh arrow keys. The whole sheet moves instead.
Can anyone tell me what I ahve done to lose this control please?
You have probably inadvertently pressed the Skulk key.
Press it again to take Scroll Lock off and you should be OK.
"Dave T" <email@example.com> wrote in message
> Can anyone help please?
> For some reason i am no longer able to scroll across a cell by ...remove carriage return in multiple cells
I have an excel sheet with lots of data. Unfortunately lots of cells contain
carriage returns. Is there a way
to remove the carriage returns in those cells (more returns in a cell
Select your range, then CTRL+H.
In Find What, type 0010 (number keypad) while holding down ALT.
Click Replace All.
Try running this macro:
Cells.Replace Chr(10), ""
Cells.Replace Chr(13), ""
Afterward you may want to turn off Wrap Text (under Format, Cells,
Alignment) for the affected cells.