Search results for query: *

Thanks 'bluedrangon2' that works a treat! Just had to adjust it a little as my cols were further apart.

Thanks, but that doesn't quite work. It only returns one value no matter what (the value of ws1!B2). Maybe I have not explained it properly. WS1: Col1 Col2 Row1 RO £1000 Row2 B £800 Row3 B&D £600 Row4 FB £400 Row5 AI £200 WS2: Row1/Col1='I...

I'm trying to create a IF or LOOKUP function, but not getting very far as I am not very good with functions! I want to look at a specific cell on Worksheet 2, and if it contains a certain value (eg. "B") then the value from a specific cell on worksheet 1 will appear in a specific cell...

Ah! Not to worry. I found a KB article that has fixed it. http://support.microsoft.com/default.aspx?scid=kb;en-us;257643&Product=wrd97

The spell checking facility in MS Word 97 is missing when I am logged on as a normal usser. If I am logged on as an Administrator then all is OK. Does anyone have any ideas why this is happening?

Dale, Thanks for the code. It was extremely useful and did the trick nicely. It only took a few minutes to set it up and then I could print page 1 of all 100 worksheets with just a click of a button. (Why oh why did Microsoft not have more printing options in Excel!) You've definitely...

I've tried highlighting all of the worksheets and then printing from page 1 to page 1, but I only get the first page of the first worksheet. Any other ideas?

Hi there! I have an excel file that consists of around 20 worksheets, each having two pages on them. I want to print out the first page of all the worksheets. Is there an easy way to do this?

Perfect! Many thanks [bigsmile]

Hello!! There is probably an easy answer that I just can't see, but I'll ask anyway! I have a table containing various data (customer name, ref number, parts, etc..). I have created a form that allows me to pick a customer from a combo box and then choose to either display a report for that...