hi,
I am having problems with a spreadsheet i use..
I need to be able to run a macro (dont think formula would suffice) that looks at the values in column G for blank cells.
For each blank cell i need to be able to copy the data from a cell in the same column but on a different row where the value of the cell in column A (on the row of the blank cell) is the same as the cell on the row of the cell in column G i want to copy from.
for example:
1 | hello | 010
1 | hello |
2 | hello | 020
4 | hello | 040
2 | hello | 020
3 | hello |
3 | hello | 030
4 | hello |
3 | hello | 030
the first blank will need to display '010'.
the second blank will need to display '030'
the final blank will need to display '040'
i hope this makes sense. any help is greatly appreciated.
thank you!
Bookmarks