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