A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 25 of 34
Search took 0.03 seconds.
Search: Posts made by: tarquinious
Forum: Worksheet Functions August 18th, 2011, 04:50 PM
Replies: 2
Views: 2,642
Posted By tarquinious
You could use something...

You could use something like:
=IF(A2="","",TODAY())
In this way it doesn't matter if you paste it further than the data you have, nothing will appear if there is no data in the cell.
Forum: New Users June 16th, 2011, 08:27 AM
Replies: 1
Views: 5,128
Posted By tarquinious
Go to this website...

Go to this website (http://www.dafont.com/code-128.font) and download the font (Download button on right-hand side).

Go to Control Panel/Fonts and select File/Install Font... and install the font...
Forum: Powerpoint June 9th, 2011, 08:57 AM
Replies: 1
Views: 4,116
Posted By tarquinious
The following is based on PowerPoint, but I...

The following is based on PowerPoint, but I suspect it will be the same for all MS Office products. As I can't find an automated method to do this, the manual method to do this is to:
Click on...
Forum: General Discussion June 2nd, 2011, 04:25 PM
Replies: 1
Views: 1,665
Posted By tarquinious
Are you able to attach a copy of the extract to...

Are you able to attach a copy of the extract to take a look at?
Forum: Charts and Charting May 24th, 2011, 11:33 AM
Replies: 5
Views: 4,224
Posted By tarquinious
Excellent about the graph, though I suggest you...

Excellent about the graph, though I suggest you try my later suggestion as it may be slightly better.

You will be getting the #NAME? error for one of 2 reasons:
You have not yet copied and pasted...
Forum: Charts and Charting May 24th, 2011, 11:02 AM
Replies: 5
Views: 4,224
Posted By tarquinious
1. Well I've found a "better" way of...

1. Well I've found a "better" way of displaying your data without the silly date workaround I suggested earlier. If you graph this as a XY Scatter graph, your data should scale appropriately. ...
Forum: Charts and Charting May 23rd, 2011, 12:23 PM
Replies: 5
Views: 4,224
Posted By tarquinious
Well, this took me half the morning to crack, but...

Well, this took me half the morning to crack, but I finally have it. I'm sure far smarter people of this forum will know of an in-built Excel function to resolve point #2 for you, but I failed at...
Forum: Installation & Setup May 18th, 2011, 03:57 PM
Replies: 2
Views: 2,156
Posted By tarquinious
Under the View menu is "Reading Pane" ...

Under the View menu is "Reading Pane" If you select the setting Off, this will get rid of the message preview to the right.

The other option you have already found: View/Auto Preview. With Auto...
Forum: General Discussion May 18th, 2011, 09:56 AM
Replies: 1
Views: 2,130
Posted By tarquinious
Hi Kieren, There are a number of ways to achieve...

Hi Kieren,

There are a number of ways to achieve this (including Mail Merge and inserting field codes) however, by far the easiest and way that sounds like it would suit you best is to paste a...
Forum: Publisher May 16th, 2011, 11:41 AM
Replies: 2
Views: 7,236
Posted By tarquinious
An option I have found that seems to work most of...

An option I have found that seems to work most of the time is if you create a textbox in Publisher, then right-click on it and select Change Text / Edit Story in Microsoft Word, then copy and paste...
Forum: Worksheet Functions May 16th, 2011, 10:29 AM
Replies: 2
Views: 2,743
Posted By tarquinious
This is semi-simple to achieve, but far more...

This is semi-simple to achieve, but far more difficult to describe the steps for. I'll make an attempt, but if this doesn't make any sense, you might want to send me a private message and I can...
Forum: Charts and Charting May 10th, 2011, 09:03 AM
Replies: 2
Views: 4,158
Posted By tarquinious
I believe the issue may be because, although your...

I believe the issue may be because, although your cells contain times, Excel is also taking into account the date (all time or date values contain both the time and date, but only display what you...
Forum: General Discussion May 6th, 2011, 12:31 PM
Replies: 1
Views: 2,578
Posted By tarquinious
Sorry, this has taken me some time as I have not...

Sorry, this has taken me some time as I have not done this before, but I have finally nailed it for you. The trick was that I had to write the macro in Outlook which referred to an Excel...
Forum: General Discussion May 6th, 2011, 09:11 AM
Replies: 2
Views: 7,555
Posted By tarquinious
This is quite simple to do, though I can only...

This is quite simple to do, though I can only give you the instructions for Word 2007 as that is what I'm running, you might be able to translate these over to whatever version of Word you are...
Forum: General Discussion May 4th, 2011, 05:19 PM
Replies: 2
Views: 2,682
Posted By tarquinious
A scanner will scan any item placed on it and...

A scanner will scan any item placed on it and allow you to save the result as any one of those graphic formats you listed. The key here is that those are graphics i.e the scanner doesn't know if you...
Forum: General Discussion April 26th, 2011, 02:18 PM
Replies: 1
Views: 2,496
Posted By tarquinious
This is possible, however the macro to get Excel...

This is possible, however the macro to get Excel and Outlook talking together is quite complex. To save time and effort, below are the instructions to export your calendar to Excel, then I have...
Forum: General Discussion April 20th, 2011, 01:48 PM
Replies: 2
Views: 2,048
Posted By tarquinious
In answer to the title of this thread, I think...

In answer to the title of this thread, I think you will most probably find what you're after at this site...
Forum: Worksheet Functions April 18th, 2011, 12:33 PM
Replies: 4
Views: 2,905
Posted By tarquinious
I don't know if you can "Automatically"...

I don't know if you can "Automatically" open the right worksheet based on the result if you are putting the result in multiple cells, how would a macro know which cell you're wanting the use as...
Forum: General Discussions April 12th, 2011, 05:33 PM
Replies: 1
Views: 11,897
Posted By tarquinious
Unfortunately there is no way to display a CMYK...

Unfortunately there is no way to display a CMYK option in MS Word (or Excel for that matter). I did, however, find a link to a list of CMYK to RGB conversions, which I'm sure a quick spreadsheet of...
Forum: Links and Linking April 12th, 2011, 04:13 PM
Replies: 1
Views: 3,962
Posted By tarquinious
I can think of a couple of options here, but...

I can think of a couple of options here, but firstly it is important to understand how you managed to get the Word fields linked to the Excel data.

To do this myself, I simply copied the Excel...
Forum: New Users April 1st, 2011, 09:20 AM
Replies: 2
Views: 3,296
Posted By tarquinious
There is another option where at the top of each...

There is another option where at the top of each client's page of data you use a Heading style for the title (e.g. type in Bob Smith's Data at the top of the page and press CTRL+ALT+1 to change it to...
Forum: Powerpoint April 1st, 2011, 09:12 AM
Replies: 2
Views: 3,460
Posted By tarquinious
In PowerPoint 2007, on the Home button bar tab,...

In PowerPoint 2007, on the Home button bar tab, on the far right is the Editing group of buttons. Click on Select and choose Selection Pane. You will get a sidebar of all of the objects on the...
Forum: General Discussion March 23rd, 2011, 12:25 PM
Replies: 2
Views: 4,040
Posted By tarquinious
I have had this issue in the past when using Data...

I have had this issue in the past when using Data Validation dropdowns populated using the INDIRECT function to look up named ranges. You can select a value from the first dropdown, the second...
Forum: New Users March 16th, 2011, 05:56 PM
Replies: 2
Views: 8,036
Posted By tarquinious
Have you tried the MONTH function? It may work a...

Have you tried the MONTH function? It may work a little better, and gives you a negative value if the date is in the future instead of a "#NUM!" error.

Try:
=MONTH(M2)-MONTH($B$79)

If you have to...
Forum: Page Layout March 16th, 2011, 03:12 PM
Replies: 1
Views: 3,114
Posted By tarquinious
If you right-click on the text box and select...

If you right-click on the text box and select Format Textbox, change the Fill color to No Color and the text should sit on top of the picture. Also change the Line color to No Color to get rid of...
Showing results 1 to 25 of 34

 
Forum Jump

All times are GMT +1. The time now is 10:12 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.