Hello,
I need help with a spreadsheet form, at my workplace I have Certificate to be filled in, so far manually, using other spreadsheet with information(Data Sheet). Both are forms not tables so there are lots of merged cells in them and have different layout, and I would like to make Certificate to auto populate with info to save time and avoid possible errors while typing.
Ideally it would looks for reference like order no. or customer in one(Data) and copy value/text to Certificate in right place.
Also if it's possible I could use the same master Certificate spreadsheet to be able to use multiple times with other spreadsheets(datas).
All Data sheets have the same layout, just different values.
Thank you
I need help with a spreadsheet form, at my workplace I have Certificate to be filled in, so far manually, using other spreadsheet with information(Data Sheet). Both are forms not tables so there are lots of merged cells in them and have different layout, and I would like to make Certificate to auto populate with info to save time and avoid possible errors while typing.
Ideally it would looks for reference like order no. or customer in one(Data) and copy value/text to Certificate in right place.
Also if it's possible I could use the same master Certificate spreadsheet to be able to use multiple times with other spreadsheets(datas).
All Data sheets have the same layout, just different values.
Thank you