Jun 22 2021 10:36 AM
I am stuck in copying or linking data in between different sheets.
please help.
please open the file to understand the nature of the problem.
Jun 22 2021 11:02 PM
@subhaNew I believe Power Query can fairly easily do what you need. With a slight modification to the data table you can create output similar (though not exactly the same) to what you described in the FOIL tab. See for yourself in the attached file.
Jun 24 2021 07:15 AM
Jun 24 2021 07:31 AM