|
|
Linking Columns between worksheets by
Malcolm
I have a workbook and I would like to do the following: sheet 1 named “End
Bal” has 8 columns. In 2 of the columns; cells B5:B22 and H5:H21 contain one...
|
|
6 |
1,024 |
|
|
Date Help by
Malcolm
I have linked two columns on a worksheet so that when I type in the date in
cell C6 it also appears in cell J6. I entered =$C$6 in J6, and this works
except...
|
|
1 |
237 |
|
|
Truth Table by
Victoria612
OK - I have 6 questions, all of which can be answered either yes or no. Is
there a way to build a macro that can determine all 36 possible scenarios for...
|
|
2 |
222 |
|
|
YTD % over 12 accumulating figures by
Ellie
I have a spreadsheet listing out employees, e.g. as follows:
Name Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Total YTD%
A N Other ...
|
|
1 |
262 |
|
|
CELL CONTENTS WRITE TO TAB NAME by
Pam M[_2_]
I know there is a way to reference a worksheet name in a cell. Is there an
automated way to name the sheet based on a cells contents? I have summary
sheet...
|
|
0 |
250 |
|
|
|
May 27th, 2010 10:49 PM
by Mathew
|
3 |
332 |
|
|
CELL CONTENTS WRITE TO TAB NAME by
Jacob Skaria
Select the sheet tab which you want to work with. Right click the sheet tab
and click on 'View Code'. This will launch VBE. Paste the below code to the
right...
|
|
0 |
328 |
|
|
Linking text cells between 2 worksheets by
Malcolm
I tried this before but explained my problem so badly I did not get the
response I was looking for, so let me try again. My workbook contains sheet
1(the...
|
|
0 |
394 |
|
|
|
|
0 |
226 |
|
|
|
May 27th, 2010 10:44 PM
by Mike H
|
1 |
335 |
|
|
Date Math by
Microsoft[_18_]
Excel 2007
1 have a
start date: 01/01/2009
finish date: 23/06/2010
I want to calculate the length of service between the two dates to the
nearest month,...
|
May 27th, 2010 10:40 PM
by Mike H
|
4 |
417 |
|
|
Macro to build table by
Victoria612
I have 6 questions that may be answered yes or no, and for the sake of
keeping everything in integer form, let's assume "1" for yes and "0" for no.
Depending...
|
|
0 |
309 |
|
|
frustrated excel newbie by
FSt1
hi
format the cell with the validation to date. if formated as general, you
will get the serial date number.
Regards
FSt1
"TJ" wrote:
I am trying to make...
|
May 27th, 2010 10:39 PM
by FSt1
|
0 |
224 |
|
|
|
|
1 |
352 |
|
|
prompting while typing by
John
Open office org - while working on excel sheet, prompting of words helps a
lot in reducing the time of work. Is microsoft excel having the same function
|
|
2 |
251 |
|
|
ticking box by
deeps-k
how i add ticking box in worksheet (cell)
|
|
1 |
208 |
|
|
IF AND VLOOKUP formula needed by
Carolina
I need to do a formula where I need to determine if the size of C12 or C13 is
greater or less than E12 or E13 respectively. Knowing that I need for the...
|
|
1 |
268 |
|
|
|
May 27th, 2010 10:30 PM
by Max
|
2 |
273 |
|
|
Date Help by
Eduardo
Hi,
use this formula instead
=if(C6="","",$C$6)
"Malcolm" wrote:
I have linked two columns on a worksheet so that when I type in the date in
cell C6 it...
|
|
1 |
225 |
|
|
CONCATANATE by
nlogan
How to concatanate two fields. Entered =concatanate(a2,b2). Getting #NAME?
|
|
3 |
230 |