Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search
Tech Support Guy > >

Search Results


(!)

Showing results 1 to 25 of 494
Search took 0.11 seconds.
Search: Posts Made By: Yorkshire Guy
The search index was updated -14332 seconds ago.
Forum: Business Applications 23-Jan-2013, 09:11 AM
Replies: 3
Views: 270
Posted By Yorkshire Guy
Hi, So you have this: A B ...

Hi,

So you have this:
A B C (= A*B)
1 3 3

and you want this:
A B C
3 3 6
Forum: Multimedia 27-Sep-2012, 08:31 AM
Replies: 4
Views: 1,019
Posted By Yorkshire Guy
Yep, on older PVRs the USB port was for...

Yep, on older PVRs the USB port was for diagnostics only.

That's why I said 'Most of these now'
Forum: Multimedia 26-Sep-2012, 09:51 AM
Replies: 4
Views: 1,019
Posted By Yorkshire Guy
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: 594
Posted By Yorkshire Guy
Hi satibab, You don't mention where Excel is...

Hi satibab,

You don't mention where Excel is supposed to obtain the email ids from!

Do you have the list of names and email ids somewhere else e.g. on another sheet?

Hew
Forum: Tech Tips and Reviews 08-Mar-2012, 11:54 AM
Replies: 4
Views: 1,642
Posted By Yorkshire Guy
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, 09:06 AM
Replies: 4
Views: 1,642
Posted By Yorkshire Guy
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, 10:31 AM
Replies: 4
Views: 845
Posted By Yorkshire Guy
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, 05:59 AM
Replies: 3
Views: 732
Posted By Yorkshire Guy
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, 12:02 PM
Replies: 3
Views: 732
Posted By Yorkshire Guy
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, 01:27 PM
Replies: 3
Views: 495
Posted By Yorkshire Guy
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: 4,608
Posted By Yorkshire Guy
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: 446
Posted By Yorkshire Guy
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: 3,753
Posted By Yorkshire Guy
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,259
Posted By Yorkshire Guy
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: 464
Posted By Yorkshire Guy
hi boston patriot, Glad I could help, you...

hi boston patriot,

Glad I could help, you are welcome.

Would ypu please use THREAD TOOLS to mark this as solved.

:)
Hew
Forum: Business Applications 01-Aug-2011, 12:21 PM
Replies: 8
Views: 464
Posted By Yorkshire Guy
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,266
Posted By Yorkshire Guy
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: 464
Posted By Yorkshire Guy
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 22-Jul-2011, 11:58 AM
Replies: 2
Views: 2,051
Posted By Yorkshire Guy
Hi BratDawg, Formatting codes are toggled...

Hi BratDawg,

Formatting codes are toggled on/off with the button in the Paragraph ribbon.

Or shortcut: CTRL and * aka CTRL + Shift + 8).

lol
Hew
Forum: Business Applications 15-Jul-2011, 11:43 AM
Replies: 7
Views: 358
Posted By Yorkshire Guy
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: 358
Posted By Yorkshire Guy
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: 358
Posted By Yorkshire Guy
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: 358
Posted By Yorkshire Guy
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,929
Posted By Yorkshire Guy
Hi Wendy, Nice one. I wasn't aware of...

Hi Wendy,

Nice one.

I wasn't aware of the multiple Categories usage.

thanks,
Hew
Forum: Business Applications 14-Jul-2011, 07:37 AM
Replies: 6
Views: 2,929
Posted By Yorkshire Guy
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...
Showing results 1 to 25 of 494

 
Forum Jump
WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑