Search results for query: *

Hi, I'm very new to VBA/Macros and I'd appreciate some help with this please. I've got a spreadsheet with sites and their areas in the same column. What I'd like to do is to cut the site and paste it to the right of the first instance of the matching area for that site e.g. Denver Yellow Red...

thread68-1668743 We are trying to make allocating tasks to employees fairer so that no-one is given more onerous tasks than anyone else. I've got a workbook with 8 worksheets - 7 for days of the week - which the supervisors enter names against specific daily tasks, the other has data linked from...

Can anyone help please? I've got a workbook with several worksheets, there are 2 that I need to link. In one I have a list of dates(in column),and in other columns I have items:- Date Drawsheets Pillows C/Panes 12/8/08 10 20 5 14/8/08 20 20 6...

Sorry - but the question's got to be asked !! We've got a spreadsheet that we enter simple daily data in e.g. if someone is off sick for 1 day the entry is 1, if their off for 2 days, the entry is per day i.e. 1, 1, and then totalled in the end column. What we want to be able do is to have a...

I,ve created a file in Word 2000, and have inserted hyperlinks (as bookmarks) that relate to this document only i.e. no external links. When a user opens this file in Word 2003 the hyperlinks are not active. Is this a general version glich ?? Any help would be appreciated

I've not used Word for creating forms, but I'm wondering if an on-line (intranet)form could be created with an automatic number generated i.e. 0001, 0002 etc. Any help gratefully received. Thanks

I've got a list (range) of ages from 30 to 64, and I want to group them from say 30 to 39, 40 to 49 etc. I've tried SUMIF, and COUNTIF, but I'm getting stuck on how to get the IF bit of the argument e.g if (range)>30 and <40. Any help would be gratefully received Thanks and regards

Hi - Can someone help please. When we set up deadlines for tasks/meetings, sometimes the recipients miss the deadline for one reason or the other. Is there any way that automatic reminders could be sent automatically,and to appear on the recipient's PC screen or inbox, at regular intervals ...

I'm setting up a spreadsheet to track sickness absence, and have the usual 'FROM' 'TO' headings, with the dates formatted as date, and the third column heade 'NO. of DAYS ABSENT, formatted as number. Works OK when a date is from, say, 3rd March to 5th March, but not when there is only a single...

My colleague has his mail messages delivered to his inbox. He wants to have any c.c. e-mails delivered to another location. Is this possible please ? Thanks, and regards.

Can anyone help please. When I want to use a pick (drop-down) list in Excel I can only base the list from data on the current (active) sheet. Is there any way that data from another sheet/workbook can be used. Thanks Clive

Please help ! I've (crudely) started a table in Excel to record training/renewal dates, as below, with the 'Valid For (Years)' data selected from a drop down list of 1,2 or 3(Data/Validation/List). C6 D6 E6 Date of Training Valid For (Years) Renewal Date...

I've just started using MS Binder to collate documents of different formats (Word/Excel) etc. When I try to print the binder it only prints the first section(page). I've tried the options of 'All visible sections' and also 'Section(s) selected in left plane' but it stil only prints the first...

I'm looking to send a Word document via e-mail to several userson our intranet(First user completes their part of the form then forwards it to second on list etc). Ideally it would be advantageous if the users could only access that part of the document (section) that they are going to complete...

What I want to do is to e-mail a Word file to colleagues, that is linked to source data in Excel, at the start of the year, and I would like to be able to amend the excel file say.. monthly, and for the data in the Word files at the other locations to be updated automatically. Is this possible...

I would like to send an e-mail or a task, with an attachment (Web page for weather forecast) on a daily basis to 2 colleagues that are users on our intranet. Is it possible for this to be sent automatically please ? Thanks,

Help Please ! I'm trying to create a hyperlink in a Word document that will link to a task in Outlook - any ideas please. Thanks Llwynog

There was a problem with a pst file for a user that stores their work on the C drive. Their pst file was 1.5Gb+ and showed up as being corrupted. I ran scanpst.exe and then the repair. I'd like to break down the existing pst file into more manageable 'chunks' - can anyone help please. Thanks