Heya,
I've got a table that processes info from another raw data table.
I have converted my processed data table in to an Excel Table Object (the one you can drag down and it copies formulas).
My issue is that i have to update the raw data quite frequently and each time i have to manually drag my processed data table so that it can accommodate the new entries.
Can you please teach me a cool way to auto-extend my processed data table.
I'm not that good with Macros and VBAs, but very willing to learn.
Thanks,
Az.
I've got a table that processes info from another raw data table.
I have converted my processed data table in to an Excel Table Object (the one you can drag down and it copies formulas).
My issue is that i have to update the raw data quite frequently and each time i have to manually drag my processed data table so that it can accommodate the new entries.
Can you please teach me a cool way to auto-extend my processed data table.
I'm not that good with Macros and VBAs, but very willing to learn.
Thanks,
Az.