Search results for query: *

Thanks for your suggestions [thumbsup2] hwyl Jonsi B-) "If an apple a day keeps the Doctor away ...why don't Daleks live in Orchards?"

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

found it! Should have done a SEARCH on here beforehand =IF(COUNTIF(Incomplete!B:B,JobCourse!M4)=0,"Completed","INCOMPLETE") hwyl Jonsi B-) "If an apple a day keeps the Doctor away ...why don't Daleks live in Orchards?"

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

Problem solved using Excel Macro - Inserting a row above the row where data is dumped as part of a 'go fetch from source' Macro. Thanks for your help. hwyl Jonsi B-) "If an apple a day keeps the Doctor away ...why don't Daleks live in Orchards?"

I think I've come up with a solution and I don't know why I didn't think of it before... If I start the Macro in the Summary Workbook and 'go fetch' the OUTPUT range from the source file then this will work up to the point where it dumps the data back in the Summary File. As the Macro always...

not far off ...the files, although using the original template, create a legal record in their own right. To have them just as a line in a database doesn't achieve the same thing. Each record (or several records) could come from one of several locations. hwyl Jonsi B-) "If an apple a day keeps...

Without getting into the weeds, I think what you're trying to do now is: •Go from one original source •to multiple outputs •from those outputs to one summary If you really need the different outputs, then I suggest you do more like: •Go from one original source •to multiple outputs •from THE...

not certain I need VBA ... Guess I should have written this bit earlier .... Several workbooks (differently named) will be opened, each identical in structure (they will all have used a copy of the same original workbook) but with different data in the OUTPUT range. I need to then collate that...

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

Thanks Skip ...If I can't do something with Word I'll try Excel hwyl Jonsi B-) "If an apple a day keeps the Doctor away ...why don't Daleks live in Orchards?"

Thanks Paul Doesn't give me what I need sadly. I need the Master ComboBox to bring up another question not just another Slave Combobox hwyl Jonsi B-) "If an apple a day keeps the Doctor away ...why don't Daleks live in Orchards?"

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

Thanks for your advice Skip ...much appreciated. Jonsi hwyl Jonsi B-) "If an apple a day keeps the Doctor away ...why don't Daleks live in Orchards?"

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

Mathematically it would be wholly wrong try this 7 whole numbers summed that equal 25 :3,6,3,3,5,2,3 then look at the average 25/7 = 3.571429 5 whole numbers summed that equal 25 :5,5,4,6,5 then look at the average 25/5 = 5 Average those two numbers summed 8.571429/2 = 4.2857 Now divide 50...

firstly, to get 00102 to read as 00102 and not 102 format your cell Highlight the cells to be formatted Right Click, choose Format Cells... Select Custom In the Type box key in 00000 (5 zeros) click OK Set a Filter to allow you to show/not show the blank cells Select the column click on filter...

As ever Skip your advice was A1. INDEX & MATCH works a treat. Never used it before but I can see it saving me a lot of time in the future. Have a Star! thanks Jonsi hwyl Jonsi B-) "If an apple a day keeps the Doctor away ...why don't Daleks live in Orchards?"

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