sjeter

04-29-2015, 09:37 PM

In an Excel Spreadsheet, I am defining data to be output into a 4 column matrix with 512 rows.

Each block of of the matrix can hold 12 individual bits of data

column1

column2

column 3

column 4

row 1

12 bits

12 bits

12 bits

12 bits

row 2

12 bits

12 bits

12 bits

12 bits

row 3

12 bits

12 bits

12 bits

12 bits

row 4

12 bits

12 bits

12 bits

12 bits

..

..

row 512

12 bits

12 bits

12 bits

12 bits

In the Excel Spreadsheet, I have already assigned many rows and bits of data similar to the layout below.

Now, I am needing a macro that I could run to find available bits, columns, or rows.

For example, in the definition below, visually it is apparent that rows 1, 2 and 3 are not yet defined so they would be available.

In row 8, columns 2 & 4 would still be available, and so on.

I am needing a macro to do this so I do not have to visually search as I start to fill in more of the definition.

Row

Columns

Start Bit

Stop Bit

4

all

1

7

8

1, 3

1

12

11

all

6

12

18

all

1

12

98

all

3

4

234

all

1

5

345

all

1

12

423

1, 3

1

12

Each block of of the matrix can hold 12 individual bits of data

column1

column2

column 3

column 4

row 1

12 bits

12 bits

12 bits

12 bits

row 2

12 bits

12 bits

12 bits

12 bits

row 3

12 bits

12 bits

12 bits

12 bits

row 4

12 bits

12 bits

12 bits

12 bits

..

..

row 512

12 bits

12 bits

12 bits

12 bits

In the Excel Spreadsheet, I have already assigned many rows and bits of data similar to the layout below.

Now, I am needing a macro that I could run to find available bits, columns, or rows.

For example, in the definition below, visually it is apparent that rows 1, 2 and 3 are not yet defined so they would be available.

In row 8, columns 2 & 4 would still be available, and so on.

I am needing a macro to do this so I do not have to visually search as I start to fill in more of the definition.

Row

Columns

Start Bit

Stop Bit

4

all

1

7

8

1, 3

1

12

11

all

6

12

18

all

1

12

98

all

3

4

234

all

1

5

345

all

1

12

423

1, 3

1

12