Dear Experts,
I have a problem & a question this tutorial on mrexcel.com: http://www.mrexcel.com/articles/macr...ily-report.php. I'm trying to utilize this in a PO system for work. Unfortunately, I keep receiving a Run-time error '9' (subscript out of range) on this specific line:
Code:
Sheets(TabName).Copy After:=Workbooks(ControlFile).Sheets(1)
The code is strictly copy/pasted into my VBA editor, except changing the names inbetween each of the quotes ("") for specific sheet/cell names. I'm not a programmer, but I've read through the code and logically can't deduce why it shouldn't work for me.
My other related question is that I would like to have the new worksheet sent to the end of the active workbook, so would substituting "Sheets(Sheets.Count)" at the end of the above line of code work to send it to the end of the workbook?
Thanks for your help ahead of time.
Who can help me with three questions on analyse-it toolpack when performing passing and bablok orthogonal regression.
1. There are two menus by which to start with passing and bablok A. via agreement and B. via regression. They give similar but not identical results. Which one should i use
2. How can I get a correlation coefficient using passing bablok regression
3. How can I calculate the error in slope and iontercept using passing bablok regression?
Thanx for your help.
Helen
I have a sheet that has EMPLOYEE NAMES in Column A.
Across in the ROWS is the technical skills and their level of proficiency.
Once all the data is entered I need to consolidate all the data as a summary sheet for all the technologies. Attaching a file for details.
The 2nd sheet has the data that needs to be analysed. The first sheet is where the totals are needed.
Any help is appreciated. Thanks in advance to all the EXCEL Gurus.
I need advice on how to process an online web page from withing VBA.
I am helping a client to automate the building of hundreds of URL (http) links in a workbook. Each link searches for a specified product in an online catalog/retail site. Some of the links attempt to locate products which are not available - these yield a valid web page where the main content is "This product is not in our catalog".
Rather than following every link manually, I would like to be able to program a routine which automatically follows the link, checks whether the product exists (e.g. possibly "view source" and check for the "...not in our catalog" text string).
I have no idea how to do this or even whether it can be done from within Excel/VBA (2007). I could also use VB2008 as my programming tool to control the entire process, if that may provide a solution.
Any ideas?
Compliments of the season,
Steve
Hi,
This is my first post on this forum, I hope it's ok.
What I need to do is produce a spreadsheet with a list of servers used and what they are used for. These will be listed along 1 or 2 rows across the spreadsheet.
What I really need is another list of ALL servers somewhere below, colored green normally, but highlighted red if they exist along row 2 or 3.
Does this make sense?
I have been battling with this for a while but have yet to find a solution so any help/advice/pointers would be really appreciated.
Thanks.
Jim
Ok So I want to sort a bunch of data to categorize but I have a lot of them (maybe 100-150 possibilities/categorize) and I have maybe 6000 rows of data. What is the best way to sort it into the categorizes? I know I can use a bunch of if else statements but is there a faster way? Hope you get what I mean here
Hi,
I have a table with data arranged as such:
-one column with dates
-one column with hours of work done during that corresponding date
I'd like to:
-automatically draw a line when going from sunday to monday (sundays and mondays are not necessarily explicitely there)
-extract to another 2 columns with the first days of the week on the left side and the total of that week on the right side so I can plot it in a chart
I'm decent in vb and programming and stuff but never did anything too serious in excel and would greatly appreciate any pointers to get me in the right direction.
Hi. How does excel analyse text in formulas. More specifically
="A"
Hi,
I am a horse racing fan and have kept an Excel Spread sheet of all my bets for the past year or so.
I have about 39 columns which all require inputs. I am struggling to find a quick way to analyse and so laboriously have to data sort at present and add up columns to determine how many winners a certain jockey or trainer have in certain types of races and how my bets have stacked up for those given jockeys, trainers and certain types of races.
Any idea how I can in a separate worksheet start to input Jockey A) eg Tony McCoy, and then extract the analysis I need. I have tried some of the @ functions but have not as yet found the right one for my purpose.
also is it possible ultimately to have an input sheet where I can actually input a jockey or trainer over a given range and it retuns all the stats for that person within certain criteria?
Many thanks in advance.
I am a bit of a novice but have mastered the inputting side with a pretty table etc but now desperately need to start interrogting as I am sure it will improve my betting to be able to identify the races, jockeys etc where I have been doing well and then screen out those where I consistently lose money.
Many thanks
rav
