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

    Workbook Navigation when Worksheets are protected

    MS 2003 is being used, protection is applied using tools > protection > protect sheet; When ctrl + page up/ page down is pressed, the view just appears to shift 'randomly' throughout the existing worksheet; When the protection is removed, it works fine and I am able to flick between the current...
  2. Suggie

    Printing - Fit to Page

    I've double checked that I have set the print area for just the part of the document that I want to print; Jtorres13 - The space that is being 'wasted' appears to be predominantly on the left and right.
  3. Suggie

    Protected Worksheet - Row Height Adjustment

    When a worksheet is protected, how can I ensure that a user can still amend row height?
  4. Suggie

    Workbook Navigation when Worksheets are protected

    Why,when a series of worksheets within on workbook are protected, the user cannot navigate easily across tabs using ctrl + page Up/ page down? How can this be avoided?
  5. Suggie

    Printing - Fit to Page

    I've created a workbook, certain tabs of which will be printed for presentation purposes. All page set up options have been set up - Print area, fit to page 1 by 1. However, when the page prints, there is sometimes lots of wasted white space - Is there any way to 'stretch' the page to the...
  6. Suggie

    Moving pages from one word document to another

    Hi Tony, There are three text boxes on the page. Mark
  7. Suggie

    Moving pages from one word document to another

    Morning, Using version 2000. Would like to move the full page from one document into a separate document. In document one the page I want to move is page 3 and then place this page betweem page 5 and 6 of document two. Mark
  8. Suggie

    Moving pages from one word document to another

    Hello, Does anyone know of a way of moving microsoft word pages to another document. Something similar to the function in excel or powerpoint. TIA mark
  9. Suggie

    SUMPRODUCT

    Skip - genius! very impressed. Thanks.
  10. Suggie

    SUMPRODUCT

    Thanks Skip - I did try the same range but still not working. Basically, I have a pivot table that contains the hrs that each employee has booked for each day throughout Sept. I need to put this into a separate format. column C = is the unique id - employee id column d = is the week, whether...
  11. Suggie

    SUMPRODUCT

    Thanks for the responses - still getting errors though and I can't see what it is?? =SUMPRODUCT (('Iflex Projects Summary'!$C$6:$K$102=Iflex!$C$14)* ('Iflex Projects Summary'!$D$6:$K$102=Iflex!$M$11)* ('Iflex Projects Summary'!$C$6:$K$102=Iflex!M12) *('Iflex Projects Summary'!C6:K102)) Still...
  12. Suggie

    SUMPRODUCT

    Hello, Can anyone tell why this formula is just returning #value =SUMPRODUCT((('Iflex Projects Summary'!$C$6:$K$102=Iflex!$C$14)*('Iflex Projects Summary'!$D$6:$K$102=Iflex!$M$11)*('Iflex Projects Summary'!$C$6:$K$102=Iflex!M12)*'Iflex Projects Summary'!C6:K102)) I'm trying to use sumproduct...
  13. Suggie

    SUMPRODUCT Function

    Thanks folks - I've given Blue the Star but all help appreciated. Cheers folks,
  14. Suggie

    SUMPRODUCT Function

    I've tried the below and I get #VALUE! =SUMPRODUCT(($B$14:$B$16=$B5)*($C$13:$F$13=C$4)*$C$14:$F$16)+SUMPRODUCT(B21:B24=B5)*(C20:D20=C4)*C21:D24) Any ideas, first time using this function (as you may have gussed) TIA
  15. Suggie

    SUMPRODUCT Function

    Hello, I am using this formula =SUMPRODUCT(($B$14:$B$16=$B$5)*($C$13:$F$13=C4)*$C$14:$F$16) In the below summay table which returns the sum of the criteria in Data Source A B5 = the Cost Code 1 and C4 = Company A and C14:F16 is the table Data Source B Criteria is that Cost Code and...
  16. Suggie

    Summing Rows and Columns

    I have thanks - first time I've used sumproduct - excellent function. Thanks for bearing with me. Mark
  17. Suggie

    Summing Rows and Columns

    Didn't mean to subit post...one of those days. I need to populate the summary table with the details from the below data tables, I was trying sumif but this didn't work as the headers do not line up e.g. Company D in data source b does not line up with Company A in the summary table. Anyway -...
  18. Suggie

    Summing Rows and Columns

    Summary Table Cost Code Company A Company B Company C Company D Company E Company F 1 2 3 4 5 Data Source A Cost Code Company A Company D Company C Company F 1 50 108 50 200 2 70 22 90 40 3 20 50 80 20 Data Source B Cost Code...
  19. Suggie

    Summing Rows and Columns

    OK - see why you need the example How did you input that table CODE and I place my exsample up
  20. Suggie

    Summing Rows and Columns

    Robert - never attached anything before - I can't seem a clip button to show a sample file???

Part and Inventory Search

Back
Top