look for empty/blank cells and copy data from another cell where the first cell....

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!

Hello

if you do the following it should give you what you need based on your example......

Assuming column A is the "lookup" value and Column C is the cell that needs to be filled.........


Sort the data by column A and then C. A can be sorted in any way but C must be sorted to show the populated values at the top.

Highlight Column C from the first Cell that needs to be populated down to the bottom.

Now click "Find & Select" from the "Home" tab, then "Go To Special" and choose "Blanks"

Now Type "=" (without quotes) and press the Up arrow

Press CRTL and Enter and it should populate all the values for you.

Hope this helps

Cheers

Jim