Solved: Re: copy table from one sheet to another sheet in ...

barney1234 · ‎08-02-2021

hey guys.

is there anyway to copy the the same table from on sheet to another sheet in the same excel file?

Mira_Ghaly · ‎08-02-2021

Yes you can , so what you need is simply format the data in your first sheet as Table and say it will be called Table 1 and the same on the another sheet as Table and lets say it is called Table 2, Then using the Excel connector, Use List Rows Present in a Table to get records from Table 1 and then loop on them and use Add Rows in a Table to add a new row in Table 2.

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

View solution in original post

Mira_Ghaly · ‎08-02-2021

@barney1234

Yes you can , so what you need is simply format the data in your first sheet as Table and say it will be called Table 1 and the same on the another sheet as Table and lets say it is called Table 2, Then using the Excel connector, Use List Rows Present in a Table to get records from Table 1 and then loop on them and use Add Rows in a Table to add a new row in Table 2.

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here