Excel Discussion (Misc queries) - Page 549

Thread / Thread Starter	Last Post	Replies	Views
How can I sort hyperlinked cells? Midjack	by Midjack	0	395
VLOOKUP question Eugen	by Dave Peterson	2	419
Macros/vba Code mpsears62	by mpsears62	0	408
Dynamic named ranges - they don't seem to stick Barb Reinhardt	by John C[_2_]	2	448
Pivot table zero values R Ormerod	by R Ormerod	0	516
can you summarize differences between Excel 2000, 2003 & 2007? LSL	by [email protected]	2	1,011
highlight all repeat datas in a worksheet vcff	by vcff	4	483
Thinking about swtiching to Office Accounting JohnRusso	by Bob I	1	393
formulas dollars and formula % Wanna Learn	by Brad	7	434
Keep the ".00" for a number. Marie	by Marie	5	557
Assigning a point value to a range of numbers wmb	by John C[_2_]	2	2,465
Hide Rows or Coloumns using formulas Milind Keer[_2_]	by Bob I	5	490
XL Runtime error '429' message XL Baby	by Bob I	2	457
Deleting Visible Rows Confused	by Confused	4	873
Customise Date Format Gerry[_3_]	by Duke Carey	5	430
DATE VALIDATION William	by William	4	413
how can i fill data in blank cells after copying a pivot report? Antz	by M Kan	1	611
Generic Macro that can rows of zeroes Daniel	by Daniel	0	387
Creating a pivot table which resembles a SQL 'group by' [email protected]	by [email protected]	2	1,492
sizing cells/tables willy	by Duke Carey	2	416
Problem with shortcut 'Paste' Litter	by Dave Peterson	1	434
How do I bold face text1 but not others in a concatenate string? Jennifer	by Dave Peterson	1	1,063
Why do I not have an option to bracket negative values? PG Palmer	by Dave Peterson	2	482
Creating Macro to Unprotect and unhide Mandy	by Dave Peterson	2	993
conditional format to affect a different cell upsidedown_pw[_2_]	by Stefi	3	708
Filter RLB	by Jim Rech	1	356
How to delete a hundred range names at once? Dima	by Dima	4	624
Excel Chart - benchmark Ross12345	by Ross12345	0	1,149
VBA to compress photos in an excel worksheets John	by Gary''s Student	1	860
Excel Data Ranges Columns Richard	by Richard	2	576
Remove data from OLAP pivot table Joris Valkonet	by Joris Valkonet	0	656
=[Book.xls]Sheet1!A1 and not c:\blah\=[Book.xls]Sheet1!A1 Gaijintendo	by MartinW[_2_]	1	1,254
Covert 9 digits to 10 in excel Lisalala	by Stefi	2	1,481
Opening Lotus 123 Files in Excel 2007 Rob	by Rob	3	2,249
Pivot table not including new data Scopar	by Scopar	0	834
Vlookup- 5 values to be displayed in another column as different T Piotr (Peter)[_2_]	by Max	3	448
Is it possible paste to visible cells only? NeedToKnow	by NeedToKnow	2	702
Convert column of 4-5 digit whole numbers to 6? Professor_Higgins	by Rick Rothstein \(MVP - VB\)[_1040_]	3	5,188
How can I easily move to the next available cell in a column? Nonie	by Rick Rothstein \(MVP - VB\)[_1039_]	3	387
How to compare and extract data in two columns SK	by Max	1	977
SumProduct Help [email protected]	by Pete_UK	1	412
conditional formatting by color and asterisks rrupp	by Pete_UK	1	482
SEARCH WORKSHEET USING A NOT CRITERIA lghovden06	by Pete_UK	5	363
force to single column EngelseBoer	by EngelseBoer	4	322
How do I calculate a weighted average in a pivot table? suechndlr	by suechndlr	0	1,129
Letter represents a number JRD920	by M Kan	3	391
Excel: how to convert text to upper case upon entry? Doug Waters 03/03/08	by Gord Dibben	13	2,583
Microsoft Excel Ione	by Gord Dibben	3	314
I am having issue with excel file Brahama Kroma	by Brahama Kroma	0	414
I want to change the cell format (color) based on a calc mtnmanus	by T. Valko	4	2,290
drop down lists and formulas silverlining	by Karissa	2	381
Collapse grouped rows and columns on opening workbook Scott	by Scott	4	1,071
Merging cells? Richard[_8_]	by Bob I	1	329
Emailing a template and keeping same layout as the message body [email protected]	by [email protected]	0	411
"Unable to get the VLookup property of the WorksheetFunction class Ayo	by Ayo	4	3,554
How do i leave the arrow for the drop down list visible in Excel? Cara86	by Gord Dibben	2	1,619
How do I retrieve the NUM on the bottom right. It disappeared. Num Symbol	by Dave Peterson	1	360
How can I remove a password that was copied to a new workbook? ISU4EVER	by Dave Peterson	1	368
Border disappears in Print Preview & Print dbagby	by Jim Rech	1	3,391
The letter "b" appears after the dollar sign Fellow	by Ron Rosenfeld	7	608
Macro deleted ALL data!! Angel the Secretary	by Bill Sharpe	4	486
Time lapse to display in minutes Lynn	by Lynn	2	647
Delete rows Koz	by Gord Dibben	11	753
Data Importing RhysPieces	by RhysPieces	0	304
Row count help Pat Flynn	by Pat Flynn	0	273
Charts on a website Anthony Blackburn	by Anthony Blackburn	0	402
How can I make multple worksheet text all show in one box as a tot NavyGunner	by M Kan	1	439
printing different numbers of rows of results depending on user in ajmaschinot	by Duke Carey	1	407
Help with Editing and Reviewing Fomulars Nicko	by Duke Carey	1	356
Move or Copy Trung Quach	by Duke Carey	1	375
filtering the pivot table..! via135	by Jim Thomlinson	1	560
mixing up a list dkb43	by Gary''s Student	1	484
vba code on autofilter ub	by Gary''s Student	1	721
Floating block of cells at top of Spreadsheet Jim	by Tom Hutchins	3	1,265
Add service to Research Options Compare Values	by Compare Values	0	711