General Discussion - Page 6895

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Thread / Thread Starter	Last Post	Replies	Views
Merging data from Excel into Outlook by Big Chris Hi! I'm using the excellent code below (grabbed some weeks ago from this forum - thanks to those who wrote it!) and want to add another column of data to...	July 23rd, 2004 11:45 PM by Ron de Bruin	3	268
Compile Module Error (TBRun9) just won't go away by Danny Oberhaus Hi there, this error seems simple enough--but it won't go away. THE ERROR: "Compile error in hidden module: TBRun9" The error appears when I open or when I...	July 23rd, 2004 11:12 PM by Jim Rech	1	1,086
What function can I use to remove a space between text and numbers by kate The Trim function does not work. I tried reformatting the cell to all text, but it still won't remove the space between the letter and the number. Thanks	July 23rd, 2004 10:15 PM by Gord Dibben	3	418
Merge Worksheet Columns by Jeff Please, how do I merge columns from two worksheets? Example: Worksheet 1 Worksheet 2 List Data1 List Data2 1 600 ...	July 23rd, 2004 09:14 PM by Frank Kabel	4	557
Which data occurred in a certain month by Brandy I have a list of events over a period of time and want to know which ones occurred in the month of July only. Any ideas? Thanks.	July 23rd, 2004 09:13 PM by Frank Kabel	6	209
Circumventing Data Validation by Jim & Gail Here's my dilemma... B17 is formatted as General with no data validation settings. C17 is formatted as Text, with a validation setting for text length...	July 23rd, 2004 09:07 PM by Frank Kabel	1	375
how to keep cell rounding to 2 places even when someone else pastes number with more. by flyers2thecup At work, i receive spreadsheets of bonuses that can be derived from a formula. however, when i copy and paste the info into our file for payroll, it can only...	July 23rd, 2004 09:03 PM by AlfD	6	353
Need macro to print sheet with multiple repetitions by bill_s1416 I have an excel-based sales report with charts, etc. The territory number in cell A1 determines the data that populates the tables and charts. When the user...	July 23rd, 2004 08:55 PM by Ron de Bruin	3	588
Still needing help with the date by Brandy Thought I would repost to make it easy. I'm looking for help with determining which data only occurred in the month of July, but my date format must remain...	July 23rd, 2004 08:24 PM by Peo Sjoblom	3	181
Entering Data in a Cell While Maintaining the Formula by wiley How do I enter data in a cell without loosing the formula? I have tried unlocking the cell and protecting the sheet with the "allow user to...select unlocked...	July 23rd, 2004 08:15 PM by Lady Layla	3	384
Display Date by annoyed I am trying to display a date with a certain format: xx/xx representing month\year. How can I do this in Excel 2000?	July 23rd, 2004 08:09 PM by Lady Layla	9	163
Align numbers to take up equal space by basic I am trying to align the numbers in an excel spreadsheet so that a 1 takes up the same amount of space as a 0. When I align my numbers now, each character...	July 23rd, 2004 06:51 PM by Debra Dalgleish	2	466
Autofilter cells containing wild card characters by dcullen Hi I am using an Excel 2000 spreadsheet in which I want to use an auto filter to analyze the data on the sheet. The sheet is populated from a database extract...	July 23rd, 2004 06:11 PM by ElsiePOA	2	317
MS Query - change parameter with Excel cell by emea training 2 I have an Excel file which links to our database via ODBC and Microsoft Query. The Excel file contains a graph of sales figures which I have set to refresh...	July 23rd, 2004 05:56 PM by Debra Dalgleish	6	975
Merging by gary Cells A1..H65000 contain data. Block #1 (A1..H32000) contains data related to various part-numbers. Block #2 (A32001..H41000) contains data related...	July 23rd, 2004 05:32 PM by	1	147
Worksheet button moves when printing by Clint Schwartz I have a worksheet with a vba button on it to execute code. Everytime I print or print preview the sheet, my command button moves all the way to the left of...	July 23rd, 2004 05:24 PM by Ron de Bruin	1	193
Dynamic Cell Range by theillknight I want to use the index() function, but the size of my data continuously changes. I'm pretty sure I'll have to use some variation of the indirect() function,...	July 23rd, 2004 04:31 PM by theillknight	0	262
Conditional Cell Formatting by Andrew Mackenzie Please help if you can. I have an Excel spreadsheet containing credit ratings from Moody's which are styled Aaa, Aa1, Aa2, Aa3, A1, A2, A3, Baa1, Baa2, Baa3,...	July 23rd, 2004 04:06 PM by Andrew Mackenzie	9	333
Alignment in text box by kerryzanne I understand I can align text in a cell by: FormatCellsAlignmentOrientation. Is there a way to do this in a Text Box? Thanks.:confused: --- Message...	July 23rd, 2004 03:33 PM by	1	135
indirect function problems by camron107 i have a formula which works fine... =HYPERLINK(("\\Gscc1\Rugby\Registration\Databases\Signatures\" &TEXT('Organisations A-F'!J10,"00000"), "Signature...	July 23rd, 2004 01:55 PM by camron107	5	272

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed