cell a1 = 1206. This is really 12/1/06 in a date format, and this is the string I need to derive from this representation.
cell a2 = 107. This is really 1/1/07 in a date format, and this is...
In a administration sheet used for software testing I want to count certain values for an overview.
I need some help for this situation:
A test-checklist leads to a number of issues. In th...
I would like to create an excel macro which highlights an entire row to red based on a condition within a cell. What is the best way to go about doing this procedure? Thanks.
I am looking for a better method to do search and replace for data on an Excel VBA file import conversion application. Currently, we have a subroutine that performs 4,500 search and replaces....
I have several excell document that have multiple users accessing them, some users can open an make changes while other are connected, and some only get read only. How can i fix it so that all...
I have a spreadsheet which has 5 columns of data. One column contains duplicate values. I have a Macro which highlights cells, which contain duplicate values in column D, but need code to hig...
Hi experts,
Is there any way I could create a VBA macro that when run would display a pop-up list of values of which one could be selected and inserted into the current cell?
For exmaple...
hello,
i'm trying to run excel file with macro inside via a batch file. with the excel 2003 i did it via -> "run excel macro" an EXE file -> it was opening the excel -> and it was uploaded vi...
Hi,
I've got a problem with Excel 2007. If i try to open a file using any method other than the Office button in Excel itself it tells me that it cannot find the file. So, if i go to my Doc...
Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience. This happens when my user saves an excel spreadsheet.
What data does this error rep...
Excel 2003...
I entered a column of names...about a dozen...A5:A30
Then I went to the "borders" icon on the tool bar and selected to put a border around each cell...this give me a black ...
I would like to find an alternative spreadsheet program to Excel that can use my existing Excel spreadsheets, including the macros I have built into my existing spreadsheets. I find the Open ...
Hi experts,
I have a report that outputs text into a date column 'E' in excel.
This formula works:
The Excel function that converts dates to text is: =TEXT(XX,"m-d-yyyy")
XX is the ...
I have got an excel spreadsheet:
First row contains a list of name, dob etc.
Second row blank
Third row - Address and data follows in that format through the document -the first spreadsh...
I have a spreadsheet that inputs and parses logs by log name to multiple sheets. The number of sheets changes and the number of rows change depending on the imported file. What I am trying t...
When opening a shared workbook in Excel 2000 receive followi message: "Microsoft Excel for Windows has encountered a problem and needs to close...". The specific information is as follows: AP...
Hello Experts,
I have a range (Data) that will have either 4 or 5 columns of data. The range may begin in any cell of any sheet name and may have any number of rows. Using VBA code I would ...
I am coding a VBA function in Excel with the following code that keeps giving me an error "Argument not optional" when I try to compile it.
The error happens on the call to WriteToINI.
A...
i have problems using Save as method in excel macro.
In my code i am using Something like this open different worksheets in different excel sheets in a directory:
' setting up the Source ...
Dear Experts,
I have a workbook where
A - Years (Auto if possible given the starting number and ends at 56)
B - Deposit (Manual Entry)
C - Total (Auto)
D - Amount (Auto)
E - Withdraw ...
I have a macro which scans all excel files in a directory. but the path of the directory is in the VB code.
i would like to know if this can be changed. i . e . path should be in the excel s...
When trying to save an Excel file to a mapped shared folder on 2003 SBS, the progress bar gets to about 98% then stops and after 20-30 seconds an exclamation icon appears in the system tray wi...
Hi,
I'm working with Excel 2007 and I have a spreadsheet with data starting each row in column B and I want to sum it all in column A. In other words A1=Sum(B1:Z1), A2=Sum(B2:Z2) etc.
Th...
Using MS Excel 2003, I need to compare sheet1, column a, with sheet2, column a, and combine ALL unique values to create a list on sheet 3. For example,
NOTE: sheet1, column A does not cont...
I have a spreadsheet with data in several colums and down a number of rows.
Each record comprises data horizontally across the row.
I need to be able to sort this data by eg. date and have a...
