Ability to send data visuals to their own tabs within excel

Hello,

Please bear with me as I provide a simple example, and the eventual solution I am trying to obtain.

1. I have pulled in some data via SQL.

2. I have created two seperate visuals (tables) where I have placed a filter on the 2 visuals to display only certain data within the visual

    Example: 

    Visual One: Filter where "columnA" = "Yes"

    Visual Two: Filter when "columB"  = "Yes"

3. I have been playing with R code and the openxlxs library to try to get the data from Visual One to export to a specific tab in excel, and the data from Visual Two to export to a different specific tab in excel.

It is possible, using R code and openxlsx to perform this function? I can supply any generic screenshots if needed.