Please Help With VStack

**KaylaP** · 06-24-2022, 07:26 AM

Hello,

I was trying to alter the range for the solution to my calendar events that AliGW provided but ran into errors with the VStack formula.

I would appreciate if someone can explain how this works and how to correct my issue that I am trying to combine events and dates.

The formula is in cell D4 of the Activities sheet.

Thank you kindly

**XOR LX** · 06-24-2022, 07:41 AM

Hi,

Is the issue simply that you don't have access to that function yet (which is only available to subscribers to the Insider Channel)?

Regards

**KaylaP** · 06-24-2022, 07:43 AM

I don't know what it is. Perhaps there is another way to get the data from the other ranges to combine?

**Fluff13** · 06-24-2022, 07:59 AM

If you Type =vs in a cell is VSTACK one of the options?

**KaylaP** · 06-24-2022, 08:02 AM

No it is not one of the options.

**AliGW** · 06-24-2022, 08:04 AM

I did say in your original thread, where you SHOULD have asked this question, that it is available only to beta channel insiders. This is why I offered a PQ alternative. I understood from your responses that it was working.

Please continue in the original thread - this one is being closed. Thanks.

https://www.excelforum.com/excel-for...-calendar.html