| Thread | Last Post | Replies |
|
| What is the best way to set up a ledger for a small business. Can. | 29 Oct 2004 23:28 GMT | 1 |
Can I also print invoices from the same ledger. I am a retired guy who does one off wood work projects. I would just like to keep track of my income and expenses by project.
|
| Rolling Cells? | 29 Oct 2004 23:16 GMT | 2 |
How can i make a form that each day the top cell disapears and a new bottom cell apears. I need a 30 day rolling form. I have 30 rows going from top to bottom. When i complete the data for the 30th row i would like for the first row to
|
| Pivot Tables and External Data | 29 Oct 2004 22:26 GMT | 2 |
I have created a Pivot Table based upon external data residing in an Access database. I wish to be able to email the Excel worksheet and the Access file to remote users so that they can use the Pivot Table as well. However, the Pivot Table seems to be using absolute references for ...
|
| No result! | 29 Oct 2004 21:19 GMT | 3 |
Hi , i have a query, sometimes the formula doesn't yield the result which it should, even simple things like =d2-c2. The result is "=D2-C2" while if i try it in some other cell or say other worksheet , it works fine!
|
| Formulas not calculating | 29 Oct 2004 21:08 GMT | 3 |
i avea quick question. i have formulas in cells. such as this in cell C1: =IF(A1="","",A1&"/ "&B1) but when i put a value in A1 it does not evaluate.
|
| Exact Match | 29 Oct 2004 20:39 GMT | 3 |
I have searched for an answer to no avail.. Here is the sheet: A1 N1 ID ID
|
| delinking | 29 Oct 2004 19:37 GMT | 2 |
There are misc. links in a spreadsheet that was just sent to me. How can I remove them without going through and deleteing the links manually, one by one. Thanks!
|
| pasting formulas into a selection | 29 Oct 2004 18:29 GMT | 3 |
I need to insert into cells some data. i have <x> amount of rows, and 5 columns Column1: blank Column2: blank
|
| merge to creat worksheets | 29 Oct 2004 18:04 GMT | 1 |
I have a workbook that contains two worksheets. Worksheet 1 has a list of names and various other pieces of information (related to the name, in the same row, just different columns) Worksheet 2 is a template of a form.
|
| Need help on this formula! | 29 Oct 2004 18:04 GMT | 2 |
I need help with a formula I'm trying to create. I have data in column but the data is scattered. For example, there will be a numbe in row 20 then it's blank until row 35, then blank until row 68, and s on.
|
| Newbie Excel question | 29 Oct 2004 17:41 GMT | 1 |
I need an Excel spreadsheet to track my running balance. I have it al laid out in Excel and it looks like this. Code -------------------
|
| LOOKUP question | 29 Oct 2004 16:55 GMT | 1 |
I am trying to perform a lookup. I have a table with lookup info to th left column. I have lookup information in column A. I am trying t match the info from column one of my table to Column A or the sheet an when found insert column 3 of my table. My sheet has old and new price
|
| Problems posting Ecel sheet - Regurading previous post attempt | 29 Oct 2004 15:39 GMT | 3 |
I had an excel sheet I was trying to post here, I can not seem to get it to post. (I can get a text file attachment vrigin or compressed to post, but not the excel spread sheet...virgin or compressed) Any suggestions?
|
| Pivot | 29 Oct 2004 14:37 GMT | 4 |
I have a pivot linked to a query with name of the client in the row items and sum of sales in the data items. It is sorted by sales. I'd like to show only the top and bottom 20 people. Is there a way to do it in the pivot?
|
| Linking multiple files | 29 Oct 2004 13:26 GMT | 1 |
I want to link multiple Excel files together and create a summary in a separate worksheet. All of the files are formatted exactly alike. I don't want to combine them into one worksheet because each sheet is needed on its own. Any suggestions?
|