HI Hardik,

Look at the DataTable command

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Hardik Shah" wrote in message ...
| Hi,
|
| I need formula for below mentioned query:
|
| I am having very big calculation in Sheet-1. If i will give input in A1 & B1
| of Sheet-1 i will get answer in C1 from very big calculation.
|
| Now, i am having Sheet-2 which is having various combination of input
| required in A1 & B1 of sheet-1.
|
| What i need is, i wanted to put formula in sheet-2 as per below:
|
| Put value of Sheet-2 A1 & B1 in A1 & B1 of sheet-1 and write answer in C1 of
| Sheet-2 from C1 of sheet-1.
|
| if you need to understand problem further please provide your mail ID so
| that i can explain to you more.
|
| Regards,
|
| Hardik