Hi
Trying to find a simple solution to this problem,
I have a table of data with only columns A,B & C, all columns have data that go on for ever. Column B should always have the same data in the same order.
The problem is some data from column B is missing and I would like to know if I can auto populate these (macro) with the missing data from an existing list but when adding data I need the whole row to be dropped instead of just column B and also add the value 0 in column C next to it.
I'm not sure if I've explained the issue clearly so here's a table to demonstrate this better:
Row 5 has 'Alpha' missing i'd like to add that with a 0 value as well in column C
same for after row 9 where 'Bravo' is missing.
<tbody>
</tbody>
Existing List
<tbody>
</tbody>
I hope there's a solution out there for this, Thank you.
AA
Trying to find a simple solution to this problem,
I have a table of data with only columns A,B & C, all columns have data that go on for ever. Column B should always have the same data in the same order.
The problem is some data from column B is missing and I would like to know if I can auto populate these (macro) with the missing data from an existing list but when adding data I need the whole row to be dropped instead of just column B and also add the value 0 in column C next to it.
I'm not sure if I've explained the issue clearly so here's a table to demonstrate this better:
Row 5 has 'Alpha' missing i'd like to add that with a 0 value as well in column C
same for after row 9 where 'Bravo' is missing.
A | B | C | |
1 | Any | Alpha | 1 |
2 | Any | Bravo | 4 |
3 | Any | Charlie | 54 |
4 | Any | Delta | 52 |
5 | Any | Bravo | 7 |
6 | Any | Charlie | 4 |
7 | Any | Delta | 8 |
8 | Any | Alpha | 258 |
9 | Any | Charlie | 2 |
<tbody>
</tbody>
Existing List
Alpha |
Bravo |
Charlie |
Delta |
<tbody>
</tbody>
I hope there's a solution out there for this, Thank you.
AA