I want to use the same formula in another workbook e.g. A1 sheet2!b1, however
when I copy it it links to the other workbook e.g. when I paste I get
目前分類:title (5957)
- Sep 10 Mon 2007 20:39
Copying formula to another workbook
- Sep 10 Mon 2007 20:39
Is it possible to merge data from two worksheets?
I am wondering if it is possible to merge two worksheets, that have the exact
same column headings, into one document, eliminating duplicate data based on
- Sep 10 Mon 2007 20:39
saving file name based on value in predetermined cell
how do i save a file based on a predetermined value in a cell.
- Sep 10 Mon 2007 20:39
template or formula for start time -finish time -total hours ple
please could I have a formula or function to enter start time-end time and
show total hours/mins for excel
- Sep 10 Mon 2007 20:39
and
How do I get rid of the and - icons on the left hand side of the screen
that hide my rows?
- Sep 10 Mon 2007 20:39
Update Spreadsheets
I would like to update a spreadsheet as follows:
I have a master spreadsheet in which I use different codes to each record. The second spreadsheet is modified with additional records or some records deleted. Both spreadsheets have each record with the same unique id number. The task I want to perform is to automatically update the master spreadsheet.
- Sep 10 Mon 2007 20:39
Work out overtime hours for individuals
Hi All
- Sep 10 Mon 2007 20:39
quot;IFquot; Formula Query...
I'm want to use an quot;IFquot; formula to compare the values in two cells and return
the following...
- Sep 10 Mon 2007 20:39
a question about big files
Greetings
- Sep 10 Mon 2007 20:39
Working with times
I just wondered if it was possible to check time availavilty within a
spreadsheet.
- Sep 10 Mon 2007 20:39
how to return non empty cells over several columns
Hi, this might be difficult for me to explain, so I'll use an example.
I have several columns that look like this:
- Sep 10 Mon 2007 20:39
command to Backup all my files
Pls let me know if there is any way to zip my working folder (cotaining 35
files) e.g user entering data, after click maybe macro button - the action
- Sep 10 Mon 2007 20:39
Workbook Set-Up Questions
Hi,
- Sep 10 Mon 2007 20:39
Line Graph Help
- Sep 10 Mon 2007 20:39
ex.=($B$4 C4) in macros for row why adding rest
It keeps adding all the totals in all of the column. Don't want that. I want
to keep an individual cumulative total for each row for inventory of that
- Sep 10 Mon 2007 20:39
Formating years.
have a csv file that in one column has years 89-99, 99-04 can I format that
column so that it changes those years to 1989-1999, 1999-2004
- Sep 10 Mon 2007 20:39
how to cover the formula
hi,could anyone tell me how to cover the formula in the column, so that people
unable see what the formula i have put in.
- Sep 10 Mon 2007 20:39
Row and Columns in Excel
Somehow we have amended an Excel worksheet so that both the row and column
headings are numbers! As you can imagine, to the less clever of us, this can
- Sep 10 Mon 2007 20:39
Conditional formatting based on another cell
Hi there,
- Sep 10 Mon 2007 20:39
Calculating average annual change in real estate value