Push data, auto refreshed & manual key in

Dear all,

I have a cell W9 which will perform vlookup from other workbook by referring to the input at cell G8.

Cell W9 having the formula as following: =IF(ISBLANK(G8),"",IFERROR(VLOOKUP(G8,'C:\ server\engineering\drawings master list\[dwg master list current 2015.xls]CURRENT'!$D$5:$E$20000,2,FALSE),""))

Please be informed that cell W9 is actually a hidden cell (I colored the fonts to white, and lock it), user will not able to see it.
I need to do the following condition at cell W9 & X9.
1. Push and refresh the all data (inclusive blank) from cell W9 to cell X9 automatically.
2. If W9 is blank, then allow user to manually enter data at cell X9.
3. Data manually enter by user at cell X9 shall be refreshed to follow step (1) if G8 is refreshed.
4. Data manually enter by user at cell X9 shall be refreshed to follow step (1) if data at G8 is deleted or become blank.

Anyone here can help?
Deeply appreciate your input.

Thanks.

Regards,

James.

Hi James

I've seen your thread not answered for a week, I'll give it a try but...
I don't understand clearly your statement.

1.- What do you mean by "push & refresh"?....to clear it?
. If you have formulas, normally they are calculated automatically.

2.- if W9 is NOT blank, you need to lock cell X9 ?? and unlock it when W9 is blank?

3 & 4 .- X9 shuld be cleared when any ch

[I]'d like to help, but needing better info

Vicho