First Last

First Last

  • 849
  • 648
  • 67.9k

How to pass a value to an Excel 2010 workbook and return values

Apr 5 2023 2:58 PM

 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?


Answers (2)