| Thread | Last Post | Replies |
|
| Creating a Proposal | 14 Nov 2007 23:49 GMT | 4 |
I am trying to create a proposal for our company. Sometimes the proposal will be 1 page and other times it may be 2 or more pages. On the last page of the proposal at the bottom (however many pages) I must have some legaleze that exceeds 255 characters which is the max for ...
|
| Printing a workbook but not getting page set-up results | 14 Nov 2007 23:46 GMT | 1 |
When I print an entire workbook in Excel it prints everyting in portrait style when I have both portrait and landscape page set-ups in the workbook. I have several worksheets that I have defined in page set-up to print landscape but they always print portrait style. If I print ...
|
| Excel - VBA - workbook/worksheet navigation | 14 Nov 2007 23:18 GMT | 1 |
I'm having some basic difficulty nagivating through books and sheets. I am in a workbook and intending on copying and pasting a couple of pages form another wookbook into this workbook. Using "GetOpenFilename" I identify and subsequently open a workbook. Copy
|
| HELP ON VLOOKUP | 14 Nov 2007 23:04 GMT | 6 |
I have made a form and inserted VLookups. In my list of products there is more than one of that product name but different sizes. So it looks like this: Product name Item # Discription Unit of measure Buccaneer Plus #00521 2x2.5ga ju ga
|
| Formating Date problem | 14 Nov 2007 22:58 GMT | 2 |
I have Excel 2007. When I type 1/2 in a cell it turns into 2-Jan and if I click on it, it turns into 1/2/2007. I tried to Format Cell and chose Text and other options, but it returns into 39084. Is there any way to turn this thing off.
|
| Create time value from number | 14 Nov 2007 22:47 GMT | 2 |
I have a column of numbers that I would like to turn into a time value. Example the number 1520 would be 15:20. I've been thru the functions but can't find what I want. Can anyone help?? Thanx
|
| %s in XL entered as ".5" OR "50" reads as 50% if format is %age. | 14 Nov 2007 22:37 GMT | 12 |
I have a spreadsheet I work with every day and I use fractional percentages, between 0-1%. If the field is formatted as Percentage, and I type in ".5", it reads it as 50%, which it would be if it weren't a percentage. But it is. It's a half percent. By typing in "50", I also get ...
|
| How to generate a list from a table | 14 Nov 2007 22:17 GMT | 1 |
I have a table in a worksheet that looks like this. Yes No Item 1 0 8 Item 2 2 6
|
| Excell spread sheet | 14 Nov 2007 22:08 GMT | 3 |
all I want is to add columns on an excell spread sheet: example 4b+5b+7b+8b=9b
|
| Merging rows based on column value | 14 Nov 2007 22:03 GMT | 2 |
I have an interesting problem. I have the data in the following format: a1|b1|c1|d1|__|__| a1|b1|__|__|e1|f1|
|
| Lookup all values on next tab | 14 Nov 2007 21:54 GMT | 1 |
Suppose I have some data and an if function in Column A. The If function returns a "Yes" if 4 sets of criteria are met. If on another tab I want to import all data with Yes in the A column into the new tab and I do not want spaces between rows.
|
| Worksheets | 14 Nov 2007 21:31 GMT | 2 |
What is the maximum number of worksheets you can have in a workbook? Thank you.
|
| how do i make values increase by 1 while going down a cell | 14 Nov 2007 21:29 GMT | 2 |
I enter in numbers in a column and i want to drag the box down and have the number increase by one from the previous number in each cell. HELP!
|
| Leading Zeros | 14 Nov 2007 21:28 GMT | 2 |
I have a list of 1300 UPC's that I need to bring into Excel. The original list is in SQL. I know the tricks of formatting a cell as TEXT or Custom to the # of characters in your data, but if/when I do that, and I go to SQL and copy the data, then go to Excel and paste it in, the ...
|
| Excel 2003 - VBA - AutoExecute | 14 Nov 2007 21:26 GMT | 2 |
Apologies. I seem to have lost track of a solution already in hand, so I have to ask again. Upon loading a prepared workbook, I would like a macro to auto execute setting up some of the preliminaries in preperation for a session.
|