|
Compatibility Problem Excel 2003 x 2007
Excel 2007 imcorporated some functions which used to be in a add in previous
versions. This is the case, for example, for the workday() and networkdays()
functions but there are some others.
When I open a 2003 spreadsheet with this functions Excel prompts I'm using
"reserved" names for user defined function which is now internal.
The problem is when I save this 2003 spreadsheet in Exce...
|
2 |
12/30/2008 11:02:29 PM |
|
|
Indirect question
I want range ("CB4:CN289") to indirectly reference Range ("BL4:BX289")
As far as I can see I have to enter the indirect command into each cell
individually. Is there an obvious way of mass producing and doing it in one
go?
Many thanks
...
|
3 |
12/30/2008 10:54:15 PM |
|
|
Macro Commands
I want to be able to search through an imported text file for the first
instance of a work (no problem doing this) and then select all the
"Row" above it and delete them. So . . .
How do I programatically determine which row the "Search" string is in
and then pass that to the next line to delete all rows above that row?
--
...
|
6 |
12/30/2008 10:44:44 PM |
|
|
Getpivotdata Question
Hi,
I am working with a spreadsheet and I'm trying to use the getpivot data
function with dollar amounts. It has worked for all other figures on my
spreadsheet but when I try to get a number that is $$ the function isn't
working I get the REF error.
My formula looks like this: =GETPIVOTDATA("Average Salary",Sheet1!$A$6,"C-R
Band",".85-.89")
Thanks for any help you can offer!
...
|
4 |
12/30/2008 9:46:43 PM |
|
|
Macro buttons for gray scale and color print
I have a logistics workbook with a summary page that has print macro buttons.
I'm looking at having two (2) print buttons for certain worksheets. I can
figure out how to add the print function into a button, however the problem
I'm running into is when I set the references for printing, it stays in that
reference. I'm wanting one (1) button for color print and one (1) for gray
scale prin...
|
3 |
12/30/2008 9:33:34 PM |
|
|
Conditional Move
I have the need to copy the content of a cell to another cell based on the
value of a totally different cell. If A1 is =>1 and =<10, then I need to copy
the content of a3 to a4. Any clues on how to get this to work?
Thanks, Mike...
|
6 |
12/30/2008 9:23:35 PM |
|
|
Conditional Formatting on a Linked Cell
When I apply conditonal formatting to a linked cell in my spreadsheet it does
not work. Is there someway to get this to work? I am trying ot get eh vale
to be bold if it is geater than a fixed value.
The cell link is =UPLOAD!J107 that I am trying to format conditionally.
Thanks...
|
5 |
12/30/2008 9:21:42 PM |
|
|
How can I Round up to the nearest .25
How can I Round up to the nearest .25.
I have Cells B3 thru G3 with Values: 3.02, 3.41, 3.65, 3.91, 4.29, and 4.79.
I would like them rounded up to the nearest .25 (3.25, 3.50, 3.75, 4.00,
4.50, 5.00).
Is there a function for this?...
|
12 |
12/30/2008 9:19:37 PM |
|
|
2Q:Indirect worksheet selection in macro, Calc off for specific sh
I'm having trouble finding the code to use within a macro to select a
worksheet based on the value entered into a certain cell.
What I have is a worksheet for entering data and a macro that organizes and
copies the data to other sheets, one being a catch-all for all data and
another being a sheet corresponding to a specific value entered in B2.
Options for data in B2 are validated from...
|
2 |
12/30/2008 9:11:45 PM |
|
|
Macro for check box
I have the following information:
Column A Column B Column C
Revenue 1000.0 1200.0 1300.0
Expense $500.00 $300.00 $200.00
Margin $500.00 $900.00 $1,100.00
I am adding a check box in the bottom of each column and I need to
created a macro that when I check the box (true) it will copy and
paste as a value the data above the check box.
thanks for your help.
Pantera
...
|
3 |
12/30/2008 8:59:32 PM |
|
|
counting starting with a number other than 1
I am creating automatically generated tracking numbers for groups of data by
using the following formula: =IF('Sheet !'!A1 = 0,COUNT($A$6:A6)+1, " ") ( in
these groups of data the header row is 0 in the A column, if that ake sense).
What I need to do now is make the count start at a number other than 1, say,
2000. What do I need to add to the forumla to accomplish that?...
|
2 |
12/30/2008 8:42:49 PM |
|
|
How do I re-format the content in populated cells in Excel?
I have a column of dates that I want to switch to another date format. So far
I know how to do that only by formatting the column, then double-clicking on
a single cell, clicking on the column header, and repeating this action with
each subsequent cell... There has to be a better way, no?...
|
4 |
12/30/2008 8:40:41 PM |
|
|
Compiling email addresses from individual cells
I'd like to send a single email to a couple hundred associates. Each email
address is listed in a separate cell in a single file column. I've
concatenated the list but can't figure out a way to capture the text (I can
capture the formula but I don't need that) so I can take it and paste it in
the address field. I'm using Excel 2003 SP1....
|
3 |
12/30/2008 8:30:32 PM |
|
|
Locking Excel cell formating and editing, copying and pasting cont
Is there a way to lock Excel cell format on just part of a worksheet AND
allow editing of same cell contents AND allow copy and paste of entire
worksheet? This is needed particularly for areas that have "check boxes" in
the area that I want to protect the formating. The "check boxes" tend to
move in relation to their original placement each time the worksheet is
copied and pasted after...
|
2 |
12/30/2008 8:29:21 PM |
|
|
Creating a macro to print the date a document was last saved.
Good morning!
I am looking to add a macro to a workbook that will automatically print the
date last saved (in the bottom right corner, I think).
Can you help?
THANK YOU!
~judi...
|
3 |
12/30/2008 8:17:23 PM |
|
|
Compare two cells, if equal move a third cell to another cell
Need a formula to compare the content of two cells and if equal, move (copy)
the content of a third cell to another cell. Any help would be appeciated.
Mike...
|
4 |
12/30/2008 7:26:38 PM |
|
|
calculate number of days
Hi guys.
Ok i have items that run between two dates, each month i have to calculate
how many days in that month relate to that item, eg. in Jan
Item From To Jan Days
a3 14/11/08 16/02/09 x
a4 19/12/08 09/01/09 x
So x = 31
x = 9
Is there a quick way to produce the number of jan days for each item between
the two dates ...
|
7 |
12/30/2008 7:15:01 PM |
|
|
Excel 2007 - Sorting 3 columns
I am not very good with Excel nor 2007 version so hopefully I can explain
this so you can understand.
I have an excel spreadsheet for work that I am trying to sort 3 columns at
once. Column A is titled Classes, Column B is Grades and Column C is Type.
I turned on the filter sor sorting and used the down arrow of Column A to
select what Classes I wanted and it did fine; however when I tr...
|
4 |
12/30/2008 6:47:21 PM |
|
|
entering timecode into cells
I'm trying to enter metadata for video assets. When I enter "35:55" for 35
minutes and 55 seconds, it keeps being changed to a fraction or a date or
sometimes "0:35:55". I've tried formatting the cells to general or MM:SS, but
it won't work
Does anyone know what to select when entering TRTs for tapes?
Thanks!...
|
3 |
12/30/2008 6:42:09 PM |
|
|
Pivot Table Report Filter Sorting
Is there a way to sort the items in a Pivot Table Report Filter
alphabetically or numerically in Excel 2007? I notice that that they
currently appear in the order in which they are present in the raw data....
|
4 |
12/30/2008 6:20:24 PM |
|
|
Clearing cells based upon criteria?
I have a worksheet that I would like to have specific cells cleared to
nothing if the value in one specific cell changes. So if I change the one
cell at any time and point then the other specific cells clear out of
anything. Can anyone tell me if this is possible and how I would go about
it. Currently I have a macro set up that clears the cells if you "CTRL + c"
but I would like it to...
|
6 |
12/30/2008 6:07:06 PM |
|
|
macro protection
Hi everyone,
Is there a way to password protect macros especially those written to
command buttons. If someone fiddles with a macro, this can mess up the hole
work.
Thanks
Albert...
|
4 |
12/30/2008 6:00:14 PM |
|
|
Excel file as two SEPARATE windows - Data and Chart?
How can I have an Excel 2007 file with 2 sheets, Data and Chart, so that each
sheet opens in a separate window? It USED to work like that, with the older
version I had. I want to be able to switch between the windows with alt-tab.
Any ideas?
Thanks,
Tim...
|
3 |
12/30/2008 5:59:01 PM |
|
|
Copy formula
how can i copy a formula from one row to another with out changing the
refrences and with out using absolute refrences "$" eg. In row 2 i have
=average(B200:B300) I want to copy the exact formula into row 20 with out
having to change the formula in row 2 to =average(B$200:B$300) is this
possible?...
|
3 |
12/30/2008 5:54:00 PM |
|
|
Sorting Subtotals
I have a spreadsheet that I am subtotaling. Most of the subtotals are zero,
but I am only concerned with the subtotals that are not. I need to keep the
detail. How can I segregate what has a zero total from another subtotal
without manually looking through the spreadsheet and copying and pasting? I
have already tried sorting by the total column, but it won't let me. FYI, I
am using ...
|
12 |
12/30/2008 5:48:14 PM |