GOAL SEEK
GOAL SEEK is an excel in built in what_if_analysis tool that shows how one value is a formula impacts another.THE GOAL SEEK changes the variable to study the variation in the results……
It also determines what value you should input in a cell to get the desired results in a formula..
Steps or guidelines
SET UP YOUR DATA SO THAT YOU CAN HAVE A FORMULA CELL AND A CHANGING CELL DEPENDENT ON THE FORMULA CELL..
GO TO DATA TAB CLCIK ON WHAT_IF_ANALYSIS AND SELECT GOAL SEEK
IN THE GOAL SEEK BOX,DEFINE THE CELLS OR VALUE TO USE AND CLCIK OK
MERGING TWO WORKBOOK INTO A SINGLE WORKBOOK
*PREPARE TWO DIFFERENT WORKBOOK THAT YOU WANT TO MARGE INTO A SNGLE WORKBOOK
*ONCE DONE PREPARING THE TWO WORKBOOKS , CREATE ANOTHER EMPTY WORKBOOK
*SAVE BOTH FILES INTO A SINGLE FOLDER
*COPY THE CODE REQUIRED TO MERGE THE WORKOOKS
*OPEN THE EMPTY WORKBOOK CREATED ,PRESS “ALT” “F11” TO OPEN MICROSOFT VISUAL BASIC FOR APPLICATION EDITOR
*ONCE OPENED CLICK INSERT THEN “MODULE”
*CLICK ON RUN THEN SELECT THE FOLDER IN WHICH THE WORKBOOKS ARE SAVED
*THEN CLICK ON THE EMPTY WORKBOOK AND CHECK THE SHEETS FOR THE REQUIRD INFORMATION OR DATA
