If cell is empty do a lookup or else use the value in the cell.

[sungen99]

I am creating a program that is used to make projections based on historic data.

There are 8 actual input (A1-G1) but only 3 are required (A1,B1,C1) the rest are numbers based on historic data. What happens from time to time is that one of the NOT required numbers is KNOWN and therefore able to be entered.

I would imagine that the only way to do with would be to fill in your data. EACH line of data is a new item so there could be 1 or 1000 lines (again each line is a separate calculation) and click a button to run a macro? Would you need a couple of buttons then too? To “reset” the sheets if you fill in a one of the NOT required slots with data?????

Any assistance or direction would be really helpful on this.

Many thanks,
Ken

[naveenmarapaka]

Hi Ken, Can you be more specific of what is your desired result....

attachment would be better as well...


rgds

[sungen99]

This example is sort of reversed because I don’t know how to do it but it will give you an idea of what I am trying to accomplish
Basically A-C are required inputs to help establish the auto fill in (lookup) in F-G

How the sheet should REALLY look. Would be to have D-G EMPTY when you enter A-C.
When you click on the Process button Sheet3 is created that will take Sheet1 with it but replace all EMPTY cells with the actual values that you see in sheet now…. OR in the case of how it SHOUD look if I were to actually put something in say D2 (not the standard default) Sheet3 would show THAT value and not the default.
Does this make any sense. HA.

[naveenmarapaka]

sorry, I didn't get you........ it seems you require a macro to just to do copy and paste the sheet1 in sheet3 and fill the blanks with vlookup.....