Hi,
I'm making a kind of control panel in Excel with buttons to do different actions automatically.
What I'm looking to do now is press a button and say go to workbook x look at sheet x -> look the amount of cells that have data and extend in sheet x and resize the table to the same amount
Example:
Go to workbook: template bo4 extract.xlsx -> Sheet: base 2
Look at column "A" = 173720 rows with data
Now go (same workbook) to sheet CA TOT
Extend or shrink table (with formulas) to the same amount -> Important it needs to extend the formulas with it and if shrinking it needs to delete the formulas that are N/A anymore
Is there a way to do this? I hope I explained it well enough.
All this is done from another workbook so important to say go to workbook x
Thnx,
David
I'm making a kind of control panel in Excel with buttons to do different actions automatically.
What I'm looking to do now is press a button and say go to workbook x look at sheet x -> look the amount of cells that have data and extend in sheet x and resize the table to the same amount
Example:
Go to workbook: template bo4 extract.xlsx -> Sheet: base 2
Look at column "A" = 173720 rows with data
Now go (same workbook) to sheet CA TOT
Extend or shrink table (with formulas) to the same amount -> Important it needs to extend the formulas with it and if shrinking it needs to delete the formulas that are N/A anymore
Is there a way to do this? I hope I explained it well enough.
All this is done from another workbook so important to say go to workbook x
Thnx,
David