I am trying to make a shortcut to filling out checks for my work. Everyone(where) we write to checks to has a specified number. For the checks, we put in the specified number and address (street, city, state, and zip all in different cells).
I am wondering if there is a way to just put the specified number in a cell, and the other cells automatically fill with the address.
For example:
Frank is #390
123 Apple St.
Sunnyvale, FL 12345
If I punch 390 in cell A1, is there any way to auto fill the rest so that A2 is '123 Apple St.', cell A3 is 'Sunnyvale', A4 is 'FL', and A5 is '12345'?
Bookmarks