Recent content by jonsi

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?"