Hello All,
I am trying to read values from cells in column ("seller") column A one by one and filter multiple pivots with same filter i.e. ("seller name") using the cell value. Post which it should send an email to email id from adjacent column i.e. column B.
In short the macro should select a value from cell A2, filter all pivots with cell A2 value in sheet "pivots" then pick email id from cell B2 and trigger email for sheet Dashboard.
I tried multiple codes but i have not come to any conclusion please help. It is a critical project for me for automation
I am trying to read values from cells in column ("seller") column A one by one and filter multiple pivots with same filter i.e. ("seller name") using the cell value. Post which it should send an email to email id from adjacent column i.e. column B.
In short the macro should select a value from cell A2, filter all pivots with cell A2 value in sheet "pivots" then pick email id from cell B2 and trigger email for sheet Dashboard.
I tried multiple codes but i have not come to any conclusion please help. It is a critical project for me for automation
