| Thread | Last Post | Replies |
|
| Printing Individual Tabs to .pdf | 18 Sep 2009 17:00 GMT | 1 |
A report I publish monthly contains many tabs that need to be saved as individuals .pdf files. Currently, Adobe and Excel are printing several tabs to one file. Does anyone know how to accomplish this task? My current method is to
|
| Changing Find settings | 18 Sep 2009 16:59 GMT | 3 |
The default settings for my system are : within sheet, search by rows, lookin formulas. Is there any way to set the default to be: within workbook, search by columns, lookin values?
|
| emailing files from excel, the files will not go until I open up . | 18 Sep 2009 14:12 GMT | 2 |
emailing files from excel, the files will not go until I open up MS Outlook. Only then will the file go. I have waited for 30 minutes and more and the file will not go. IN offices 2000 I never had this problem. any ideas
|
| Comparing two rows | 18 Sep 2009 12:47 GMT | 4 |
I have a list of about 15,000 items, one per row. The details of each item are in columns A to I. I need to find those rows where ALL the entries in cols A to I are the same as in the following row.
|
| How can I reference a cell using a variable? | 18 Sep 2009 11:26 GMT | 3 |
How can I reference a cell using a variable? Example: Sub Help() For x = 3 To 7
|
| sorting by last char | 18 Sep 2009 09:13 GMT | 3 |
I have a table where in a column there is something like: 1a, 1b, 1c, 2a, 2b, 2c and so on I wish to sort by the last char to look like: 1a
|
| Importing a csv file into an Excel | 18 Sep 2009 09:00 GMT | 1 |
I have the following content into a notepad which I am trying to import into a spreadsheet. When I chose the default options (Delimited, Tab as the Delimiter, General column data format) it putting each line into a single column instead of putting each field
|
| Vlookup not working where lookup value contains an apostrophe | 18 Sep 2009 08:09 GMT | 2 |
Column A contains a list of names including O'Brien. Column B contains the result of a vlookup which uses the names in column A as the look up value. ie Column B2 contains the formula =vlookup(A2 ... The Array table is on a separate sheet within the workbook.
|
| match & combine 2 zip code lists and dollar amounts | 17 Sep 2009 22:08 GMT | 2 |
I have one worksheet with a large list/column of zip codes, column of dollar amounts and a column of counties. i have another wksheet with a shorter list of zip codes (some duplicates & some new to the first wksheet) and a column of dollar amounts... i want to match/combine the ...
|
| Reading Vista files from XP | 17 Sep 2009 21:50 GMT | 10 |
We have just started receiving Excel files from others that were created using a MS Vista version of Excel. The file extension is XLS. When we try to open the files using our XP version of Excel, the program crashes.
|
| Excel problem | 17 Sep 2009 20:22 GMT | 2 |
Okay I have a speadsheet that goes like this A b GA 76876 GA 87798
|
| Average for the last n values of a list that changes everyday | 17 Sep 2009 19:40 GMT | 6 |
I am needing some help whit this I have this list A B 1 Date Value
|
| Database in Excel | 17 Sep 2009 18:16 GMT | 2 |
Would anyone be able to give a little advise? I am trying to make a database in Excel, due to License restrictions (and cost), Excel is the only program we have a site license for. The database needs to be able to hold regions of data, which will show
|
| Footers/Headers Not Printing | 17 Sep 2009 17:50 GMT | 2 |
The footer and header are showing on the worksheets in preview but not on the printout. Is there a feature that needs to be turned on/off?
 Signature CM
|
| Data Valid - refers to the values of 2 cells | 17 Sep 2009 16:11 GMT | 5 |
How would I insert in my input box of data validation the values of cells D6 and F4 basically if the user clicks on a cell F6 I want it to reference f4 and d6 if they are in cell f8 I would like it to reference f4 and d8
|