xcell | Tiny library for building reactive | Runtime Evironment library

The following VBA code bolds cells that contain a specific phrase. Is there something that i can use in Google Sheets that will have similar output?

I am using below code.

I have an Excel worksheet called "Main" which includes a set amount of columns, one of which contains a listing of different codes (CVE's) regarding patches that need to be installed on worksheets based on criteria from the internet.

The codes to search for are not in a set format, other than being in strings containing the code.

I manually created a number of worksheets based on keywords in these strings, that will eventually, contain all the lines from the master sheet, but only those defined by the name of the keyword I want.

For example, I have a worksheet named "Microsoft" that should contain all the rows from the master sheet that refer to Microsoft CVE's, based on a search of the string and finding the word "Microsoft". Same for Adobe and so on.

I created a script to copy the rows, as well as create a new Index sheet that lists the amount of rows found for each keyword that have been copied from the master sheet to the relevant sheet.

And this is where I get lost.

I have 18 worksheets which are also keywords. I can define a single keyword and then copy everything over from the main worksheet for one keyword.

I need a loop (probably a loop within a loop) that reads the worksheet names as defined in the Index, searches for all the relevant rows that contain a CVE regarding that keyword, and then copy the row over to the relevant worksheet that I created into the relevant row on that worksheet.
For example, if I have copied two rows, the next one should be written to the next row and so on, until I have looped through all the worksheet (keyword) names and have reached the empty row after the last name in the Index sheet.

My code, set for only one keyword for a limited run to test works.
I need to loop through all the keywords and copy all the data.
In the end, I want to copy the relevant row from the master worksheet (Main) to the relevant worksheet (based on keyword worksheet name in the Index worksheet), and delete the row after it was copied from the master worksheet.
I should end up with all the data split into the relevant worksheets and an empty (except for headers) master worksheet.

This is what I have so far (from various examples and my own stuff).

'this is what I have so far and it is only sending the one row over not the one before it. I don't think the offset code is working.

First of all, I have difficulty in explaining because my English is not very good. But I will try to explain as best I can.

I add random photos to the canvasta cells fields with Javascript.

Each plot is equivalent to 20pixels. What I want to do is: if i and y in the map data are equal to 4; I want to add the photo I want to a 4x4 area.

In other words, while adding a photo to 20 pixels; I want to add a photo to a 320pixel area when it is 4x4.

As in the sample photo. Check Photo

So, i wrote some code, that queries through every table and returns text value of cells in arrays. I've also been trying to come up with solution, which won't need jquery. Is there any way to do so?

I have created an ADO Recordset from a Range of a Worksheet as shown below that I want to custom sort on Groups field, Then Type field. The Sort Order should be such that, the values of Groups column should be arranged in a custom order as given in another worksheet range column Status1 AND the values of Type column should be arranged in a custom order as given in another worksheet range column Status2 for e.g. :

I am trying to use VBA to change the formatting of a worksheet. I need to do 2 things:

1. Change the font when a cell has a large amount of text
2. Change the font when a cell contains a bullet character: " • "

I've been able to accomplish 1 below, but can't figure out 2:

I am struggling with applying a previous bit of code I have used for the same process in a different workbook.

The process is that I have conditionally formatted a set of information (now on a different sheet) to change colour based on whether either "Lab" or "Office" is selected from the drop down list.

I then wanted (what I believe this code should do however I don't believe I have linked the series correctly) the graph which the information is in relation too to change the relevant data points to that colour, highlighting that on this floor you have selected "Office" or "Lab".

The code I am using starts here: