Hi, Anyone know if it's possible to copy Outlines (the groupings, not the data) from one worksheet, or workbook, to another? Thanks

Is their a way that when I open an xls workbook that I could write some code under the workbook_open sub that would automatically open a csv workbook and...

Hi there Hope you can help. I want to be able to put a variable in . As an example =si!e9. Therefore wahtever the work book name in a6,a7,a8 etc will...

Hi Mike, You gave me the code as attached below for listing the contents of a folder: Private Sub Worksheet_Activate() ListBox1.Clear MyPath...

Hello is it possible to unprotect a worksheet when a certain cell is selected using VBA . I need to unprotect the worksheet when cell B34 is selected and...

I'm trying to validate data that is being entered into a cell based on a list that is on another worksheet in the same workbook. I have the range with the...

Hi, I need to be able to force the user to save the spreadsheet by use of VBA as opposed to useing the save button or using the File\ save in excel...

Is there a statistical whizz here who is also a golfer? I am having a little difficulty with one element of a calculation outlined in the USGA's Handicap...

Hi all, As mentioned in the Subject line, How would I list the contents of a Folder eg. D:\Any\Contacts\?????. and have this info displayed in a...

I have a machine with both Excel 2003 and Excel 2007 installed. A user tried to open an application using ACCPAC which will call for Excel to be OPEN and it...

Dear all Please anybody can help me with a sample graph which are using in business for Break Even point analysis. It would be very helpful to me. Please...

I have purchased a new lap top running Vista with MS Office Enterprise Edition. I am trying to work with files created on a desk top system running Windows...

Hello - I have created a workbook with 30 sheets; each sheet has been protected so that my co-workers are not able to alter certain cells. Upon opening this...

2 columns. column 1 needs to be searched for a certain numerical value (a 6 digit code) column 2 is a series of numbers and needs to be searched for a value...

Dear T. valko I am sorry for not responding sooner as it just became too much for my little mind to cope with changing all my formula’s to get the one I...

I want to save an excel sheet to a text file, but I don't have the columns to be tab. I would like it to have no spaces between columns. Ex Name Col; ...

I have the following date 20081128 How do I convert this figure to the date 28/11/2008? Can anyone help? Thanks.

If in one cell I enter date 12.6.2008., I need that the cell next to automaticly calculate date which is 60 days from that date (in this case it would be ...

Formula thus far: =SUMIF(D4:D273,S4:S273,___) where the criteria ___ needs to find blank cells. Thanks in advance for your help...

I have a spreadsheet to record when monthly duty reports are received by each employee and reviewed by mgmt. Column A1:A200 Employee Name Column B1:B200 Date...