| Thread | Last Post | Replies |
|
| Update Values from a Userform | 29 Oct 2007 19:03 GMT | 1 |
I'm trying to update some information in ms access from a useform in ms excel. My problem is that I don't known how to do for the vba code understand the values in my form... This is the code:
|
| Log changes to Excel file | 29 Oct 2007 18:14 GMT | 3 |
Is there any way to keep a track of changes made to an Excel file? I need to make a file that is open for changes to several people. But, I need to keep track of who changes what when. My ideal is to have a kind of logfile that keeps track of the user,
|
| Excel macro for cell merge | 29 Oct 2007 15:59 GMT | 1 |
I used to use Lotus 123 when I was working ages ago. I have Excel 97 and know next to nothing about using it. I have imported my checking account records for one year into an Excel worksheet. The first column is called Post/Tran and there are
|
| Return subset to drop down box | 29 Oct 2007 15:28 GMT | 3 |
I work at a production plant. We have 3 shifts. I have a workbook to track production. On the opening sheet of the workbook I would like each supervisor to input which shift (1, 2, or 3) they are inputting data for via drop
|
| Extracting email addresses from spreadsheet | 29 Oct 2007 13:49 GMT | 1 |
I have a spreadsheet that has a column that is a series of email addresses. The names show up when I look at the spreadsheet but they are linked to the email address. Is there a simply way to make a distribution list from this spreadsheet?
|
| Prevent formulas changing when moving value | 29 Oct 2007 12:06 GMT | 3 |
Since my place of work moved to Excel 2007 I regularly run into this kind of problem. I am filling in a timesheet with columns for monday-friday (columns D to H). There is a total column at the end (I). The formula in the total column is
|
| Formula Query | 29 Oct 2007 11:44 GMT | 2 |
I am using a formula to count the number of occurances of an entry - in an ever expanding list of data. The formula that I am using is as follows: =COUNTIF(ActualWeight,">=20")-COUNTIF(ActualWeight,">29")
|
| Can't insert rows - "Cannot shift object off sheet" | 29 Oct 2007 11:15 GMT | 1 |
I am using Excel 2007 and have just loaded a spreadsheet created in a previous version which is running in Compatibility mode. When I try to insert a row I get an message "Cannot shift objects off sheet". How do I insert rows on this sheet? No problem with another workbook ...
|
| Excel add-ins - "xla could not be found" - stop message | 29 Oct 2007 02:59 GMT | 2 |
Recently I started using Excel add-ins (xla files) -- which I have found very handy. For example, I have an add-in that can add a contents page to my workbook, or the list the file contents of a folder, etc. The trouble is, if someone, who doesn't have same xla
|
| Excel 07 - Failure to Open Correctly | 29 Oct 2007 02:33 GMT | 10 |
I have the same problem with Excel 07 on Vista and it is becomming more frequent. When you start the application a blank window appears without the normal Excel header bar, but with an out-of-focus top bar with 3 icons where you can display a different magnification of the blank ...
|
| Indirect and Concatenate to return Names | 29 Oct 2007 02:20 GMT | 3 |
I had another post which was very gratefully answered concerning the use of INDIRECT to return a list of employees who work on a user- chosen shift in the form of a list box. Now I am wondering if the employees names are broken up into FirstName
|
| How Do I Access Office 2003 Programs after I Upgraded to Office 2007? | 28 Oct 2007 23:07 GMT | 2 |
I had a need for accessing Access 2003 and Excel 2003 after I upgraded to the 2007 versions of the programs. I'm sure there must be something to allow me to do so, where did the upgrade entirely erase/delete what is now an obsolete program? Is not the data and programs I need, ...
|
| finding pivot table base data | 28 Oct 2007 21:40 GMT | 1 |
I have been forwarded an excel sheet which contains many tables. However, the tables have similar headings. It also has a couple of pivot tables. My problem is that I want to know on which particular sheet of data a particular pivot table is based on. Is there a way to find out? ...
|
| Sorting/Locking Header | 28 Oct 2007 21:32 GMT | 7 |
I am trying to be able to sort and not have my header sort with it. I want the header row to be locked. I've used the excel help where it says to click Data, Sort, then My Data has Header Row. I then click ok. But, then it defaults back to No Header Row. How do I make it ...
|
| sum if | 28 Oct 2007 21:29 GMT | 3 |
I want to add the values from cell A1 to A6. However, if any values is greater 8, I must minus .5, then add them. If they not greater 8, then just add them to the total. How do I do this in an sum if statement?
|