Search results for query: *

I have an Excel Worksheet containing various details about products (about 500) I use this sheet to a WORD document using Merge. This is fine BUT... I would now like to add one or more of a dozen or so Images to the Merge, based on information in the Worksheet e.g. If Merge Field Img_Ref is A...

I have a sheet (JobCourse) with a long list (4,000 records) of all employees and which course they should attend dependent on their job I have another sheet (Incomplete) with a shorter list (750 records)of all employees and the courses they have not yet completed I would like to flag up those...

Good morning I have a Spreadsheet that is populated from a Form input. Choices from Drop Downs, Radio Buttons, Lookups and free text etc. All the outputs returned from those Inputs go to a range called OUTPUT on a hidden sheet I want to run a macro that copies all of this OUTPUT range and...

Good morning I have a Spreadsheet that is populated from a Form input. Choices from Drop Downs, Radio Buttons, Lookups and free text etc. All the outputs returned from those Inputs go to a range called OUTPUT on a hidden sheet I want to run a macro that copies all of this OUTPUT range and dumps...

I am creating a form in MS Word (Office 2007) for Users to answer various questions. Most will have a Yes/No or N/A answer which is fine to put in a Combo Box. A problem arises when one of those answers needs to trigger another question or questions - I have no idea how to do this, although I'm...

I'm not sure if this is possible using Excel but... I have an Input sheet which requires (amongst other similar bits of data) Location, Name, Date, Time, Department, Equipment. I have 10 Locations, each of which has different Departments, Equipment, Managers etc. Location, Name Date & time...

I have a series of records of appointments in Sheet 1 which is derived from another source (.CSV file) The records have formula driven output to indicate appointment type 1,2 or 3 against each of the dates in the record ... so far so good - Dates in col C, Output in col F Not every date has a...

Originally posted on the MS Office forum It is some while since I used a Macro in Excel but I have a lot of Data gathering from old .txt files that I need to do. I have lots of data from a logger output into a .txt file. I need to fetch all of the data from columns A:I and dump it into...

It is some while since I used a Macro in Excel but I have a lot of Data gathering from old .txt files that I need to do. I have lots of data from a logger output into a .txt file. I need to fetch all of the data from columns A:I and dump it into another file which contains formulas. the...

This question was posted on the MS Office forum but it was suggested that my answer lies in VBA I have a list of tasks on a simple worksheet that I'd like to use to generate an automatic email to various recipients as a reminder on a specified date. I know that I can import from Excel into an...

I have a list of tasks on a simple worksheet that I'd like to use to generate an automatic email to various recipients as a reminder on a specified date. I know that I can import from Excel into an Outlook Calendar which would be OK were it just me needing the reminder, but the reminders are...

I have a simple Excel attendance register. Each person has a worksheet within a workbook. Each worksheet shows 1 week per row with Sunday - Saturday in columns B-H. If someone is Present the cell entry is 'P' If someone is Absent the cell entry is 'A' If someone is Sick the cell entry is 'S' I...

I have a list of collections made, each with different dates and different amounts all input into Sheet1. Four Columns with the following headings: Date : Quantity : Ref : WeekNum : 02/02/13 : 250 : abc1 : 5...

I have a Powerpoint show that runs almost continuously displaying information about my site to a large screen. Most of the information is static but I want to have a new slide that shows variable information that it would get from an Excel worksheet. Example: Slide has pretty pictures'n'stuff...

I'm creating some simple .htm files in MSWord used on an local network (kind of intranet). These mainly use hyperlinks to direct other users to various files etc. but I now need to display some month-on-month sales information from an Excel file in graphical format on the .htm page. I'd like...

I have an Excel data table that contains information on workplace accidents. I have to make this workbook available to other users who do not understand simple Data Filters - (I think) macros assigned to radio buttons is the best (simplest) way for me to get them to make their filter choices...

I have a sheet that contains details of issues of fuel to various vehicles. Every time fuel is issued, a mileage reading is entered for the vehicles. I can summate the issues/costs etc. by vehicle for a given time period using a SUMPRODUCT string against WEEKNUM based on the date of the fuel...

I have a fleet service scheduler on a spreadsheet that resembles a year-planner. To get it to do what I want I'd have to have a vast number of cells each containing IF statements which is stupid to say the least and unwieldy at best. Scheduled vehicle services are marked in date headed columns...

I have a Macro in a Workbook that uses SaveAs on a dummy .csv file (XYZddmmyyyy.csv) that prompts the User to amend the existing Filename to a relevant one (changing the ddmmyyyy bit). It works fine on an Office 2K box returning the SaveAs box allowing a user specified filename, but on an XP...

I have a Network stored .xls file that opens fine on all bar 1 machine (File is 1.8Mb - 15 worksheets, many cross-linked, no external links). All I get is Eggtimer then, when I check Task Manager, I get Excel is not responding. Any (every) other XL file seems to open fine on this same box...