Hello there, I would appreciate some help in creating a macro to do the following:
I have an excel spreadsheet that has a data input in columnA, then several columns of formulas resulting i...
How do I automatically count the number of substrings in a cell?
For example, A1 = "Alpha and Beta 97 XY", B1 = 5.
Please advise?
Best wishes,
John
I have a macro which creates command buttons using OLEObjects.
The code which creates the buttons works fine.
The trouble comes later in the code when I do simple things like selecting...
Anybody know where I can download one for a tutorial I have to put together?
Thanks,
John
Good Afternoon,
This one is way over my head, so please bear with me. I have a spreadsheet that we are using to record brake temperatures on over-the-road trucks. We need to know percent...
Hi Experts,
I have a sheet like this:
A
1 Fruit (the header)
2 Apples
3 Bananas
4 Pears
5 (column A is blank from...
I have inherited an Excel wkbook that contains multiple Pivot Tables that are located on the same wksheet.
The current datasource is an OLE to Access or a Sql statement to be run.
I need...
I am trying to run a Data form from a macro. I recorded the following macro which I attached to a command button.
Columns("A:P").Select
ActiveSheet.ShowDataForm
Doing this manuall...
Take the following formula,
=LEFT(A1907,LEN(A1907)-2)&"66"
I want to know if its possible to make this act on the FORMULA that is in A1907 and NOT the result of the formula.
For examp...
Ok,
I looked but did not find what i was looking for....
So I have two sheets, one that list the Country, State, City in that order Starting in Column A.
I have another sheet that ha...
I have this VB Code to change the color of the cell. The only problem that I have is that I would like it to ALSO change the text color based on the background color ... If someone could help ...
Hello there,
I have written a macro where in the first stage it simply opens up a workbook. This workbook contains links to other workbooks.
So, when the macro runs a pop-up window appears a...
Hi all (again)
I have a workbook that contains multiple sheets. I want some VB code (activated by a command button) that will search the whole workbook for a string that is entered in a cel...
Note: Edited to add row & column references to make table easier to read
Edited to remove ambiguity about manual calculations
Hello Experts,
I'm trying to use Lookup and Refer...
Hi All
Been a while since I have been on here.... and have a question for a change...
Consider the data:
Divison Style
1 CLOTHING50-250 1000065
1 CLOT...
I'd like to import external data from SQL Server into my excel workbook, but I'd like the query to be dynamic based on the contents of a cell, i.e. select * from foo where bar=<contents of cel...
I have a single worksheet with approx 15 seperate pages of data.
Reference is this EE topic.
http://www.experts-exchange.com/Applications/MS_Office/Excel/Q_21996381.html
My second pag...
I have a small MS network (30 users). In the process of upgrading from Office 2000 to 2003. We are a CPA firm which means we do a lot of spreadsheet work. We share a lot of spreadsheets and...
I keep getting a file can not be found error whenever I try and open Excel 2003.
The error reads "E:\Fundware\F9\F9.xll" could not be found. If I click ok out of the dialog box, Excel runs...
The old thread at http:/Q_21890134.html was getting too long for people with dial-up access to download. So here is a new one in which we can discuss questions that need attention by other eye...
Hi all,
I am trying to pull in the entire paths of files from certain directories and listing them down in excel. I would like this
to be a repeatable process that my coworkers can have...
Okay, I hope I explain what I am looking for correctly. I have a database several thousand lines long with a unique record on each line. Every day I need to weed out about 20-30 records while ...
I have a large list of addresses (almost 7000) in a worksheet. The state abbreviations are in their own column. I am creating a user form and I want to have a combo box that has the DISTINCT...
i am using the substitue formular to covert some number example 333.50 is now =SUBSTITUTE(AC9,".","+")333+5
the question how do i add the zero to the substitute formular to make it 333+50.
Hi Experts,
How can I do the following?
- User clicks on a particular cell on the spreadsheet and a calendar control pops up
- the user clicks on the calendar and the date is filled int...
