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!

Register Log in
  • Congratulations Chriss Miller 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. shmoes

    Delegating file admin permission

    Thank you for the reply, greatly appreciated. I went in e expecting an argument, but they just needed a verbal explanation in a different setting. A plan was worked out. Not sure why it was so challenging but I achieved my goal. Thank You again Edit: FYI they initially estimated my request...
  2. shmoes

    Delegating file admin permission

    Hey all, It's been about 12 years since I've been in the IT game. But I'm having an issue with our current IT who doesn't want to create a folder/file structure for me. Right now the network drive is a dog's breakfast shared throughout the organization permissions are 1 level deep. If you...
  3. shmoes

    Inserting copied Formated Rows with a Macro

    I'll be honest, I had no idea how to create a named range.. sooo 3hrs of goggling.. trying to separate the code from the individual so I could understand what I needed is crazy when you don't know what you're doing! (My novice is showing!! haha) So I finally made your solution work once I...
  4. shmoes

    Macro Formatting > Skip a Line

    Thanks for the replies, the in rows will always be different, 18 just happened to be the row which I selected when recording. Which is why I was hoping to change the insert to the activecell. Everything stays the same except the copied cells/rows I want inserted, seems like it should be easy...
  5. shmoes

    Inserting copied Formated Rows with a Macro

    Hello! I'm trying to create a Macro to do some row formatting, for clarity, it's formatting for design not numbers/formulas. I started a thread here Link, but was directed to post here, I hope anyone can help. Originally, I thought I could just use the macro recorder format my cells and...
  6. shmoes

    Macro Formatting > Skip a Line

    Okay so I couldn't figure out my original request above to copy formatting from a separate page to the current active cell. So I went another route and resorted to adding the cell/row formatting to the top of each page and hiding the rows. I was able to easily change it to copy the first 4 rows...
  7. shmoes

    Macro Formatting > Skip a Line

    Thanks for the response, no the final product looks just like the photo, data is entered manually afterwards. but the active cell will always start in column A but it will change rows everytime. I want them to be able to select a row and press the shortcut and blamo the formatting is done :)...
  8. shmoes

    Macro Formatting > Skip a Line

    Here is an example of what the formatting should look like.. I should be able to do it from and Row on A column. The conditional color formatting changes with the word Red for Closed Green for Monitor Blue for Open ~AZ
  9. shmoes

    Macro Formatting > Skip a Line

    Hey all, I'm creating a live document with a number of users and I want to make it as seamless as possible. The best way I can think to do this is to have a Macro to format a few rows when we have random users creating a new entry. My problem is I don't know how to skip from Row 1 to Row 3...
  10. shmoes

    Match + copy + Absence tally + coloring (yikes!)

    Thanks for the responses guys, I will review the posted link and see what I come up with. With regards to the SD ED problem, for my purposes only the month of the initial day of absence counts. Otherwise I only need the end date to give me a total number of days absent or it wouldn't matter. ~AZ
  11. shmoes

    Match + copy + Absence tally + coloring (yikes!)

    Hello, I am trying to complete the following action, and am not sure how to begin. I have 1 Work book and 2 sheets. On sheet 1 I have a list of employees and thier employee number there is also a monthly grid for the year beside the list of names ----------------------------------------...
  12. shmoes

    CountIFS being selective with criteria

    I looked at the pivot table, but the data just doesn't read the way I want it to.. I'm sure that's due to my experience level with it. when I have some time to decate to this report I will try to spend more time on it. However with a deadline of today, it makes it hard lol. I have just seperated...
  13. shmoes

    CountIFS being selective with criteria

    Of course, it didn't even occur to me that the data that I got was 9.3833333, but all I could see was 9.38! Thank you! Now if I can just filter weekdays and weekends, I'll be rocking! ~AZ
  14. shmoes

    CountIFS being selective with criteria

    Good Morning, I have a sheet of data sorted by employee, I need to calculate the number of occurences by job id (example 27) and hours (7.5) the formula I have so far is as follows. =COUNTIFS(Data!H:H,27,Data!F:F,"7.5") This appears to work fine and counts all the instances that meet this...
  15. shmoes

    Ms Query Question

    Hey all, Silly question because the word query should speak for itself... when I am joining tables and moving stuff around.. it's not manipulating the actual tables is it? just need to be safe as I can't mess with originals db files. thanks! ~AZ
  16. shmoes

    EXCEL - Count if?

    yes on both questions the only common factor is the employee. But the employee could have I've never used MS Query before I will look into it. Thanks ~AZ
  17. shmoes

    EXCEL - Count if?

    This is probably an easy one for the pros Here is what I am trying to do. Sheet 1 Identifies employee + Event Sheet 2 Identifies Employee + Job number I want to separate the events by job number on sheet 3 Example - Job 001 = 3 Events - Job 002 = 10 Events I only have currently...
  18. shmoes

    XP Home on the Network

    It a home style network with 1 computer that has private business stuff ( no domain) and xp home installed.. The wireless network has many different computers connect to it at random and I don't want them to see the computer not just the drives. Thanks ~AZ
  19. shmoes

    XP Home on the Network

    Hey there, I'm sure this is a easy dumb question, but what's the easiest way to keep other computers from seeing an XP HOME computer on the network ... it seems the options from XP PRO aren't available. Thanks! ~AZ
  20. shmoes

    outlook 2007/exchange 2007 and terminal services

    When setting up a new profile, we come across an issue that occurs only on our win2008 terminal server. it seems that there's a resolution issue, but it strikes me as wierd that it can find the user account ok, but then can't connect to get the settings.. --------------------------- Microsoft...

Part and Inventory Search

Back
Top