#1
|
|||
|
|||
Automatic goal seek program-Help required
Dear Experts
I am new to this forum and this is my first view on word macros and VBA.I am also Excel beginner. I don't know how to write automatic goal seek program in excel 2013. So from my large spreadsheet I simplified my requirement in another file for better understanding. I have an input value from 'Input value' sheet that goes to a goal seek tab. If I input a value in 'Goal page'Cell F16 (blue colour in Goal page tab)- that should automatically adjust the input value tab "cell E7 " to get result number in (Mainpage tab) "Cell H7" For every variation in blue cell F16 (sheet 1) - Auto goal seek should change itself to bring same value in Green cell H7 (sheel 2) by adjustin a cell E7 (sheet2) Please let me know the step by step procedure to create this. I don't know if i need to create a button. I attached this spreadsheet now Please guide me the process and i will learn more. Regards Bala |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel VBA Multiple Automatic Goal Seek Required – Please Assist us | champaben | Excel Programming | 13 | 06-22-2014 05:54 AM |
set daily goal for actual workdays, excluding weekends holidays and days off | Brian Reilly | Excel | 1 | 01-24-2014 11:56 PM |
Activation required, except I've already done that? | Mir | Office | 1 | 04-01-2013 06:38 PM |
Adding a goal line to a chart | uhlersa | Excel | 1 | 01-16-2012 08:18 PM |
Formula Help Required | OTPM | Excel | 6 | 08-31-2011 02:58 AM |