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...

Thanks for your replies. Yogia - sample data - where would you like it sent please. Xhelp - you are quite right - this is not the best way of dealing/recording absenteeism. however it's only a stop gap measure before we go onto an Electronic Staff Record system. I use two worksheets to hold...

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

We've got a similar problem and would be grateful for any help. When we send out invites for meetings the invitee accepts and the acceptance is transferred to their personal calendar, but not to their public calendar (folder). Is there any way in Outlook 2003 that will allow for both calendars...

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 wonder if you could help me with a date function problem that is similar. I want to calculate how long an employee has to work until he/she is 65 years of age i.e. Date of Birth (formatted YYYY) + 65 years - I know this sounds simplistic - but so am I !! (ha ha) - but I'm stuck on what looks...

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,

I've only just seen this forum - fascinating. Fascinating because I thought that the english language was to be made use of (rather than confuse !). The bottom line is, that if I don't know the meaning of a word, I look it up - in a dictionary ! Surely not so difficult - even for 'techies' Regards,