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...
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.
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?
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...
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
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
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...
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...
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...
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
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...
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 -...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.