|
|
Alt-Enter Line Breaks by
Keven Denen
Alt-Enter works fine to create a line break in the middle of a cell.
The problem I run into is when I link to that cell somewhere else in
the workbook, the...
|
|
2 |
174 |
|
|
Sorting by date by
rmann11
I need to organize data into 6 different positions on a sheet, and the data
is formatted like this... name|date|Starting time|End time. There are 6...
|
|
1 |
140 |
|
|
Cell Format changes unexpectedly by
HappyDaddy
Excel 2003, SP2
I have a spreadsheet with cells formatted as "General".
They repeatedly revert back to "text".
I also have conditional formats which still...
|
|
1 |
134 |
|
|
Editing sql server data in Excel 2007 by
joker197cinque
Excel 2007 SP2.
I succesfully created a connection to a SQL Server 2005 and can view
all sql server table data in my sheet.
I would like to be able to edit...
|
|
0 |
140 |
|
|
Loss of data on spreadsheet by
Big L
Having saved an excel spreadsheet I reopened it to find the numbering of
cells down the left hand side of the spreadsheet and the letters at the top
of the...
|
|
3 |
128 |
|
|
IF function by
mygsdsni
You can only add 7 conditions. What do you do if you have more then 7? Is
there another function?
Thanks,
Kristin
( 1 2)
|
|
12 |
238 |
|
|
Delete Timestamp by
Gazz_85[_2_]
I can export data from my mrp system, however the date an issue occured has a
timestamp which is
DD/M/YYYY HH:MM:SS
What i want to do is be able to...
|
|
2 |
135 |
|
|
|
|
5 |
186 |
|
|
Splitting sets of data by
drumbumuk
Hi All
I have an XL spreadsheet labelled 'English' in which is a contact list of
all contacts that speak English. One column is labelled Country. I want to...
|
|
4 |
147 |
|
|
|
|
4 |
156 |
|
|
Subtotal Countif by
Alberto Ast[_2_]
If I have a filter on column "A..G" and then I filter on ecolumn for x
criteria... I do subtotal (9,A5:A200) it will only add up those meetting the
filter...
|
|
6 |
179 |
|
|
|
|
6 |
150 |
|
|
|
|
2 |
156 |
|
|
Creating a button in Macro by
rmann11
I am trying to create a button or check mark so that when a user presses it a
number will appear, but when they 'deselect' the button or check mark that...
|
October 7th, 2009 03:31 PM
by rmann11
|
2 |
141 |
|
|
Excell 2007 Format Changes by
FinanceGuy
In Excel 2007, cells with date or general formatting sometimes change to Euro
currency formatting. It happens randomly - sometimes once a week, sometimes...
|
|
0 |
124 |
|
|
Spreadsheet Formulas by
Help with cell function[_2_]
This is very complicated!
I have 3 different spreadsheets that I need to link data from.
Sheet 1 is Active
Sheet 2 is Holding list
Sheet 3 is Non...
|
|
0 |
115 |
|
|
|
October 7th, 2009 03:09 PM
by CJCN
|
3 |
171 |
|
|
Segment and count birthdays by
Michael
Hello,
I have been given a list of members to our organisation and each has a full
birthdate attached, we would like to send them all an electronic birthday...
|
|
2 |
159 |
|
|
Linking w/Paste Special by
LFP
Hello,
I am trying to link a column in one spreadsheet to another spreadsheet.
When I initially copy and paste special everything copies over well and if I...
|
|
1 |
118 |
|
|
Macro message box. by
puiuluipui
Hi, i have this macro:
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If Sh.Name "SEARCH" And Sh.Name "PLANNING" Then
If Not...
( 1 2)
|
|
10 |
287 |