Recent content by tsoccer63

Yeh I original had a pivot chart with averages but was asked by someone higher up to show ALL the data points. They kinda want to be able to visualize the range, stdev, average, and number of data points all at once making a scatter plot with all the points ideal. Its gunna end up looking like...

I have a ton of data with some text that i want in a scatter plot but it wont put the names on the x-axis for me. Heres an example BP EP EP BP EP 200 400 350 250 410 The data is organized like that...I want EP and BP on the x axis and all the values that coorespond to...

Hey! Here is my code, sorry it is messy but I am not a programmer by trade so my skills are limited. Basically, I do not know how to handle errors in VBA. In this code I grab a file path from a cell, do some tweeking of the path, then open the file and paste the info into a new sheet. My...

The file is open :/

Hey, I have the file "Book1" open so I don't understand why this isnt working. I do NOT want to put the full file name in because I want to be able to move the file with the results directory and have the references still work. Is my syntax wrong? I tried several changes such as taking out...

Hey! I have a sheet that uses combo boxes as pulldowns to select certain things that change numbers in text boxes. There is a picture in the backround. Whenever I change the combo boxes the page blinks. I have a macro that changes a pivottable on a separate sheet when certain boxes are...

Is it possible? I have 160 files with different names in a folder "Results" that I am trying to summarize with graphs etc... I am using a pivot-table with certain parameters that outputs the names of the files I want to look at. I want to be able to take this outputed names and use them to...