|
|
move blank data by
reza
HI all....
i want to move data from sheet1 to another sheet, maybe it will need
macro...hope you can help me. Example...in sheet1 i have:
Line Col A ...
( 1 2)
|
October 6th, 2009 10:49 AM
by reza
|
10 |
214 |
|
|
any solution to slash problem by
driller
Hello,
i found some code that works so neat, i just need to reconcile one (1) thing.
i like to have this code to provide the correct hyperlink addresses along...
( 1 2)
|
October 6th, 2009 10:48 AM
by driller
|
16 |
329 |
|
|
|
October 6th, 2009 10:31 AM
by Miri
|
0 |
116 |
|
|
Macro to tidy data by
dapouch
I work with reports coming out of a telephony system. Frustratingly the data
needs to be cleaned after it's imported into excel. The data from first two...
|
October 6th, 2009 10:21 AM
by dapouch
|
4 |
110 |
|
|
|
|
5 |
140 |
|
|
Header Columns by
Doug
How do I have separate column widths in a spreadsheet? I wish to insert a
legend in the spreadsheet header and freeze frame it, but I wish for the body
to...
|
|
2 |
119 |
|
|
camera by
Miri
hi, i"m using the camera in my excel.and when i scroll up and down, the
camera is also moving. is there an option to make the camera always shown on
top of...
|
October 6th, 2009 09:48 AM
by Miri
|
0 |
121 |
|
|
|
October 6th, 2009 09:45 AM
by Miri
|
0 |
111 |
|
|
IF formulas by
reza
Hi Expert....
guys...hope you can help me with formulas...(ms Excel 2007)
Line Col A Col B Col C Col D
Col E
1 ...
|
October 6th, 2009 07:59 AM
by reza
|
5 |
132 |
|
|
|
|
1 |
110 |
|
|
countif by
Andy K[_2_]
Cells A1: A10 and B1:B10 have a list of components "NUTS" and "BOLTS" I
would like to use countif to total the number of times I see NUTS but only if
bolts...
|
October 6th, 2009 07:19 AM
by Stefi
|
7 |
151 |
|
|
cursor is stuck by
VB
Occasionally when I am working in a spreadsheet (Excel 2007), the cursor
becomes "stuck" and when I try to click on another cell, the result is to
highlight...
|
|
2 |
111 |
|
|
|
|
1 |
121 |
|
|
|
|
2 |
121 |
|
|
|
|
1 |
131 |
|
|
Copy Past Values by
Ed Davis[_2_]
I have several workbooks with as many as 35 - 40 worksheets.
Each workbook (And as many as 20 sheets from each workbook) Calls cells from
the previous months...
( 1 2)
|
|
13 |
230 |
|
|
|
October 6th, 2009 03:19 AM
by Mg
|
11 |
202 |
|
|
Will Macro before a Function like Now() ?? by
Boiler-Todd[_2_]
If I run a macro for a workbook with "Sub Workbook_Open()", will the macro
run first before the functions like "Now()" in the workbook updates. I am...
|
|
2 |
128 |
|
|
Conditional format calculate 6 months by
SoggyCashew
Hello, I cant figure out how to do this. I have a date in a cell, lets say
its 10/5/9 and I want that box to stay red untill 6 months have past. so when
its...
|
|
2 |
123 |
|
|
vlookup using match and date range by
Gina C
I have a list of data in which A:A lists names B:B lists date of status
change and C:C lists the person's status as of the date in B. I need to find
the...
|
|
1 |
118 |