Forum Discussion
Reflect all activity happening on Master Excel sheet to the Copy of same Master excel sheet
I have an excel workbook that contains a "Master" sheet. I want to simply copy the data from the "Master" Sheet and create a copy of the "Master" Sheet. I was able to achieve that easily using condi...
It is a bit difficult to follow your description without an actual spreadsheet in front of us. Is it possible for you to post it?
That said, although what you're asking may indeed be possible via VBA or macro--I avoid them unless absolutely necessary personally, in favor of functions that don't need to be debugged.
In the absence of a sample of your files, let me refer you to the recently released FILTER function, that may be able to do what you're asking. https://www.youtube.com/watch?v=9I9DtFOVPIg. This does require the most recent version of Excel, but you're able to draw selected rows of a table from one sheet to another using various criteria.