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

    SharePoint Online - Webpart Library from Subsite to Parent

    I have done libraries from parent to sub and vice versa in 2010 and 2013 and SP Online. The problem is in SP online after I have inserted the webpart onto the page and try to Check in/Out, delete, etc. a file it gives me this error message: The server has encountered the following error(s)...
  2. akrshaw

    PHP Across VM Environments Possible?

    We currently have a Web application that exists on a physical server that utilizes an automated PHP function to create print folders on a file share. We are currently migrating the environment to the cloud, and have been told we will no longer have the functionality to provision file shares on...
    • akrshaw
    • Thread
    • Replies: 1
    • Forum: PHP
  3. akrshaw

    Load New Version of File, Re-Enter File Info - Does not show up in view?

    I have a document library that has check out and versioning enabled. When you check out a file to upload a new version, it wipes the custom field info for the document....which is another issue I am running down. The MAJOR issue is after you re-enter the custom field information and go to...
  4. akrshaw

    SP 2013 - Document Library with Cascading Dropdown

    We are in the process of migrating to SP 2013 and I have to create a document library with cascading drop downs. I have accomplished this in SP 2010 with lists, but I have only been able to locate snippets of ways to use third party implements to accomplish in a document library. I cannot use...
  5. akrshaw

    SP 2010 - Quick Launch in Table of Contents - Need to see Subsites ONLY

    I have been reading all day the options and answers that are out there for limiting the TOC to sub-sites. I have tried the SOAP Data Source option and inserting the Data View in the page, this does nothing. I have tried creating a document library and adding this code to a text file, adding a...
  6. akrshaw

    List Calculated Column - Count Text

    I have the following list: File Name [tab][tab]Review 1 [tab] [tab]Review 2 [tab][tab][tab][tab]Review 3 [tab] # 001_SOC [tab]Jones/Working [tab] Nelson/Complete [tab] Haim [tab][tab][tab] 1 I need to count the number of Review columns that contain the word complete. I need to count the...
  7. akrshaw

    Excel - Automatically Bring Certain Rows into another Worksheet

    Thanks Skip!~ The workbook is created manually, so there is no external data populated in any of the tables. Worksheet Outline has all the columns we are tracking for a pursuit, then my idea is to have different tabs for Writing Assignments, Compliance, Production. This would give each person a...
  8. akrshaw

    Excel - Automatically Bring Certain Rows into another Worksheet

    This is actually a two fold question. 1) I need to bring from worksheet "Outline" only the rows that don't have multiple specific content like "Tech Section", "Tech Major Tab", "Tech Minor Tab" into worksheet "Writing Assignments". The criteria content is in one cell and starts at H11. 2) I...
  9. akrshaw

    Excel - As you type drop down select?

    So, when I start typing a choice in the drop down cell it does not show me possibilities? Can I do something where when I type "wes" it will automatically show me "western"? If do I have to scroll down each list to find it? I am probably not calling it what it is supposed too...? Thanks!~
  10. akrshaw

    Greater Than - Conditional Formatting - Multiple Cells - Excel 2007

    Is there any way to setup conditional formatting across multiple cells without having to do each individual one? I have a budget spreadsheet like this: Role [tab] [tab][tab] [tab] Resource [tab] [tab][tab] [tab] [tab][tab] [tab] Aug 20 [tab] Aug 27 [tab] Sept 3...
  11. akrshaw

    Field Type Information Error

    I have a Column titled Scope that is fed from a named range on another sheet. I also have code that allows you to select multiple items from the list and they populate the cells putting each choice on a seperate line in the cell. When I select 2 or more from the list I get an error "The Value...
  12. akrshaw

    Asking for the Moon - Pivot Table not Adding Row to Whole Sheet

    Right now I have data in 60 rows.
  13. akrshaw

    Asking for the Moon - Pivot Table not Adding Row to Whole Sheet

    I would LOVE to normalize the data!~ My skills in Excel are keeping me from accomplishing that, looks like I need to learn how to make a database in Excel while I work on the Access Database.
  14. akrshaw

    Asking for the Moon - Pivot Table not Adding Row to Whole Sheet

    Sorry, hard to turn off the jargon!~ :) OK, see if this is better. There may be 1 or 2 people working on each project (Bid Mgr and Bid Crd) The way the data sheet is setup it shows both people on one row to consolidate the notes and keep down multiple data entry. I need to split that out on...
  15. akrshaw

    Asking for the Moon - Pivot Table not Adding Row to Whole Sheet

    Will do!~ I have a data sheet with the following information (there is other data, but shortned): Pursuit Name Pursuit ID Bid Mgr Bid Crd Date Assigned Pursuit One GFGDFGD43 Smith 1/1/2011 Pursuit Fly By LDSOEMG76 Doe Sparrow 3/4/2010...
  16. akrshaw

    Asking for the Moon - Pivot Table not Adding Row to Whole Sheet

    Good Monday Morning!~ Getting an early start this morning!~ I have a Pivot Table that looks like this: Bid Manager Doe, John Pursuit One Pusuit Twelve Pursuit Gator Smith, Jane Pursuit Fly By Pursuit Forty-Three To the right of the Pivot Table I have: 2/6 2/13 2/20 2/27 3/5 3/12...
  17. akrshaw

    Excel Cells Populated with Text, Count Only Once with Blanks

    N1GHTEYES It worked...followed the same direction in the original file and it worked!~ Thanks so much, it was my first time to use an array formula!~ :)
  18. akrshaw

    Excel Cells Populated with Text, Count Only Once with Blanks

    xlbo - No error cells in the range. N1GHTEYES - I do have the range named Bid_MGR, did the CTRL - Shift - Enter at the same time...though not sure how well I am hitting them at the same time. Still getting the Value error....
  19. akrshaw

    Excel Cells Populated with Text, Count Only Once with Blanks

    Thanks everyone for all the help!~ I have tried both xlbo =SUM(IF(FREQUENCY(MATCH(IF(LEN(Bid_Mgr)=0," ",Bid_Mgr),IF(LEN(Bid_Mgr)=0," ",Bid_Mgr),0),MATCH(IF(LEN(Bid_Mgr)=0," ",Bid_Mgr),IF(LEN(Bid_Mgr)=0," ",Bid_Mgr),0))>0,1))-1 N1GHTEYES SUM(IF(FREQUENCY(MATCH(IF(LEN(Bid_Mgr)=0,"...
  20. akrshaw

    Excel Cells Populated with Text, Count Only Once with Blanks

    Skip I created the Named Range Bid_MGR, but I cannot add a space to the blanks, as another formula then sees that that cell is no longer blank and counts it for another cell. Plus, I am not the daily user of the spread sheet, asking someone to add a space to every cell would not work.

Part and Inventory Search

Back
Top