Hi,
So i have a workbook, two tables in it. in sheet1 there is a table called Table1, in sheet2 Table2. I want to copy Table2 and here's a code:
Sheets("Sheet2").Select
Range("Table2[#All]").Copy
Sheets("Sheet1").Select
Range("T2").Select
ActiveSheet.Paste
and it copies and pastes the Table2. Problem that i have is that i want to do something else with that pasted table and VBA keeps changing the pasted table names like Table21, Table 24.
Is there a way to name that pasted table to have always the same name (maybe it is worth mentioning here that Table2 has different numbers of rows depending on day the data is fetched)?
Thanks in advance.
So i have a workbook, two tables in it. in sheet1 there is a table called Table1, in sheet2 Table2. I want to copy Table2 and here's a code:
Sheets("Sheet2").Select
Range("Table2[#All]").Copy
Sheets("Sheet1").Select
Range("T2").Select
ActiveSheet.Paste
and it copies and pastes the Table2. Problem that i have is that i want to do something else with that pasted table and VBA keeps changing the pasted table names like Table21, Table 24.
Is there a way to name that pasted table to have always the same name (maybe it is worth mentioning here that Table2 has different numbers of rows depending on day the data is fetched)?
Thanks in advance.