How do we autofill Google Sheets templates with stock request data from different columns?

  • 30 October 2023
  • 1 reply

How can I make an autofilling of templates for my Google Sheets at Google Drive.


The algorythm is next, I`m receiving stock request from my pharmacy stock. After that I need to provide following documentation which called Donation Letter and Packing list with the same information, but location of the headers for columns is different and doesnt match to each other. Sometimes it could be 200 rows. And my question is it possible, or it`s easier and faster to create macros?

1 reply

Userlevel 7
Badge +14

Hi @Andrii Shkuratov 

Good question.

We would need to see screenshots with the assets involved to have more context.