How to put data from one consolidate excel sheet to 3 different data table present in 1 sheet

Hello i have 2 excel sheets in which 1st one have consolidate sales of all stores and another have different data table on same sheet for company i want to get data from sales sheet and put data into stores sheet i am attaching sheets please checkSales.xlsx (9.2 KB) Stores.xlsx (9.5 KB)

Hi @Sheeraz_Areeb,
First read the sales excel using read excel activity range give B3. So you will get the datatable

Next use append range to write the data into another excel sheet.


But i have to put data into 3 different tables present on same sheet please open and check sheet
Thanks for replying

You want to read everything into a datatable, and then filter on that datatable once for each of your stores. In the attached project, I have only done it for the Zara sales.
Then, insert the result of the filter into the other .xlsx at a defined position (“A3” for zara), and you should be good to go.
Hope it helps :slight_smile:
-Jeppe (16.9 KB)

Thanks that solved my problem

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.