TheMSsForum.com: The Microsoft Software Forum
TheMSsForum.com
The MSS Forum
‹
Archive Home
‹
Excel Misc Archive
‹
Page 56
Archive
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
view full version:
back to formated view
19251:
How do I alpabetize the "Recent Document" list
19252:
Editing a workbook at the same time
19253:
can't copy/paste the formula
19254:
Excel 2007 Office Button
19255:
SUM & SUMIF formula problems
19256:
nested if
19257:
Posting Questions
19258:
VLOOKUP and multiple matches
19259:
Cancel opening messages/phantom link issue
19260:
Limit to string length in search@replace?
19261:
How do I put data in excel in placing order? eg first, second, th.
19262:
Combobox
19263:
Custom sorting
19264:
Mapping Coded Users and Corresponding Coefficients
19265:
Inserting Cells and Formula References
19266:
Run Macros from an IF statement within a formula
19267:
Copy excel data (inc. textbox data) into Word
19268:
pulling data color using vlookup
19269:
Paste Special?
19270:
copy color using vlookup
19271:
Formula in Header
19272:
Click and drag locked cells, can this be done?
19273:
Moving with in an EXCEL program
19274:
cell formats
19275:
My arrow keys won't move between cells only rows & columns
19276:
pivot table
19277:
Need count of unique devices for each event type
19278:
Track changes on a workbook
19279:
Usings Text fields in a Pivot Table
19280:
command button that copies and pastes from one list box to another
19281:
Showing Custom file properties in Header
19282:
sum a range if two conditions are met
19283:
Warnings
19284:
Text in 2007
19285:
How do I mail merge 2nd sheet of an excel sheet?
19286:
How do i perform calculations on filtered data
19287:
formula locates common data in a cell and drops them in other shee
19288:
Copy down to next Cell
19289:
I want to format text within a cell with color in Excel
19290:
Formula to pick out common parts of a cell and drop them in new sh
19291:
How to update a price list with another price list from another sh
19292:
cannot use formula to link to another sheet
19293:
Cell Reference Question
19294:
Get Data From Diferent Sheets
19295:
Opening view
19296:
Lookup/match formula?
19297:
Conditional format order priority
19298:
text filtering formula???
19299:
Data Validation
19300:
HOW DO I KEEP THE FUNCTION BOX OPEN ALL THE TIME IN EXCEL?
19301:
Properties dialog box opens instead of a workbook
19302:
More Assistance Needed with Pivot Tables
19303:
Pivot Table Data Field Option
19304:
Minimum Date Greater Than Observation Start Date
19305:
Totaling Time (Text)
19306:
need to select the next row every time a CommanButton is pressed
19307:
Excel + MS Query + table definition caching
19308:
SUM up diferences with a criteria
19309:
Number of days between days
19310:
Date
19311:
Delete Custom Formating when Excel sheet is Lock.
19312:
help! custom colour palette in excel 2007
19313:
working around errors - simplified
19314:
=MIN() Function
19315:
how do I use letters to link instead of numbers
19316:
Combo box problem
19317:
retrieving data from variable workbooks
19318:
Run in Minimised Window
19319:
Invoice due; Payment terms
19320:
Auotofilter problem!
19321:
Combining Rows from different workbooks...
19322:
= cell in another worksheet
19323:
Need A Macro To Copy Previous Tab to New Tab
19324:
IsItPossibleToHaveEnteredTextAutomaticallyAppearInAnotherCell/Wrks
19325:
datafilter Excel 2007
19326:
Combining data from Excel with Outlook address book to mail bills
19327:
Formulas
19328:
Title bar is missing maximize, minimize, close
19329:
would this be an if statement?
19330:
how can I show a flashing symbol in an Excel sheet?
19331:
scroll bar within a cell
19332:
sumif formula doesn't add up
19333:
recovering info
19334:
Center on colon
19335:
SSIS package converting int's to text in Excel
19336:
Validation numeric and text
19337:
Text Import Wizard - Changing number format
19338:
Date and time but date not wanted
19339:
An Interesting vba Excel quirk
19340:
is there a way to delete all characters to the right of a ":"?
19341:
If, And, Or Formula
19342:
Can I do this...and if so...HOW!?
19343:
Temporary Array i.e. match "this" and return entire row
19344:
Getting data from different worksheets in another workbook
19345:
Mail Merge
19346:
drop down menu ( list)
19347:
Decimals rounding up
19348:
Look up list of values based on single value from pick list
19349:
time calculations
19350:
Median
19351:
How to find SUM when you already have the range?
19352:
Hidden Columns
19353:
Formula Problem
19354:
Inserting check boxes
19355:
Trying to unprotect Checkboxes
19356:
Incrementing a form
19357:
extracting embedded photos...
19358:
Why is range outlined in blue?
19359:
Design Mode - or something like it.
19360:
Automatically disable macro's on new doc
19361:
#VALUE! error in master when linked sheets aren't open?
19362:
Remove initial from end of name
19363:
Date/Time Format Problem
19364:
no responses...
19365:
UDF To Calculate Work hours between two dates Problem with code
19366:
Maintaining Formulas
19367:
#NA error
19368:
Defining Font Size in VBA
19369:
Excel 2003 - How to delete Custom Formating when Excel sheet is Lo
19370:
Increment numbers part of text
19371:
Using code in Excel
19372:
Sorting linked worksheets
19373:
zenana
19374:
Copy Data from another sheet
19375:
Difference between Subtotals and Grouping
19376:
Microsoft Excel Cell text limits
19377:
How do i include the contents of a spreadsheet cell in the footer?
19378:
Last Saved Date in Footer (right aligned)
19379:
Radio Buttons in a drop down list
19380:
How do I use the Count function for data in every other column?
19381:
Overview usage named ranges
19382:
sumproduct?
19383:
Need help on on managing information on merged cells
19384:
Vlookup
19385:
Centering a picture in a worksheet
19386:
Time Format
19387:
how to analyze data?
19388:
ComboBox Toolbar
19389:
On system start automatically open Excell and the a specific weork
19390:
Scrollbars in Listbox
19391:
How do I send an Excel 2007 workbook to an Outlook Exchange folder
19392:
Copy without formatiing
19393:
display names of defined cells
19394:
how do i export *.doc file to *.xls file
19395:
How to get the data of top cell ???
19396:
Time Stamp in Excel Mobile, Windows Mobile 5.0
19397:
how to sum up a range of formulas?
19398:
extract name
19399:
Indenting numbers from the right side of a cell
19400:
Clear Comment problem
19401:
why can unicode and alt+x not work on my excel
19402:
Expanded Matrix in Excel
19403:
Changing border colors instantly
19404:
Curser Highlight
19405:
How do you create a running countdown that continually runs?
19406:
Can someone tell me how to enter a long latitude on an excel data
19407:
SUMPRODUCT help
19408:
formatting cells
19409:
Function Question
19410:
Project-like calendaring for Excel
19411:
How can I save a file as a template?
19412:
.Copy Destination:= << Forget when PasteValues is desired
19413:
address function
19414:
Timer Update
19415:
Formatting
19416:
Formatting cells
19417:
Charts-Target Lines
19418:
Charts-Formatting
19419:
Form Buttons
19420:
Code to find code
19421:
Show / hide data by seeing if a field says "Yes"
19422:
Display minutes more than 60
19423:
excel
19424:
How do I convert Digit Number to Text in Excel ?
19425:
Coma Separator in Numbers
19426:
MCT Needed
19427:
Scroll Lock ?
19428:
What are default settings for Word and/or Excel options?
19429:
Pivot Table refresh and calculated item disabled
19430:
increase number of items shown in drop down list?
19431:
Open Excel 2003 file in Excel 2007
19432:
How do you set Excel 2007 to open files in a specific folder?
19433:
selecting multiple items in an excel drop down list
19434:
import formatted text
19435:
Cursor Movement in Excel 2000 V9.0.3821 SR-1
19436:
I cannot find an error in excel
19437:
Data Validation Question
19438:
Adding to an amount in a cell
19439:
Ambiguous worksheet change
19440:
Cells may look "empty" when quickly scrolling up or down
19441:
How to tally words in Excel?
19442:
CF
19443:
Can vlookup be used to retrieve multiple matches
19444:
save worksheet to a folder
19445:
Form button - 2007
19446:
how to: have something equal Cx where x=8+ C4
19447:
Excel - What is ^ in a formular? ie +(p23)^.5
19448:
excell spread sheet
19449:
Form buttons vs. ActiveX Buttons
19450:
Easy question
19451:
Receiving run-time error only part of the time
19452:
Inserting pictures in Excel 2003
19453:
Deselect (Unselect) Cells
19454:
Excel query
19455:
When is a cell empty and how do I empty it.
19456:
Database
19457:
Can't print only borders. I want a grid sheet no words
19458:
Selecting list to populate combo box
19459:
formulas
19460:
filter by a date in a cell
19461:
Chop off the last seven characters in a column
19462:
Excel 2000 Printing
19463:
Can you embed a worksheet in another worksheet?
19464:
Conditional Formatting and Entering Dates with out dashes
19465:
Data "whites out" until you page up and down
19466:
Security Alert Window Excel 2007
19467:
Filter by a Date that link to a cell
19468:
Filter by a Date that link to a cell
19469:
Cell selection no longer shades cells
19470:
Customized Macro Button Check
19471:
printing multiple selected rows
19472:
Excel - Dual Monitors - A trick that works
19473:
creating a range reference from cell values
19474:
Data Validation Using "IF" Function?
19475:
Sensitivity Analysis to 2 variables
19476:
Auto filling cells in a column
19477:
Multiple results in Vlookup
19478:
How do I connect a cell reference to a picture?
19479:
Excel and Pivot Tables
19480:
creating lists of permutations
19481:
Strange "IF"?
19482:
Zipping my Excel Files and maintain the folder structure
19483:
the row has disappeared and it's not hiding
19484:
Anyone else have any ideas??
19485:
Office 2007 Excel
19486:
Color Outline of Formula Cells
19487:
How to select a listed item?
19488:
How to stop a recurrent circular reference error message ?
19489:
Military Time Conditional Format
19490:
Sorting numbers in a row from small to large
19491:
Excel search function
19492:
Updating Daily with excel spread sheet
19493:
XIRR
19494:
IF question
19495:
Combo box problem
19496:
Hidden column
19497:
Annualizing Monthly Performance - pivot tables? other formulas?
19498:
Excel 2007 queries
19499:
Adjust cell values without a formula or temporary cell
19500:
R/T 438 - Why?
19501:
Cell with a certain value to go to...
19502:
Excel2007 Pivot Table problem
19503:
IMPORT EXPORT AUTOCORRECT LIBRARY
19504:
Count transactions below a threshold
19505:
how to open and remove passwords in bulk
19506:
Traditional-Simplified Chinese conversion in Excel 2007(Eng versio
19507:
Getting source data range in multiple pivot tables
19508:
Linking Cells
19509:
Formating Dates
19510:
How to plot graph (newbie)
19511:
Linking cells into empty cells in another worksheet
19512:
Excel 2003 - Comments and cell labels
19513:
Compare 4 columns and copy
19514:
Pausing a macro
19515:
3 cells into 1 date?
19516:
compare Excel workbook column to another find same info
19517:
Excel formula needed... regular expression?
19518:
Date with CF
19519:
Attempting to sort unique/only count first record in each unique g
19520:
Collating/ Summarising worksheets
19521:
Return value of a non blank cell
19522:
Help with complicated(?) Range
19523:
Excel 03 - Send Attachment (can't minimize Outlook window)
19524:
pop up box reminder
19525:
conditional formatting for multiple sets of conditions
19526:
Measuring growth-how much did revenue increase using 12 months of
19527:
how to review different scenarios in one screen
19528:
Remove Trailing Apostrophe
19529:
Sumproduct question
19530:
Excell Worksheet
19531:
Date -Month/day/year
19532:
Count if two arguments met
19533:
pivot table creation in shared worksheet
19534:
Data Validation
19535:
percentages of counts
19536:
Text Box problem
19537:
How can you paste a spreadsheet from Excel without gridlines?
19538:
Why do I get invalid data source when creating a pivot table?
19539:
Date function
19540:
Send to mail recipient error
19541:
Navigate to an item in pulldown by typing first couple of letters
19542:
Another code question
19543:
Excel Speadsheet GONE!
19544:
Why cant I....
19545:
auto complete only for one row down?
19546:
INDENT TEXT IN A CELL
19547:
How to stop the circular reference message from reappearing
19548:
Create a list in a drop down dependent upon another dd list in exc
19549:
resequence with a prefix
19550:
Return Unique Records ... No Blanks
19551:
Copy Paste Values - Entire Workbook and Save
19552:
Template Wizard Excel 2007
19553:
Data Validation Query
19554:
Form scrolling
19555:
Hiding Data
19556:
Base amount
19557:
Printing Rows
19558:
Copying a worksheet to another workbook
19559:
AppName: excel.exe AppVer: 10.0.6832.0 ModName: excel.exe ModVer: 10.0.6832.0 Offset: 0006e3fc
19560:
copying & averaging formulas
19561:
Text in same cell
19562:
to Anne and others who do not put info in the message section
19563:
How to Periodically Store/Save Excel DDE Values
19564:
Can you combine tables (represent a "join") in Excel?
19565:
Is there a way to make the home key always go back to same cell?
19566:
filter using today()
19567:
Is there a simple bank reconciliation form?
19568:
Formulas in excel 2007
19569:
Control Order of Calculations
19570:
Cant Send Email Attachment
19571:
Weekdays only!
19572:
Help with macro PLEASE
19573:
Number Format not working
19574:
tough lookup question
19575:
How do I combine filtered data from one worksheet to another?
19576:
For Each in VBA
19577:
Ignore UPPERCASE
19578:
Blanks at end of worksheet
19579:
Turn of spell checker in Excel
19580:
Converting time
19581:
Multiple Data Validations
19582:
Working out other people's profit margins with Excel
19583:
PASTE LINK FROM HORIZONTAL CELLS TO VERTICAL CELLS
19584:
Unable to update linked files
19585:
numeric data with restriction of data length
19586:
Find & Replace 1st Entries Not Being Saved
19587:
Duplicate cells
19588:
Formating into date and time
19589:
convert $10.20 to text ...Ten Dollars &20/100
19590:
Buttons
19591:
VLookup VS SumProduct
19592:
Keyboard shortcut for name box
19593:
Copying formulas from Excel 2003 to Excel 2007
19594:
Percentages in pie chart
19595:
Graphic Images: Can I Put One in a Cell as Mouse Rollover Only?
19596:
I want to add ASAP Utilities in the Tool Bar. I am using Excel 20
19597:
Pictures
19598:
Extract two letters
19599:
Cell references in a countif function?
19600:
Record Macro Excel 2007