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 Mike Lewis 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: *

  1. RHTexas

    Create Multiple Worksheets from Filtered Data and Rename the Workook

    Good Morning Skip, Thanks for the question. That is a very good question by the way. :) The final goal I am trying to get to is to have one worksheet per site with multiple plots on it showing the data. I realize that a pivot and filter is a good way as well...I'm a newbie to VBA but I use...
  2. RHTexas

    Create Multiple Worksheets from Filtered Data and Rename the Workook

    Hi All, Any help will be greatly appreciated. The below code works great for one site filter, copy and paste into one new worksheet and renaming it to the Site value. I would like this to loop and create a worksheet for each Different Site and rename the workbook to the site value. I...
  3. RHTexas

    SQL Query Help Return only 1 line item per Cell

    Hi SQLBill, Thank you very much for taking the time to help a stranger out. The Distinct worked like a champ...Perfect! Thank you! Also, I am using SQL...the database houses many days, hours, and minutes worth of data that I need to pull out for given times. This is the only way I could...
  4. RHTexas

    SQL Query Help Return only 1 line item per Cell

    Hi All, I am new at SQL but I am doing my best to query two tables. The below Query works but returns the same values 3 times for each. Query: SELECT ERICSSON_UTRAN.RNC_UCELL_DY.DATETIME, ERICSSON_UTRAN.RNC_UCELL_DY.RNC, ERICSSON_UTRAN.RNC_UCELL_DY.UTRANCELL...
  5. RHTexas

    Stuck on getting a loop to work

    Thank you very much for helping I do appreciate your time Skip. This makes since and I got the loop to work now. Thank you. Ray
  6. RHTexas

    Stuck on getting a loop to work

    Hi Skip, Thank you very much for responding. I was wondering about the attachment method last night. Please see code below. I know there has to be a better way to do the below but it actually works ok. I just can't figure out the whole loop issue. Thanks for helping out! Sub...
  7. RHTexas

    Stuck on getting a loop to work

    I am a novice at VBA but was able to put together a macro that serves my needs. The macro works well but I am not able to get it to loop properly. I've attached the files. RFDS_TEMPLATE_20111130_RAY_Macro is where the macro is stored. I have the macro opening a file which is also attached in...

Part and Inventory Search

Back
Top