| Thread | Last Post | Replies |
|
| Row and Column Strikethrough | 27 Jun 2007 14:20 GMT | 1 |
Why are my Row and Column Headers shown with a Strikthrough each of the letters and numbers? I can email a screen shot in PDf if anyone would like to see. Thansk,
|
| Vlookup formula | 27 Jun 2007 14:07 GMT | 3 |
Hi...really need some help here...On 1 sheet i have 3 columns..Column A is Region, Column B, Store Number, Column C is Store Name...on a another sheet, I have the Store numbers and store name...how do i create a Vlookup so it looks at the store and populate for me the
|
| Look up one value and return multiple corresponding values | 27 Jun 2007 14:06 GMT | 3 |
Hi I have a VLOOKUP set up to lookup value "1" contained in workbook "A" in workbook "B". I do however also need to return a corresponding value from workbook "B".
|
| how to continue the page number through the tabs ? | 27 Jun 2007 13:48 GMT | 2 |
how to continue the page number through the tabs ?
|
| Formula or Macro | 27 Jun 2007 13:24 GMT | 2 |
Is it possible to use a vlookup up function when three conditions need to be equal in both worksheets for the required data to be pulled in? If so, how?
 Signature MBH
|
| Subscript and superscript buttons in excel | 27 Jun 2007 12:46 GMT | 2 |
i used to search for the icon in "add or remove buttons", "customize", "commands". this time I just can not find it! Help!
|
| Converting ASC to csv | 27 Jun 2007 12:45 GMT | 1 |
How can I convert an ASC file to a csv file. The file that I have is very large3.78GB. Does the size of the file make a difference? Also my computer has 512 MB of RAM and a Pt M 1.73 Ghz processor. Do
|
| How to exlude holidays from a range of dates | 27 Jun 2007 12:44 GMT | 2 |
Dear Excel Expert User, I have in sheet 1 a list of holidays : 01/01/2007 in A1, 25/12/2007 in A2 etc... In Sheet 2, I have in A1 a start date and time and in B1 an end date and time.
|
| HYPERLINKS IN VBA!! | 27 Jun 2007 12:42 GMT | 3 |
This is what I want to do...I want to be able to create a hyperlink in a macro AND, the most important part (because I already have successfully created a hyperlink in a macro), RE-LINK the hyperlink to the copied and renamed worksheet.
|
| Editing the target worksheet | 27 Jun 2007 12:33 GMT | 3 |
My target worksheet (just one) is linked to several source worksheets (about 50 files). If I want to edit the target worksheet (say, adding additional rows), does it mean that I have to open all my sources such that the links can be kept?
|
| how do i insert a real time clock in excel ? | 27 Jun 2007 12:31 GMT | 3 |
I want to build a feature in Excel 2003 which gives a warning if somebody has the sheet opened longer than a certain time, we are sharing a planning in Excel, and sometimes a colleague keeps the sheet opened for a long time without working with it .
|
| erasing outside print area | 27 Jun 2007 12:30 GMT | 11 |
how can erase the empty cells, outside print area?
|
| Excel Recovery | 27 Jun 2007 12:30 GMT | 4 |
Suddenly, somehow my excel and word programs can't be found on my pc. How can I recover them or do I need to do a reinstall? If I reinstall will I lose my data files and spreadsheets?
|
| InsertFirst | 27 Jun 2007 12:27 GMT | 12 |
Hello.. I have this code: As new data is save at the last row, how do i make it to save on the first row? Do i use FirstRow?
|
| excel | 27 Jun 2007 12:24 GMT | 2 |
I would like Excel to automaticaly open another worksheet if the value of a particular cell has a particular value. Is this posible?
|