Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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