Excel Discussion (Misc queries) - Page 549

Thread / Thread Starter	Last Post	Replies	Views
How can I sort hyperlinked cells? Midjack	by Midjack	0	413
VLOOKUP question Eugen	by Dave Peterson	2	451
Macros/vba Code mpsears62	by mpsears62	0	428
Dynamic named ranges - they don't seem to stick Barb Reinhardt	by John C[_2_]	2	466
Pivot table zero values R Ormerod	by R Ormerod	0	535
can you summarize differences between Excel 2000, 2003 & 2007? LSL	by [email protected]	2	1,043
highlight all repeat datas in a worksheet vcff	by vcff	4	495
Thinking about swtiching to Office Accounting JohnRusso	by Bob I	1	414
formulas dollars and formula % Wanna Learn	by Brad	7	450
Keep the ".00" for a number. Marie	by Marie	5	566
Assigning a point value to a range of numbers wmb	by John C[_2_]	2	2,492
Hide Rows or Coloumns using formulas Milind Keer[_2_]	by Bob I	5	517
XL Runtime error '429' message XL Baby	by Bob I	2	476
Deleting Visible Rows Confused	by Confused	4	906
Customise Date Format Gerry[_3_]	by Duke Carey	5	446
DATE VALIDATION William	by William	4	432
how can i fill data in blank cells after copying a pivot report? Antz	by M Kan	1	639
Generic Macro that can rows of zeroes Daniel	by Daniel	0	406
Creating a pivot table which resembles a SQL 'group by' [email protected]	by [email protected]	2	1,541
sizing cells/tables willy	by Duke Carey	2	441
Problem with shortcut 'Paste' Litter	by Dave Peterson	1	468
How do I bold face text1 but not others in a concatenate string? Jennifer	by Dave Peterson	1	1,083
Why do I not have an option to bracket negative values? PG Palmer	by Dave Peterson	2	506
Creating Macro to Unprotect and unhide Mandy	by Dave Peterson	2	1,017
conditional format to affect a different cell upsidedown_pw[_2_]	by Stefi	3	728
Filter RLB	by Jim Rech	1	380
How to delete a hundred range names at once? Dima	by Dima	4	663
Excel Chart - benchmark Ross12345	by Ross12345	0	1,167
VBA to compress photos in an excel worksheets John	by Gary''s Student	1	881
Excel Data Ranges Columns Richard	by Richard	2	594
Remove data from OLAP pivot table Joris Valkonet	by Joris Valkonet	0	676
=[Book.xls]Sheet1!A1 and not c:\blah\=[Book.xls]Sheet1!A1 Gaijintendo	by MartinW[_2_]	1	1,321
Covert 9 digits to 10 in excel Lisalala	by Stefi	2	1,506
Opening Lotus 123 Files in Excel 2007 Rob	by Rob	3	2,268
Pivot table not including new data Scopar	by Scopar	0	874
Vlookup- 5 values to be displayed in another column as different T Piotr (Peter)[_2_]	by Max	3	464
Is it possible paste to visible cells only? NeedToKnow	by NeedToKnow	2	731
Convert column of 4-5 digit whole numbers to 6? Professor_Higgins	by Rick Rothstein \(MVP - VB\)[_1040_]	3	5,258
How can I easily move to the next available cell in a column? Nonie	by Rick Rothstein \(MVP - VB\)[_1039_]	3	408
How to compare and extract data in two columns SK	by Max	1	1,005
SumProduct Help [email protected]	by Pete_UK	1	422
conditional formatting by color and asterisks rrupp	by Pete_UK	1	499
SEARCH WORKSHEET USING A NOT CRITERIA lghovden06	by Pete_UK	5	385
force to single column EngelseBoer	by EngelseBoer	4	340
How do I calculate a weighted average in a pivot table? suechndlr	by suechndlr	0	1,156
Letter represents a number JRD920	by M Kan	3	397
Excel: how to convert text to upper case upon entry? Doug Waters 03/03/08	by Gord Dibben	13	2,613
Microsoft Excel Ione	by Gord Dibben	3	333
I am having issue with excel file Brahama Kroma	by Brahama Kroma	0	438
I want to change the cell format (color) based on a calc mtnmanus	by T. Valko	4	2,310
drop down lists and formulas silverlining	by Karissa	2	426
Collapse grouped rows and columns on opening workbook Scott	by Scott	4	1,105
Merging cells? Richard[_8_]	by Bob I	1	345
Emailing a template and keeping same layout as the message body [email protected]	by [email protected]	0	435
"Unable to get the VLookup property of the WorksheetFunction class Ayo	by Ayo	4	3,622
How do i leave the arrow for the drop down list visible in Excel? Cara86	by Gord Dibben	2	1,666
How do I retrieve the NUM on the bottom right. It disappeared. Num Symbol	by Dave Peterson	1	377
How can I remove a password that was copied to a new workbook? ISU4EVER	by Dave Peterson	1	384
Border disappears in Print Preview & Print dbagby	by Jim Rech	1	3,392
The letter "b" appears after the dollar sign Fellow	by Ron Rosenfeld	7	620
Macro deleted ALL data!! Angel the Secretary	by Bill Sharpe	4	513
Time lapse to display in minutes Lynn	by Lynn	2	675
Delete rows Koz	by Gord Dibben	11	778
Data Importing RhysPieces	by RhysPieces	0	324
Row count help Pat Flynn	by Pat Flynn	0	286
Charts on a website Anthony Blackburn	by Anthony Blackburn	0	416
How can I make multple worksheet text all show in one box as a tot NavyGunner	by M Kan	1	451
printing different numbers of rows of results depending on user in ajmaschinot	by Duke Carey	1	433
Help with Editing and Reviewing Fomulars Nicko	by Duke Carey	1	360
Move or Copy Trung Quach	by Duke Carey	1	393
mixing up a list dkb43	by Gary''s Student	1	547
filtering the pivot table..! via135	by Jim Thomlinson	1	593
vba code on autofilter ub	by Gary''s Student	1	745
Floating block of cells at top of Spreadsheet Jim	by Tom Hutchins	3	1,291
Add service to Research Options Compare Values	by Compare Values	0	726