How can these large integers be converted to a date/time format that I can use (sort/filter) in Excel? They were part of a database that was sent to me in a tab delimited .txt file. It was o...
Hello Experts,
I would like a macro that would output the results from LINEST for my data including coefficients, intercepts and R squared-s in a new worksheet. I would like this done for ...
I'm working on migrating Access 2007 tables to SQL SERVER 2008 database, but I ran into the following error messages.
Test connection failed because of an error in initializing provider. C...
The VBA for Excel code below fails on the text-to-integer conversion step, namely:
nReps = Val(TextBox1.Text)
The error is: "Microsoft Visual Basic - Run-time error '424' : Object ...
The below code does great, but ... What if I want to re-order columns and don't want to edit code??
So , how can I make the below code use a sort key range that = a column based on its "nam...
Hello Guys,
Right now, we use a "database" in excel version 2007. It has 6 column headings: 1.) Branch-Date, 2.) Item Number, 3.) Type, 4.) Weight, 5.) Item Description, 6.) Price Code, 7....
Hi All,
I am finally able to connect to the SQL server through VBA after browsing many questions on EE, but now I have another issue. I have a query that is run in SQL, and then more VBA c...
I need to loop through a filter on a column and select all the cells which are visable.
I am not sure what the values in the filter will be.
I am not sure how to do this.
Does anybo...
How can I, In Excel pull last 7 digits of each cell from one column A and put the it in another column B?
There are 25,000 records in the column.
I can due =MID(A2,7,9) in the new cell but...
Hello,
I have about 100 excel spreadsheets that I would like to combine into the same worksheet. Column headings are the same except for one.
FID_TCK_
The numerals after "FID_TCK_" wil...
Hi, I want to know if there's anyway I can turn a cell in an excel spreadsheet (more specifically, many cells in a single column if they meet a certain criteria) into a command button that can...
Hi, I need to find the number of used cells in a column down to the last cell which contains a value (the whole range may contain values, text or formulas). Also, any formulas AFTER this last...
Hi EE,
Rory and WarCrimes have been helping me with the following post.
I'd like to re-visit a prev. discussion, pls
http://www.experts-exchange.com/Software/Office_Productivity/Office_Su...
I have a map of a building with up to 100 jobs represented by rectangles. I can name the rectangle with the job number when I create the rectangle. I have a daily report that shows the statu...
Hi EE,
I´m looking for the possibility of creating line or bar charts with multiple Y axis. Please
see attached JPG file. This is an example of the kind of charts that I´m looking for.
X-...
Hi EE,
a) Most of my Excel VBA experience has been simply:
- to put Access data in a spreadsheet via copyRecordSet
- then cycle thru fields collection to place titles
- form...
Not knowing much about VB or Excel, I can't do something that should be easy
I want to select an entire column. I have
Dim sourceWS As Worksheet
Dim sourceSerialCol As Range
Se...
Hi EE,
a) In an earlier post, Rory authored a solution for producing mini graphs
Each graph represents a course that a student took.
Max. courses is 10.
b) So Rory modi...
is it possible insert page numbers into a workbook so that when the whole book is printed the sheets are numbered in order from beginning to end?
pete
Hi,
I have a user that uses excel and Great Plains (MS Dynamics). She opens excel documents from Great Plains without problems. HEre is the problem: once the document is open from Great Pla...
Experts !
for example I have this given range of numbers of sales starting from the First Month to the 12 Month:
1 2 3 4 5 6 ... . .. . . .. ...
I'm trying to use Excel ActiveX checkboxes to do two things
1) When you check the checkbox, it copies the cell next to the checkbox in the B column of the first tab, and pastes it into the fi...
I am trying to solve the attached spreadsheet using Excel Solver to find the maximum flow. In my textbook the sum of the input nodes plus the output nodes is equal to zero. My solver solution...
Experts,
Matthewspatrick provided the code below to help me identify the "Max" value of an alphanumeric string. The code works fine, but it does not work when the range contains only one v...
i need some code in VBA to select and copy a picture from a excel cells
