Data validation account cell

post

#1

Hello.
Just started using datadear for xero.
Is there a way in the GL account cell to type in the account code and it auto completing as you type instead of having to select it from the drop down?


#2

Hi

This drop-down cannot change into an auto-complete as Excel does not provide such functionality. Maybe you can copy and paste the data (always use paste as values) as long as it’s in the exact format as written in the drop-down it should work.