Hello All,
I'm trying to transfer calculated data between sheets (WEAPS_QUALS) in cell L28 and (ACT_MBR) Sheet Column BS4:BS500.
I want the data in the Calculated cell L28 or L30 to be transferred to the corresponding cell on the ACT_MBR Sheet. Shall cells L28 or L30 cell contain the formula or the formulas be on the data sheet (ACT_MBR)?
The Attached file contains the formula for the respective row. The First Method: with row 28 reflects the calculation from the ACT_MBR cell with the formula. The Second Method: Row 30 holds the formula in Cell L30 which then transfers the VALUE to ACT_MBR Sheet. It seems as the on sheet formula does not update the ACT_MBR sheet when in make a cell change. Would this method best be solved by a MACRO to facilitate he change?
Which method should be used/changed to best assure proper transfer of data. As I will be creating a filterable Report Sheet to include the Data and VALUES for all members.
I hope my request is clear and Thank you for reading my request.
V/r,
Jim
Bookmarks