Form Auto Fill

Hi Friends,

I am creating a spreadsheet with data entries that need to repeat in various other sheets in the same workbook.

What formula can I use to:

(1) Inset company name ones, and assign the company name to autofill in a separate workbook?
(2) Persons name
(3) Year

Please see attached workbook.

Kind regards,

Lukhanyo

Formula for other sheet value attached, in sheet2 B2 enter

Please Login or Register  to view this content.

HI,

Do you have instructions on how I can do this on my own? how and where do att the formula using the already inserted Excel Sheet?

thank you.

In the already inserted spreadsheet, pick a cell, type the other worksheet name followed by an asterisk"!", followed by the cell value, like "A1".

You can also select a cell where you want to enter the value, select the source worksheet and select the cell you want as source, and then hit enter.