Forum: Business Applications 
23-Jan-2013, 08:11 AM
|
|
Replies: 3
Views: 175 |
|
Forum: Multimedia
27-Sep-2012, 08:31 AM
|
|
Replies: 4
Views: 799 |
|
Forum: Multimedia
26-Sep-2012, 09:51 AM
|
|
Replies: 4
Views: 799 PVR?
Hi,
I think I am correct in the following!
If you have a DVR recorder with inbuilt HDD then we are talking about a PVR here (Personal Video Recorder).
Most of these now have a usb port for...
|
|
Forum: Business Applications
21-Mar-2012, 10:57 AM
|
|
Replies: 6
Views: 509 |
|
Forum: Tech Tips and Reviews
08-Mar-2012, 10:54 AM
|
|
Replies: 4
Views: 1,553 thanks Chuck,
I've never thought about the...
thanks Chuck,
I've never thought about the sure protector rating for DSL, I've been using it for so long it didn't cross my mind.
The ISP doesn't offer any lower tiers, they quote that speed is...
|
|
Forum: Tech Tips and Reviews
08-Mar-2012, 08:06 AM
|
|
Replies: 4
Views: 1,553 Router ADSL Connect through Surge Protector
Hi all,
I have just increased my broadband speed from 1.1 Mb to 1.38 Mb (yes that's all I can achieve with my 'up to 8Mb service'!).
I previously had the broadband filter plugged into the...
|
|
Forum: Do It Yourself (Not Computer-Related)
30-Jan-2012, 09:31 AM
|
|
Replies: 4
Views: 773 Hi Ellsrobbie,
This isn't the answer you...
Hi Ellsrobbie,
This isn't the answer you want!
I had the same with a new TV once, what you are describing is the lag in the lipsync between TV and sound system i.e the lips move after the sound...
|
|
Forum: Business Applications
16-Jan-2012, 04:59 AM
|
|
Replies: 3
Views: 632 Hi Durolenz,
Sorry it does not make sense to...
Hi Durolenz,
Sorry it does not make sense to me.
You are calculating the Complete Job Time based upon the number of Sheets held in cell D6, OK.
But next you say that you want that Complete...
|
|
Forum: Business Applications
13-Jan-2012, 11:02 AM
|
|
Replies: 3
Views: 632 Hi Durolenz,
You should have posted in the...
Hi Durolenz,
You should have posted in the Business Apps thread, but anyway.
Your query isn't clear.
The formula will give a result depending on what is in cell D6, the SUM part of it is...
|
|
Forum: Business Applications
16-Dec-2011, 12:27 PM
|
|
Replies: 3
Views: 399 hi inthecloset,
I don't use a trackerball,...
hi inthecloset,
I don't use a trackerball, but does it have 'mouse' keys that are configured for actions such as the ctrl or shift keys.
A bit confluted, but highlighting a number of rows and...
|
|
Forum: Business Applications
20-Oct-2011, 12:44 PM
|
|
Replies: 3
Views: 2,762 Hi both,
I don't think this is a conversion...
Hi both,
I don't think this is a conversion issue - that might be the case if trying to open a 2010 file using 2007, but you say opening 2007 in 2010 which should work.
Are you using EPM on a...
|
|
Forum: Business Applications
28-Sep-2011, 11:59 AM
|
|
Replies: 5
Views: 359 hi legalwatch,
Create a table of 3 columns...
hi legalwatch,
Create a table of 3 columns and as many rows as you need, then put your pictures, text in the cells.
If you don't want the table borders they can be removed in table properties -...
|
|
Forum: Business Applications
20-Sep-2011, 08:47 AM
|
|
Replies: 2
Views: 2,685 Hi mlmorris,
If I understand you correctly...
Hi mlmorris,
If I understand you correctly you want:
Section 1 : no page numbering
Section 2: i of iii, ii of iii, iii of iii
Section 3: 1 of 50 , 2 of 50....50 of 50
OK.
1 You need...
|
|
Forum: Business Applications
02-Aug-2011, 09:59 AM
|
|
Replies: 1
Views: 1,085 Hi Carpy,
What do you want to plot, the 'Sum...
Hi Carpy,
What do you want to plot, the 'Sum of YTD' per Department? for Offers and Sales.
Can't do anything with your example as there is no source to build a different Pivot Table from!
...
|
|
Forum: Business Applications
02-Aug-2011, 03:34 AM
|
|
Replies: 8
Views: 374 |
|
Forum: Business Applications
01-Aug-2011, 12:21 PM
|
|
Replies: 8
Views: 374 hi bostonpatriot,
When you place the cursor...
hi bostonpatriot,
When you place the cursor on the text that is not the Chapter heading, does the 'Normal' highlight in a yellow border in the Styles section on the Home ribbon?
I suspect that...
|
|
Forum: Business Applications
01-Aug-2011, 09:31 AM
|
|
Replies: 3
Views: 1,054 hi iceblade,
you don't need a macro to do...
hi iceblade,
you don't need a macro to do this.
Right click the pivot table and click FIELD SETTINGS
Click ADVANCED
Click the 'ON' radio button under 'TOP 10 AUTOSHOW'
Make sure the 'USING...
|
|
Forum: Business Applications
01-Aug-2011, 09:04 AM
|
|
Replies: 8
Views: 374 hi bostonpatriot,
looks to me that you are...
hi bostonpatriot,
looks to me that you are highlighting the start of a paragraph and turning the whole thing into a heading.
Do this instead,
Highlight just the words (i.e. the Chapter...
|
|
Forum: Business Applications
15-Jul-2011, 11:43 AM
|
|
Replies: 7
Views: 279 Hi Robrien,
On Sheet 3.
On the first...
Hi Robrien,
On Sheet 3.
On the first row put Service in A1, put Total Cost in B (as Headings).
From A2 down list the Services.
Starting in B2 put the following and copy it down...
|
|
Forum: Business Applications
15-Jul-2011, 11:24 AM
|
|
Replies: 7
Views: 279 hi robrien,
yes that makes sense, but where...
hi robrien,
yes that makes sense, but where do you want to see to total for a particular Service.
Do you want a table at the bottom of Sheet 2 that where a Service is on a row with the total...
|
|
Forum: Business Applications
15-Jul-2011, 11:02 AM
|
|
Replies: 7
Views: 279 hi robrien,
On sheet 2 you can put a...
hi robrien,
On sheet 2 you can put a SUMIF to add up all the prices for the occurences of ASE.
Do you want that same sum next to each occurence of ASE , or just once somewhere on sheet2.
...
|
|
Forum: Business Applications
15-Jul-2011, 09:03 AM
|
|
Replies: 7
Views: 279 hi robrien,
You need to use a VLOOKUP.
...
hi robrien,
You need to use a VLOOKUP.
Next to each Service in Sheet 2, add a VLOOKUP that uses the Service Name (or code whatever you have) against Sheet 1 columns to find the corresponding...
|
|
Forum: Business Applications
14-Jul-2011, 11:49 AM
|
|
Replies: 6
Views: 2,121 |
|
Forum: Business Applications
14-Jul-2011, 07:37 AM
|
|
Replies: 6
Views: 2,121 Hi Emruss,
You can sort contacts by Company...
Hi Emruss,
You can sort contacts by Company etc, but I 'll have to bow out as I don't know how you could have the same person in two categories at the same time.
But having clicked on a name...
|
|
Forum: Business Applications
14-Jul-2011, 07:30 AM
|
|
Replies: 5
Views: 2,341 |
