I have a workbook that I need help with.
When you enter a new name to the last cell in the last row of a column in MasterLog, I want that name to copy to another cell in the second sheet. I would like to copy the name for a total of 5 times. Both sheets have data in many other columns too. This is the dummy WB for you. (no color formatting needed, I just colored it to help understanding)
If we can do this in a formula that would be great. Is it possible in formula?
Have a look here. DummyCopyLastEntry.xlsx