Search results for query: *

Thanks for your help! Not the ideal solution, but will save me time anyways!

I want to select all the sheets in my workbook and set the same print area for them all. Any idea how I can do this quickly and easily? I have already tried: 1. Selecting all sheets, Select FILE then PRINT AREA but SET PRINT AREA is greyed out. 2. Selecting all sheets whilst in "Page Break...

Thanks xlbo! That worked a treat! Le

I have a set of workbooks "T10", "T20", "T35" etc. all set up in exactly the same way, dates in column A and project numbers in row 1. For your information, project numbers in Book T10 start with 10, project numbers in Book T20 start with 20 etc. DATES 10344 10543 10641 10984...

SkipVought, I take your point about putting the source data in NORMALIZED form, and will consider this in future projects. However, there are many other sheets referencing the sheets I described previously and it document wasn't set up by myself originally so I don't really want to do a whole...

Maybe i'm using the wrong terminology, I'm sorting from left to right by doing the following: Data > Sort > Press Options button > select sort left to right > Sort by row 1 > press ok Here is an example of sheet 1: DATES PROJ CCC PROJ BBB PROJ AAA 01/01/05 10000 12000...

I have quite a large spreadsheet that i'm having problems sorting. In simple terms: I have two sheets in a workbook that are set up in the same way, dates are held in column A and projects across row 1. Sheet1 holds 'cash in' data and Sheet2 contains 'cash out' data. To save the user some...

Gerry, Although i'm not the originator of this post, i've been having the exact same problem as jmjj215. Thanks for the post, i've used a userform as you suggested and it works like a dream. Le

Shame! Oh well. Thanks for your prompt response anyway xlbo.

When using check boxes in excel, is it possible to change the 'tick' to another character, such as a cross? I've seen it done in word using vb, but am having difficulty finding any examples where it has been done in excel. Regards, Le

Nooooooooooooooooooooooooooooo! Self now seriously kicked! Cheers Geoff!

I am having a problem creating a formula when using custom in data validation. I want the entry in the cell A9 to be restricted to a 6 or 7 digit number or the text "O/H". I am using the following formula but it currently evaluates to an error: =OR(A9="O/H",AND(A9>=100000,A9<=9999999) Can...

Thanks guys! At least I don't have to spend hours trying to work out where I was going wrong! Le

I still require help with this post! Does anyone know how to get a read or delivery receipt when sending an excel workbook from vba? The code seems fine, but the receipt never arrives. Could it be something to do with my outlook settings? If the receipt boxes have to be ticked in my tracking...

I follow the values through the code and the variable AReceipt does set to True if the user presses Yes in the message box, however when the email is sent the receipt is never received. Here is the code I am using: 'Does the user want a receipt ReceiptRequired = MsgBox("Would you like a...

Thanks GlennUK! That worked a treat! Regards, Le

One further step, the original list can be added to by the user. How can I get the advanced filter to update when the list changes?

Try this website, it offers a free download for removing workbook and worksheet protection even if you don't know the password. It doesn't however, remove passwords to open a workbook. http://www.straxx.com/excel/password.html

Thanks Loomah! Much appreciated!

I want to use Data Validation to create a drop down list based on a list I have in a sheet. However, the list includes duplicates, and I only want the drop down to show each of the items once. Any ideas? LIST EXAMPLE: Fox Dog Cat Dog Rat Fox DROP DOWN TO CONTAIN: Fox Dog Cat Rat