Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: tsoccer63
  • Content: Threads
  • Order by date
  1. tsoccer63

    Excel: Scatter Plot with Text on X-axis possible??

    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...
  2. tsoccer63

    How do i skip a file that does not exist in my Excel macro?

    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...
  3. tsoccer63

    Referencing cells in a different file in Excel

    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...
  4. tsoccer63

    How to stop the blinking in Excel (w/ pic in background)

    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...
  5. tsoccer63

    Excel - External file linking without opening file

    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...

Part and Inventory Search

Back
Top