| Thread | Last Post | Replies |
|
| Macro example | 05 Jul 2006 08:49 GMT | 1 |
Can I get an example of a recorded macro that is useful which can't be achieved by a copy/paste? Thanks
|
| Opening warning | 05 Jul 2006 08:15 GMT | 3 |
When I begin using EXCEL a message pops up warning that a file could not be found. It is from a program that I had deleted and I think is no longer on my PC. Is there a method to check and/or a method to delete the message? Thanks, Mike
|
| counting duplicates Among Many Sheets, Possible?? | 05 Jul 2006 02:23 GMT | 5 |
:confused: Hi, I have spent countless days trying to find a formula that will allow me to find duplicates across Multiple Sheets within a single workbook. All resources I have checked only allow duplicate finding formulas for A single Sheet.
|
| hiding formula error #DIV/0! | 04 Jul 2006 23:15 GMT | 5 |
Hithere, In a sheet, for a cell I use the formula: =(F4/1,19-D4)/(F4/1,19) If there is no input yet in cells F4 or D4 an error message "#DIV/0!" is
|
| modifiying macros | 04 Jul 2006 22:36 GMT | 3 |
I understand how to record a macro. But if I want to modify it (to repeat throughout the sheet), how do I access the code to mofidy? Thanks, KBV
|
| Dumb Chart Question | 04 Jul 2006 21:52 GMT | 4 |
Hi. I have a simple worksheet tracking and calaculating the following information about runs: Date | Miles | Hours / Minutes | Minutes per Mile | Marathon Pace Runs happen roughly 4x/week, so my entries might look like:
|
| Two columns into one row | 04 Jul 2006 20:03 GMT | 4 |
I have some files I need to format. I have a list of coordinates that are in two columns and I need to turn them into one row, keeping the order ie:
|
| Get Week number from Date | 04 Jul 2006 19:08 GMT | 2 |
for my job I need to get week number from date (date format doesn´ matter). I know, that in excel (beggining 2003 edition) is simpl function WEEKNUM. But unfortunetelly in our firm is used 2000 version I´ve worked on solution for really long time (compare with anothe
|
| Select Range to last used cell | 04 Jul 2006 17:14 GMT | 1 |
In a macro I need to select an Range of cells (rows and columns) for printing The data in the spreadsheet is brought in via a database query and so the bottom area has lots of blank rows, and a print page ends up with
|
| Playing with dates | 04 Jul 2006 17:07 GMT | 6 |
Rite here I go, I want to automatically add today’s date in a cell, which I have not done in so long I have forgotten. Then from using this date I want to be able to search an entire row of dates and find out if any dates in the row are older then 2 years, if
|
| Multiple copies of a worksheet | 04 Jul 2006 16:41 GMT | 5 |
I am creating a workbook with up to 30 sheets. I have created a templat in sheet 2, and want to copy that sheet 29 times for multiple users t them enter data into. It is rather burdensome to keep selecting an copying (w/ move to end) sheets until I have the amount I need.
|
| Deleted workbook | 04 Jul 2006 16:08 GMT | 1 |
I copied some sheet from one workbook to a new workbook and later deleted the first work book. Every time I open the new workbook it asked if I want to update the other on the link. I posted a couple of days ago and was told to go to Links and break the link but this option is ...
|
| Linking Tables between sheets | 04 Jul 2006 15:56 GMT | 2 |
I want my Excel file to have 2 sheets with 2 tables. I want the 2nd Sheet’s Table to be LINKED to the 1st (so when I update the 1st, the 2nd auto-updates). Just FYI, I’m planning to hide some rows/columns on the 2nd sheet, but still
|
| Converting a cell to minutes | 04 Jul 2006 15:53 GMT | 2 |
I need to enter a number of hours into a cell and it will work out the amount in minutes. Obviously i could do this with a calculation in another cell (=sum(A1*60)... However i need it to work it out in the cell that i put the number of
|
| Display only nonzero items in a table??? | 04 Jul 2006 15:41 GMT | 3 |
If I have a table with 5 columns and I want to only display rows with nonzero entries of one of the columns... What is the best way to do this? I want to be able to integrate this into a macro, also.
|