|
|
Insert date in macro by
George Gee
Happy new year to all!
I recorded this macro some time ago, the cell A5 is selected at the end of
the macro,
ready for the user to insert today's date.
How do...
( 1 2)
|
|
12 |
674 |
|
|
pulling data from one sheet to another by
RPW
I have a workbook with multiple sheets. On one sheet, for cell a22 (which is
a thru g 22, merged), a value is entered, say 'single story system'. I want...
( 1 2)
|
February 20th, 2007 05:04 PM
by Max
|
12 |
183 |
|
|
Loop all Sheets not working. by
Pank
I have the following macro which I want executed for all worksheets within a
book.
I have tried it out and it only runs in the sheet that is selected, if I...
( 1 2)
|
February 27th, 2007 11:55 AM
by Pank
|
12 |
144 |
|
|
Excel can not multiply? by
oldny
I am working on a new spreedsheet and wanted to multiply the total of 22
columns by a constant. No mater what constant I put into the formula
=SUM(E53* )...
( 1 2)
|
March 28th, 2007 03:00 AM
by JLatham
|
12 |
204 |
|
|
|
|
12 |
151 |
|
|
Inputting a length of time? by
Link
Hi
I am trying to calculate depreciation in my Excel spreadsheet. The
depreciation is over 60 months, so for a $6,000 item, the formula is
=$6,000/60 =...
( 1 2)
|
|
12 |
167 |
|
|
Totaling a column or row of "x" s by
Randi
I have several cells with an "x" in them. I am trying to get a total of the
"x"s by row and column. I am new at this and need a step by step
instruction....
( 1 2)
|
June 28th, 2007 07:34 PM
by Randi
|
12 |
187 |
|
|
What formula/function can I use? by
mekus31
I'm creating a spreadsheet for a client and I'm not sure what
formula/function I need to do this:
I created a table with over 500 available values. I then...
( 1 2)
|
July 10th, 2007 11:59 PM
by Max
|
12 |
142 |
|
|
|
July 28th, 2007 01:06 AM
by Pete_UK
|
12 |
171 |
|
|
1 Million Rows ?? by
Kevin
How can I import Access data that exceeds 65 rows? I understand that Excel
can now handle 1 million rows - but I cannot figure out how.
( 1 2)
|
|
12 |
137 |
|
|
Colour by clicking cell by
ronoee
I am searching for a way to change background colour by click in a cell and
back to normal colour by clicking it again.
Is this possible? And if how is it...
( 1 2)
|
|
12 |
157 |
|
|
automated copy & paste by
DarkNight
hello again, i'm trying to get this to work:-
A1 = date ( changeable )
A2 = £ ( changeable )
B1 to B100 ( if B1 has £ in it move to next cell down without...
( 1 2)
|
|
12 |
196 |
|
|
Matching data. by
Barry Walker
I have two sets of data (2 worksheets)
one set contains a column with 14000 different numbers and a second column
with corresponding values to these...
( 1 2)
|
|
12 |
198 |
|
|
Difficulty in transposing by
Richard J
Hi,
This is my first post and there will be many more to come I expect.
My first Question is in relation to transposing. I cant seem to
transpose linked...
( 1 2)
|
August 6th, 2006 09:53 AM
by Max
|
12 |
292 |
|
|
How to work with Hyperlinks by
ilyaz
I have several columns with several dozens of hyperlinked entries in each
column. I'd like to unlink them all. I highlighted all entries in a column
and...
( 1 2)
|
August 23rd, 2006 08:48 PM
by SteveW
|
12 |
197 |
|
|
|
|
12 |
107 |
|
|
JOINING OF TEXT & DATE by
SJ
Hello!
Text = "Receipts from:"
Date = 10/5/06. (This date will in a different cell and will change every
month)
The decription I desire will be: "Receipts...
( 1 2)
|
|
12 |
155 |
|
|
|
December 15th, 2006 08:16 AM
by Max
|
12 |
168 |
|
|
Delete Rows by
Bernie
I would like to be able to delete a row with a name in it based on a
cell with that name from another cell in a different worksheet. Any
ideas?
Thanks,
Bernie
( 1 2)
|
December 29th, 2006 06:40 PM
by Bernie
|
12 |
147 |
|
|
Compare and Highlight Rows by
Lisab
I have an excel file with two worksheets. is there a way to programatically
compare the two worksheets to find matches and highlight those matches on
each...
( 1 2)
|
|
12 |
194 |