Robert Smith said Hi David This routine attached will copy data from sheet1 to sheet2 You can use partial search as well in the input box on the u...
Hi Mynda Thanks for that but I want it to copy the rows with a certain word, in this case Starter,included in one of the cells in the row. The o...
Hi Anders The table I started with had months in the Column headings and Topics as Row headings and that is how our data is collected. But are y...
Hi Anders Thanks very much for that attachment that is good. But I had problems showing the Months as April to Dec 2018 and Jan to Mar 2019 it kept...
Thanks Blanka But this didn't do anything I opened it in Excel and saw all the #Value! in all the cells and the formula in the cell were like this ...
Thanks Anders That is the formula I have and if the workbook is open that works but can I use a formula when the workbooks are closed so I don’t ha...