MULTIPLE CALCULATION
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 |
MULTIPLE CALCULATION
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 |
MULTIPLE CALCULATION
On Apr 21, 1:52*pm, Hardik Shah
wrote: Dear Niek, Thank you for your reply. But still i am not getting what i required. I have sent you mail with the excel sheet on mail ID : Please check and revert back. "Niek Otten" wrote: HI Hardik, Look at the DataTable command -- Kind regards, Niek Otten Microsoft MVP - Excel "Hardik Shah" wrote in ... | 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- Hide quoted text - - Show quoted text - Hi Hardik, Word of caution. Don't send file attachments to anybody without their prior consent. AND do not post anybody's mail id directly in NG. It will flood their mail box with thousands of spam mails. Regards, Madiya |
All times are GMT +1. The time now is 02:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com