I have a parent Excel workbook that contains multiple columns on the sheet.
There is a 'Total Income' cell per column along with each column having 4 cells for Fed tax, State tax, Medicare, SS.
I have a child Excel workbook (1 sheet) where I have an income cell where if I enter an amount, 4 cells each will calculate the Fed tax, State tax, Medicare, SS amounts respectively.
When the parent is opened, I am looking for the parent to dynamically call the closed child for each of the 4 income cells (passing the parent’s Total Income cell’s amount) and have the child pass back the 4 calculated amounts respectively (Fed tax, Sate tax, Medicare, SS) to the parent and populate each column having 4 cells for the Fed tax, State tax, Medicare, SS.
I am not using VBA. Do I need to and learn it? If so, how do I access that functionality in Excel 2010?