Using Excel VBA, I need to replace the capital letter at the beginning of a cell to the lower case of this letter.
Hello
I would like to create a macro that would allow the workbook user to save the file depending on the name created in cell "A1"
The user would also be able to choose the folder the...
I've currently got a worksheet called "Aggregate results" and then worksheets called "August 08" to "January 08". Inside each of the monthly worksheets is a list of departments, and how many t...
Hello,
Pardon the lack of proper verbiage in my description of this problem.
I am attempting to have a cascading set of drop down lists, one of which contains Unique values. I have briefly ...
Hi everyone,
Just a simple question technical question here. In Excel 2002, when I store unique keys/items to the Dictionary object, it stops at 256. Unfortunately I have 268 unique values ...
I need a function which checks a string (derived from a range containing game scores like "10,8" or "?,?") to see if they contain a "?". If they do then the game has not yet been played.
I...
I have very large spreadsheets with complex formulae that I do not want to move or copy. Often the formulae result in empty cells-so a column of 500 rows may have 100 empty cells dispersed th...
This one may end up being very simple, but for some reason I just can't wrap my brain around it.
We are setting up a new spreadsheet to track calls to one of our internal help desks, and we...
I want to create a command button that will send my existing excel spreadsheet via email to an Outlook user. What would the vb code be to do that?
Hi,
I have just landed with a problem that I need to come up with a solution for rather swiftly....
The problem is:
I have several files (24 in total) all linked to a central spreadshee...
I am creating a form that allows a user to enter data regarding a trade. it contains information such as stock name, quantity, buy price, sell price etc.
The user enters a number of trades...
In column A I have a list of records that are as such,
1A
2A
100A
200A
I would like to add a "K" in front of all the values in column A could you please help me do this with a macro.
I have an Excel Spreadsheet that has columns going across (horizontal). Is there a way to convert these columns to go down the side (vertical)
I have: A B C D E F G H
I ...
I need a macro that will turn a text value in a cell into a integer value based on the length of the text. For example, the cell has the following data in it [1.1]. I need this turned into t...
I have a budget worksheet that I need to keep a running total of expenses by comparing criteria from 2 different columns and then sum if those criteria are met.
For example, I want to know ...
I'm using excel 2007. I have phone numbers without any spaces like this 8005556454. Some have a leading 1 (18005556454). How can I use excel to remove the leading 1?
Thanks!
Desperately seeking a piece of VBA to do the following (tried looking for the answer but don't understand VBA so not sure if any similar examples found on this site would do what I need).
O...
Respected sir
i am using Crystal Report 8.5. I want to Generate report in ms Excel format through vb 6.0
in backend i am using ms Access
I have a worksheet with over 17,000 records(in rows) and maybe 35 or so columns. I need to do an error check to make sure that the correct types and correct values are in each column. I real...
Hi All
Im using Excel 2007. What I have is a workbook with two sheets ListOfItems and Annexure1. The ListOfItems sheet contains about 3500 rows and has columns A to AE. Some of the columns n...
I am having a huge issue when it comes to dealing with having to get information from different sources or tables.
I only know how to create a pivot table from one source.
I am using the following code to select a folder upon request. What drives me nuts it that I cannot sort the viewed directory by clicking at to the top to sort (as is usually possible) or I al...
I need to go line by line, checking the cell one column to the left, to see if it contains specific text strings. If so, then mark the activecell with an "a".
Text strings include "*open*" o...
Using excel, is there an easy way to find and replace the text after a quotation mark with nothing. For example:
Title"--name1
Title2"--name2
Title3"--name3
...etc.
I want to keep t...
O Geniuses, I call upon your wisdom
I have a workbook that uses several data entry cells on different sheets. Several cells use Data Validation to streamline the data entry process. I am go...
