How to append data with Vstack

Want an easy way to append data?

Use VSTACK

Select your ranges
Ranges with fewer columns have #N/A
Use IFERROR to remove the #N/A
Your ranges can be anywhere in the worksheet or Workbook

Did you find this tip useful?
Like, Share, Comment.

___________

Get this ready-to-use Excel solution for 2 and 3 columns of Dependent Dropdown Lists:

-------------------------------------------------------------------------------------------------------------

Celia Alves - Microsoft MVP & Certified Excel Expert,
Instagram: @solveandexcel



#MicrosoftAmbassador #excel #msexcel #exceltraining #msexceltraining #powerquery #powerquerytraining #dataanalysis #snapreports #solveandexcel #automation #reportautomation #VBA #exceltips