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

    Referenced Cell - Hyperlink

    I created 2 worksheets. In the worksheet labeled address it has 3 cells that link to web address (i.e. CNN, JCREW). In the worksheet labeled Summary it has 3 cells that reference the cells in the address worksheet. This issue I have is that I want users to be able to click on the cells...
  2. shaleen7

    Convert 1.95 years to months in Excel

    Hi All, Trying to convert 1.95 to months and days in excel. 1.95 = 23 months. Is there a formula I can use in excel? Cheers Thank You!
  3. shaleen7

    Excel Countif with one criteria multiple ranges

    Hi All, I created a 9 box grid in excel. I want to count the cells that contain text in the box that run diagonally across the box. http://files.engineering.com/getfile.aspx?folder=3482f7d0-8493-464b-8739-fb38f5fcbca1&file=Worksheet.xlsx
  4. shaleen7

    Search on two worksheets in Excel

    Hi All, I need some help. I have a workbook with 3 worksheet. Two of the worksheet contains a table of information. The common column between the two worksheets is name. I would like to be able to search on the name column in both worksheets and return the row of information that is associated...
  5. shaleen7

    Spilt Word Mail merge and assigns a merge field name as the filename but the macro adds extra lines

    Hi All, I'm not an expert on VBA so I found this could this code online to split a word mail merge document & assign the filename based on a merge field name. It works perfectly except it adds extra lines of space in the merged documents. A 2 page document is now 5 pages because of the extra...
  6. shaleen7

    Place records into specific boxes in a grid - Please see attachment

    Thanks so much! That was the direction I was going. The only thing I’m trying group the report by Department and Manager . I placed the 9 box subreports into the manager header but it keeps repeating and not grouping the report by Department and Manager. What am I doing wrong? The data in the...
  7. shaleen7

    Place records into specific boxes in a grid - Please see attachment

    Hi Duane, I've uploaded the access database. I'm trying to create a 9 box grid using the forms. One issue that I can see ....is that if I have 20 employees in on box the box will stretch off the form. I wondering if I can show 2 or 3 column per box. Meets Medium Box Rachel Perez Gary...
  8. shaleen7

    Place records into specific boxes in a grid - Please see attachment

    Eureka! I found the continuous form. Now my records appear together. John Kim I'm curious...instead of having the names appear from the top down. Can I have a certain number have fields go across...like this High Performers continuous form John Kim Tim Patty Lyn Alexis Cheers!
  9. shaleen7

    Place records into specific boxes in a grid - Please see attachment

    [smile][smile]Hi Duane, You are right! I should have clarified. There is an additional criteria for the box. If someone is considered a medium performer they are placed in the center box (i.e. Jill). If someone is considered a medium performer with a negative score they are placed in the center...
  10. shaleen7

    Place records into specific boxes in a grid - Please see attachment

    Hi All, I need some assistance. I have a table that contains the following information: Name Rating John High Jill Medium Kim High Mary Distinguish Clara...
  11. shaleen7

    Mail Merge - create a table within a merge letter

    I have a mail merge document where I have 2 sections in my form letter. There is a letter section appearing at the top and then I have data that needs to seen in a table format. Can this be accomplished through a mail merge by creating a table macro? So for every new record, a new record...
  12. shaleen7

    Word 2000 - Create table with gridlines for each record

    I've created a mail merge between our Oracle database and Word 2000. I need to place the merged data into a table. So that each record of information is surround by gridlines similiar to a table. Can this be accomplished without VB script because I'm not too familiar with it. I'd like lines...
  13. shaleen7

    Chart Fit to page Crystal 9

    I create several bar graphs in Crystal but the size of the chart comes across so small when I print it. Is there any way to make the chart fit the page. Thanks
  14. shaleen7

    Access 2002 Top Values

    I used Crystal Reports and it worked great. Thanks
  15. shaleen7

    Access 2002 Top Values

    I have a spreadsheet of information where I count the number of sales for each consumer product (i.e. TV, DVD etc.) in several countries. US JP AU FR KR TV 5 3 7 2 0 VCR 7 3 0 1 9 DVD 8 6 4 5...
  16. shaleen7

    Is there anyway to retrieve .pst folders? - Outlook 2000

    Just closed within Outlook.
  17. shaleen7

    Is there anyway to retrieve .pst folders? - Outlook 2000

    Is there anyway to retrieve a .pst folder once it's been removed?
  18. shaleen7

    Displaying one record from each group

    I've got a report where I'm trying to display the field where there is a checked box and if there isn't I want to print the words "No responsible employee identified" Each app has several employees working on it but only one is responsible for the entire app. The responsible employee has a...

Part and Inventory Search

Back
Top